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 1pEs0A-00024v-3H for pgsql-general@arkaria.postgresql.org; Mon, 09 Jan 2023 13:15:46 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pEs09-0007Ek-04 for pgsql-general@arkaria.postgresql.org; Mon, 09 Jan 2023 13:15:45 +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 1pEs08-0007Ea-88 for pgsql-general@lists.postgresql.org; Mon, 09 Jan 2023 13:15:44 +0000 Received: from mail-qt1-x835.google.com ([2607:f8b0:4864:20::835]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pEs01-0001BV-9A for pgsql-general@postgresql.org; Mon, 09 Jan 2023 13:15:43 +0000 Received: by mail-qt1-x835.google.com with SMTP id s5so3301376qtx.6 for ; Mon, 09 Jan 2023 05:15:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=yeymZkyOoMd6xUbEO4SBc40XOrRCk7WWMf2Rxi6A8co=; b=bFUejw2N5coa8qXCPL1Sv7KQIBVYQ4C3XOBEDNGk9N93yOuMCzUv4kHYMnU9JGZ7SG GVOmPnhgqgVT+o//fRY+qutaZuGuT9sFo0naosS1uq9k/4SY59OMgnXXW5Gbr7BT5chG GSe4IaLHo3tZBRdrEwMk/m/HTMPm1oX1iURulbjX4zWExEZ1GgljqnZIKz2XfVrH9sDr vHcPtZNnl19vl8Xpc9QNgI2eYHEaTrX0+UFUedG6VgEU0nM7jS5uI+OWhVJC8xWRSRTx vBsbkz+fRclLNrAuNx74qnWqGK4j9n5cqLUm4JsjY7IlkzrXNU1BYJmf6KxGNABGiggo zuJQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=yeymZkyOoMd6xUbEO4SBc40XOrRCk7WWMf2Rxi6A8co=; b=kZqNaFpAxEYIjaxQlHvihJdmKCbVShE3ulEwtSZHnk/F2dSvu4fAug3FC+7Y20t0lH vV+M/yKglNB4x/qU4Um62QvuusSZiKJQwL4he9dM/3ypguKJtPQUOeXBPGfQsqvbSdt7 8PXom0JWW17P8HB38TjqBgvpmfuH42l5OlBweqFM0v79KOMQD7tXSaYMCDA89gHaFW3K zwdWdhwJjOZCQu/ZG07pN9H52HawrZeQCZLPywSfl62u2aHqSwn1G9S96spKevaQs4KW KIegoKOXdh8ekOVtks/bOYkGn5Y+73l0U4RtF+KhkBgq9fvv4PX3Is1O+TQ8i2Of0j1y 8qXA== X-Gm-Message-State: AFqh2kpPR+wyM6mmweq6katI7uftCx/wznJGgSTc83UwHpf+wB73IIg9 QhTcqASHnwNjNn71cZCwdlOgYfL0B+zZWpdT X-Google-Smtp-Source: AMrXdXtjIVgFmMLFWWHbPdJMA1vbUF78FQLlm+qWi6apwFtIzfFN8uJgkYugnLIolce3x/foq/r33Q== X-Received: by 2002:a05:622a:1646:b0:3a4:fddd:f8ef with SMTP id y6-20020a05622a164600b003a4fdddf8efmr118510284qtj.53.1673270135018; Mon, 09 Jan 2023 05:15:35 -0800 (PST) Received: from [192.168.4.41] (162-239-31-113.lightspeed.dybhfl.sbcglobal.net. [162.239.31.113]) by smtp.gmail.com with ESMTPSA id s24-20020ac87598000000b003a7e9db074asm4502748qtq.67.2023.01.09.05.15.34 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 09 Jan 2023 05:15:34 -0800 (PST) Message-ID: <29d6cd01-df1d-e009-9293-2229d5ba3d19@joeconway.com> Date: Mon, 9 Jan 2023 08:15:33 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.4.2 Subject: Re: How do the Linux distributions create the Linux user/group "postgres"? Content-Language: en-US To: Matthias Apitz , Postgres General References: <20230109124157.GA11@sh4-5.1blu.de> From: Joe Conway In-Reply-To: <20230109124157.GA11@sh4-5.1blu.de> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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<------------------- HTH, -- Joe Conway PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com