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 1pErw1-0001i7-4S for pgsql-general@arkaria.postgresql.org; Mon, 09 Jan 2023 13:11:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pErvz-0000uj-Lo for pgsql-general@arkaria.postgresql.org; Mon, 09 Jan 2023 13:11:27 +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 1pErvz-0000ua-9i for pgsql-general@lists.postgresql.org; Mon, 09 Jan 2023 13:11:27 +0000 Received: from mail-yb1-xb29.google.com ([2607:f8b0:4864:20::b29]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pErvv-00019B-Qa for pgsql-general@postgresql.org; Mon, 09 Jan 2023 13:11:26 +0000 Received: by mail-yb1-xb29.google.com with SMTP id c82so1182154ybf.6 for ; Mon, 09 Jan 2023 05:11:23 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; 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=XOcO2KbbrZJEFoc+MhPIv3S7jAxDk2JhX5s8JhKy8IU=; b=amw8bDIlVGMKy+TaKHuVbFbP06I2KyJwVrq8nlKZKvxVLqPN/h7PtjPNjTIOV5iucw LpTREy/IoooqIMQRt8O6c+NyYiwV/bGLp1lS/tDT3PzWVassaLiLLZTK9MB51MCq7YMh 9XQuavjj7E0L0WVcgHVf6QwX0UUdVM4sciBUpv4D48lbA+RJgAeeI2A9WcrFFVdI9z56 D3vMnekPHZhUZbVgY+GgdoaTrwDOIBHudnYFTzLtNcGwVfpKFyEdEBKEruwPjyEOXQ+u hLwviK2Xl8CgFuGMf65zfTH2i/zQsvPMGIOuXsVe+4GT43Z3Vv8immUS24DUyNfXl7H6 IPIw== 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=XOcO2KbbrZJEFoc+MhPIv3S7jAxDk2JhX5s8JhKy8IU=; b=G2EPmBKJ4twnJ58sBNYUe5bVZeYrynddeQuWimiCWu5uIgVN3V7drZ0NHSnJ1AK/aY qXLEx9kziz/PVosrTrKkhw2GCOboYbg+Wq6ttijsLJzszdOb1NttP9dcrbBT5I0+e8Nn 1+G9Qhrc+ggkoYfaWHR7wg9KJtaHikxGJZygHyE7aYqiitg3JRUlmC4YE+YmOVCC0aGn lghFcCY7k/Ou10giB4sr8s6KU9jP/pT6eWy8nejdt7R51S58SeJux1Dp5R9TdzkOKf2l hIyuUgSsn7LDKZHFrll+F4PIzv4ulf8Llu9ZBeRqUtB/zMw3kJmAc++WAhbONwpyW22b /3ZA== X-Gm-Message-State: AFqh2kpKqhyVo7P3Ng05m5ukYPqd2zeUVM9cv6I6Hgmn+Jnw7dD3x179 G1B0pUrGMRLwVvfe4KaKIWruchFRmsg= X-Google-Smtp-Source: AMrXdXsiPZwt1cXC+ILwsxHFzj7Rh4XMy+RYBmr58QP2EMrARzL/3VaYPvSoWFUb70KeETCBHjXsog== X-Received: by 2002:a5b:7ca:0:b0:72b:d262:176b with SMTP id t10-20020a5b07ca000000b0072bd262176bmr68758850ybq.31.1673269881831; Mon, 09 Jan 2023 05:11:21 -0800 (PST) Received: from ?IPV6:2605:2a00:9005:dead:a5ad:28f9:f53:90b4? ([2605:2a00:9005:dead:a5ad:28f9:f53:90b4]) by smtp.gmail.com with ESMTPSA id y11-20020a05620a25cb00b006bbf85cad0fsm5350358qko.20.2023.01.09.05.11.21 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 09 Jan 2023 05:11:21 -0800 (PST) Message-ID: <46fe0e83-a7fc-06d6-b376-84ec38ec437e@gmail.com> Date: Mon, 9 Jan 2023 08:11:20 -0500 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.5.0 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: Thomas Guyot 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 2023-01-09 07:41, 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? Hi Matthias, Users are generally created by the pre-install or post-install scripts of the package. The specific ways in which they are created may depend on the packaging tool being used and packager that built the distribution package. Regards, -- Thomas