Re: Changing postgres User

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Zac Warham <cazwarham(at)hotmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Changing postgres User
Date: 2024-10-14 22:27:41
Message-ID: 3836255.1728944861@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Zac Warham <cazwarham(at)hotmail(dot)com> writes:
> Thank you for the link to the documentation however it is the UID and GID 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 original 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2024-10-14 23:38:01 Re: Changing postgres User
Previous Message Zac Warham 2024-10-14 22:09:59 Re: Changing postgres User