From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> |
Cc: | Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Modify Bootstrap user ID |
Date: | 2024-02-21 18:39:18 |
Message-ID: | 95373.1708540758@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> writes:
> We want to upgrade a postgres v13 database to v16. but the bootstrap user
> used to initialise the database for both are different
> Can we update the bootstrap user for v13 ? like assign oid as 10 in
> pg_authid?
Do not try to change role OIDs --- you will certainly miss some
places where the OID appears. You can rename it though.
You might have tried this:
regression=# alter user postgres rename to pgsql;
ERROR: session user cannot be renamed
but it's easy to get around that:
regression=# create user joe superuser;
CREATE ROLE
regression=# \c - joe
You are now connected to database "regression" as user "joe".
regression=# alter user postgres rename to pgsql;
ALTER ROLE
regression=# \c - pgsql
You are now connected to database "regression" as user "pgsql".
regression=# drop user joe;
DROP ROLE
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Rajesh Kumar | 2024-02-22 04:46:23 | Re: Wraparound |
Previous Message | Nikhil Shetty | 2024-02-21 18:17:30 | Modify Bootstrap user ID |