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 1pEs2W-0002GU-IU for pgsql-general@arkaria.postgresql.org; Mon, 09 Jan 2023 13:18:12 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pEs2V-00049H-Cw for pgsql-general@arkaria.postgresql.org; Mon, 09 Jan 2023 13:18:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pEs2V-000497-1b for pgsql-general@lists.postgresql.org; Mon, 09 Jan 2023 13:18:11 +0000 Received: from mout-u-204.mailbox.org ([2001:67c:2050:101:465::204]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pEs2R-0003xD-8k for pgsql-general@postgresql.org; Mon, 09 Jan 2023 13:18:10 +0000 Received: from smtp102.mailbox.org (smtp102.mailbox.org [IPv6:2001:67c:2050:b231:465::102]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-204.mailbox.org (Postfix) with ESMTPS id 4NrDyf1dLxz9sST; Mon, 9 Jan 2023 14:18:02 +0100 (CET) Date: Mon, 9 Jan 2023 14:18:01 +0100 (CET) From: Erik Wienhold To: Matthias Apitz , Postgres General Message-ID: <273828922.221693.1673270281402@office.mailbox.org> In-Reply-To: <20230109124157.GA11@sh4-5.1blu.de> References: <20230109124157.GA11@sh4-5.1blu.de> Subject: Re: How do the Linux distributions create the Linux user/group "postgres"? MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Priority: 3 Importance: Normal X-Rspamd-Queue-Id: 4NrDyf1dLxz9sST List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 09/01/2023 13:41 CET Matthias Apitz wrote: > > Hello, > > 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? Arch Linux uses sysusers.d[1] to create user postgres[2][3]. [1] https://man.archlinux.org/man/sysusers.d.5 [2] https://github.com/archlinux/svntogit-packages/blob/packages/postgresql/trunk/PKGBUILD#L204 [3] https://github.com/archlinux/svntogit-packages/blob/packages/postgresql/trunk/postgresql.sysusers -- Erik