Re: Postgres user UID and GID

2023-07-19 Thread Martin Baulig
Hello, I played around a little bit with that, and it seems like you'll end up getting two entries for the 'postgres' user in your /etc/passwd if you just ignore the warning. And the order doesn't seem to be consistent. Here in my current patch: https://gitlab.com/martin-baulig/forks/guix/-/co

Re: Postgres user UID and GID

2023-07-18 Thread Denis 'GNUtoo' Carikli
On Mon, 17 Jul 2023 21:35:00 + Martin Baulig wrote: > If I use the unmodified service and with the (operating-system (user > ...)) entry, it works sometimes, but not reliably due to having two > conflicting entries for the 'postgres' user. I see. So if I touch too much my system it could break

Re: Postgres user UID and GID

2023-07-17 Thread Martin Baulig
Hello, --- Original Message --- On Monday, July 17th, 2023 at 7:49 PM, Denis 'GNUtoo' Carikli wrote: > And for the record here's how I use a different architecture: I define > a package: > > > (define postgresql-14-i686-linux > > (package > > (inherit postgresql-14) > > (name "postgre

Re: Postgres user UID and GID

2023-07-17 Thread Martin Baulig
Hello, I had considered idmap before, but realized there might be a bit of a chicken-egg problem with it. Even though that likely doesn't actually exist because GNU Guix is smart enough about it, the circular dependency still feels weird: What I mean is that the NFS client would depend on the

Re: Postgres user UID and GID

2023-07-17 Thread Development of GNU Guix and the GNU System distribution.
Hi Martin, On Mon, Jul 17, 2023 at 11:44 AM Martin Baulig 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' u

Re: Postgres user UID and GID

2023-07-17 Thread Denis 'GNUtoo' Carikli
On Mon, 17 Jul 2023 18:06:04 + Martin Baulig wrote: > Hello, Hi, > I have a bit of an unusual setup, as I am running GNU Guix in a VM on > a Synology NAS. Unfortunately, their DSM software sucks quite badly, > but I am currently stuck with this hardware as I don't have the > budget to replac

Postgres user UID and GID

2023-07-17 Thread Martin Baulig
Hello, I have a bit of an unusual setup, as I am running GNU Guix in a VM on a Synology NAS. Unfortunately, their DSM software sucks quite badly, but I am currently stuck with this hardware as I don't have the budget to replace it. But I don't want to make any long-term commitment to their soft