From: Tom Lane <tgl@sss.pgh.pa.us>
To: Zac Warham <cazwarham@hotmail.com>
cc: Adrian Klaver <adrian.klaver@aklaver.com>,
        "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Subject: Re: Changing postgres User
In-reply-to: <ME3P282MB3328FDD3AD68DFD183B1E9A4B7442@ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM>
References: <ME3P282MB33285BBA32907655287F4AD9B7442@ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM> <685640e7-4533-4483-acfc-d8dc60de5515@aklaver.com> <ME3P282MB3328FDD3AD68DFD183B1E9A4B7442@ME3P282MB3328.AUSP282.PROD.OUTLOOK.COM>
Comments: In-reply-to Zac Warham <cazwarham@hotmail.com>
	message dated "Mon, 14 Oct 2024 22:09:59 -0000"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <3836254.1728944861.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Mon, 14 Oct 2024 18:27:41 -0400
Message-ID: <3836255.1728944861@sss.pgh.pa.us>
Archived-At: <https://www.postgresql.org/message-id/3836255.1728944861%40sss.pgh.pa.us>
Precedence: bulk

Zac Warham <cazwarham@hotmail.com> writes:
> Thank you for the link to the documentation however it is the UID and GI=
D of 1001:1001 that is required, not the username which I believe this is =
intended for? Is there a similar option for UID and GID? Apologies if my o=
riginal question was not clear in this manner.

The underlying UID/GID will necessarily be that of the OS account that
is running initdb.  I don't see why you need to worry about it.

If you don't want the Postgres role name of the initial superuser role
to be the same as the OS account's name, you can select something else
using the switch Adrian mentioned --- but that's really mostly
cosmetic.  It has nothing to do with OS-level privileges.

			regards, tom lane