pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael Paquier <michael.paquier@gmail.com>
Cc: jens@wilke.org
Cc: pgsql-docs@postgresql.org
Subject: Re: adduser is missing --system
Date: Wed, 27 Sep 2017 18:46:07 -0400
Message-ID: <6000.1506552367@sss.pgh.pa.us> (raw)
In-Reply-To: <CAB7nPqRVxAkxKOKB-fpTjHOhNyOZOE8tKKw2bSyWySDQahZGdQ@mail.gmail.com>
References: <20170927213344.28558.2373@wrigleys.postgresql.org>
	<CAB7nPqRVxAkxKOKB-fpTjHOhNyOZOE8tKKw2bSyWySDQahZGdQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>

Michael Paquier <michael.paquier@gmail.com> writes:
> Please note as well that this has been added to the documentation of Postgres
> 10 with this commit:

Yeah.  I think Peter should back-patch that, but he hasn't yet.

The issue might be moot as of v10 anyway, because of this other commit:

Author: Tom Lane <tgl@sss.pgh.pa.us>
Branch: master Release: REL_10_STABLE [ecb0d20a9] 2016-10-09 18:03:45 -0400

    Use unnamed POSIX semaphores, if available, on Linux and FreeBSD.
    
    We've had support for using unnamed POSIX semaphores instead of System V
    semaphores for quite some time, but it was not used by default on any
    platform.  Since many systems have rather small limits on the number of
    SysV semaphores allowed, it seems desirable to switch to POSIX semaphores
    where they're available and don't create performance or kernel resource
    problems.  Experimentation by me shows that unnamed POSIX semaphores
    are at least as good as SysV semaphores on Linux, and we previously had
    a report from Maksym Sobolyev that FreeBSD is significantly worse with
    SysV semaphores than POSIX ones.  So adjust those two platforms to use
    unnamed POSIX semaphores, if configure can find the necessary library
    functions.  If this goes well, we may switch other platforms as well,
    but it would be advisable to test them individually first.

We didn't think about the systemd angle at the time, but this change
might make PG reasonably systemd-proof even without direct protection
from RemoveIPC.  I've not tried to experiment though.

			regards, tom lane


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs



view thread (4+ messages)  latest in thread

Message-ID: <6000.1506552367@sss.pgh.pa.us>
Permalink:  ../6000.1506552367@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/6000.1506552367@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, michael.paquier@gmail.com, jens@wilke.org
  Subject: Re: adduser is missing --system
  In-Reply-To: <6000.1506552367@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox