Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pEsBZ-0002lu-KH for pgsql-general@arkaria.postgresql.org; Mon, 09 Jan 2023 13:27:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pEsBY-0001uo-5T for pgsql-general@arkaria.postgresql.org; Mon, 09 Jan 2023 13:27:32 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pEsBX-0001uf-R9 for pgsql-general@lists.postgresql.org; Mon, 09 Jan 2023 13:27:31 +0000 Received: from ms-10.1blu.de ([178.254.4.101]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pEsBV-0001IJ-Bn for pgsql-general@postgresql.org; Mon, 09 Jan 2023 13:27:31 +0000 Received: from [178.254.11.41] (helo=sh4-5.1blu.de) by ms-10.1blu.de with esmtpsa (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1pEsBU-0003TS-Io; Mon, 09 Jan 2023 14:27:28 +0100 Date: Mon, 9 Jan 2023 14:27:19 +0100 From: Matthias Apitz To: Joe Conway Cc: Postgres General Subject: Re: How do the Linux distributions create the Linux user/group "postgres"? Message-ID: <20230109132719.GA9@sh4-5.1blu.de> Reply-To: Matthias Apitz References: <20230109124157.GA11@sh4-5.1blu.de> <29d6cd01-df1d-e009-9293-2229d5ba3d19@joeconway.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <29d6cd01-df1d-e009-9293-2229d5ba3d19@joeconway.com> X-Operating-System: FreeBSD 12.0-CURRENT r314251 (amd64) X-message-flag: Mails containing HTML will not be read! Please send only plain text. User-Agent: Mutt/1.9.4 (2018-02-28) X-Con-Id: 51246 X-Con-U: 0-guru X-Originating-IP: 178.254.11.41 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk El día Montag, Januar 09, 2023 a las 08:15:33 -0500, Joe Conway escribió: > On 1/9/23 07:41, Matthias Apitz wrote: > > Please note: I'm talking about the user and group "postgres" in the > > Linux OS and not in the PostgreSQL server. > > > > We're compiling PostgreSQL from source (actually 14.1) and distribute that > > to our customers. They're asked to setup user and group "postgres" > > before creating the cluster. As nowadays there are a lot of setup such > > things in bigger installations, like LDAP or AD, etc. I'd like to know > > how other installations for Linux deal with this? > > See for example the PGDG RPM spec file: > > https://git.postgresql.org/gitweb/?p=pgrpms.git;a=blob;f=rpm/redhat/main/non-common/postgresql-15/main/postgresql-15.spec;h=60cd42147a7563ba76c401643d0a7c79b59d2520;hb=HEAD > > 8<------------------- > %pre server > groupadd -g 26 -o -r postgres >/dev/null 2>&1 || : > useradd -M -g postgres -o -r -d /var/lib/pgsql -s /bin/bash \ > -c "PostgreSQL Server" -u 26 postgres >/dev/null 2>&1 || : > 8<-------------------