Re: PSA: Systemd will kill PostgreSQL - Mailing list pgsql-hackers

From Bernd Helmle
Subject Re: PSA: Systemd will kill PostgreSQL
Date
Msg-id B969A89B16D6C12AEA554694@eje.land.credativ.lan
Whole thread Raw
In response to Re: PSA: Systemd will kill PostgreSQL  (Craig Ringer <craig@2ndquadrant.com>)
Responses Re: PSA: Systemd will kill PostgreSQL  (Craig Ringer <craig@2ndquadrant.com>)
List pgsql-hackers

--On 11. Juli 2016 13:25:51 +0800 Craig Ringer <craig@2ndquadrant.com>
wrote:

> Perhaps by uid threshold in login.defs?

systemd's configure.ac has this:

AC_ARG_WITH(system-uid-max,       AS_HELP_STRING([--with-system-uid-max=UID]               [Maximum UID for system
users]),      [SYSTEM_UID_MAX="$withval"],       [SYSTEM_UID_MAX="`awk 'BEGIN { uid=999 } /^\s*SYS_UID_MAX\s+/ {
 
uid=$2 } END { print uid }' /etc/login.defs 2>/dev/null || echo 999`"])

so yes, it's the definition from there.

> But then what happens for people
> who're managing users via a directory, who need to avoid conflicting with
> host-local UIDs, but also need some of those users to have systemd
> "system user" like behaviour?

We had this in the past in some setups and this would add another reason
for unexpected headaches...

-- 
Thanks
Bernd



pgsql-hackers by date:

Previous
From: Kyotaro HORIGUCHI
Date:
Subject: Re: asynchronous and vectorized execution
Next
From: Magnus Hagander
Date:
Subject: Re: [BUGS] BUG #14230: Wrong timeline returned by pg_stop_backup on a standby