From: Felix Lechner via "Development of GNU Guix and the GNU System distribution." <guix-devel@gnu.org>
To: Martin Baulig <martin@baulig.is>
Cc: "guix-devel@gnu.org" <guix-devel@gnu.org>
Subject: Re: Postgres user UID and GID
Date: Mon, 17 Jul 2023 13:23:41 -0700 [thread overview]
Message-ID: <CAFHYt55Zhui0Pbis_adbdcx8px-HXPmHTtvOiWRjZQuvxtyo_Q@mail.gmail.com> (raw)
In-Reply-To: <RrD2cW7f4zIlLXNndtt5-Vx4fGP7EWc4qXRs5rDZSL4HnPFiiHQhMyV4tSGLQiLgcLt6bNpvh0wqL82cpw4Kw9r8VFLJfNlih1Y-WJlvprA=@baulig.is>
Hi Martin,
On Mon, Jul 17, 2023 at 11:44 AM Martin Baulig <martin@baulig.is> wrote:
>
> I have decided to NFS-mount an encrypted shared folder
I use a similar setup and use Gocryptfs for encryption. How do you
encrypt, please?
> there is a tiny little problem with PostgreSQL:
> the UID and GID of the 'postgres' user needs to match that of the server.
Perhaps I do not understand the needs of your setup completely.
Doesn't 'idmapd' in NFSv4 address your conundrum effectively?
For performance reasons, I would discourage such a setup, though. It
would be better to run Postgres on the NAS, if it is an option, or to
replicate the database for backup purposes.
Kind regards
Felix
next prev parent reply other threads:[~2023-07-17 20:25 UTC|newest]
Thread overview: 7+ messages / expand[flat|nested] mbox.gz Atom feed top
2023-07-17 18:06 Postgres user UID and GID Martin Baulig
2023-07-17 19:49 ` Denis 'GNUtoo' Carikli
2023-07-17 21:35 ` Martin Baulig
2023-07-18 22:10 ` Denis 'GNUtoo' Carikli
2023-07-19 14:35 ` Martin Baulig
2023-07-17 20:23 ` Felix Lechner via Development of GNU Guix and the GNU System distribution. [this message]
2023-07-17 21:28 ` Martin Baulig
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
List information: https://guix.gnu.org/
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=CAFHYt55Zhui0Pbis_adbdcx8px-HXPmHTtvOiWRjZQuvxtyo_Q@mail.gmail.com \
--to=guix-devel@gnu.org \
--cc=felix.lechner@lease-up.com \
--cc=martin@baulig.is \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
Code repositories for project(s) associated with this public inbox
https://git.savannah.gnu.org/cgit/guix.git
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).