Initialization script when PGData is not empty about postgres HOT 8 OPEN

@LaurentGoderre, yes. you see I need to initialize the db to have a postgres role even when the datadir already exists (a.k.a the db already initialized)

from postgres.

If you want a solution that does something with a started database (like our existing initdb scripts do), see #173, #821, #191, #929 for some other issues that have some good thoughts / suggestions (one of which this is probably a duplicate of).

from postgres.

Hi @tianon! Thanks for your response.
I managed to run an init script on my db but it fails with role "postgres" does not exist (it was probably deleted).
I don't know what roles the db has and I want to use the init script to verify the postgres role exists (and if not to create one).

from postgres.

You can run

docker exec -u postgres -it postgres psql    
psql (16.2 (Debian 16.2-1.pgdg120+2))
Type "help" for help.

postgres=# \du
                             List of roles
 Role name |                         Attributes                         
-----------+------------------------------------------------------------
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS

from postgres.

Hi @LaurentGoderre unfortunately your solution would not work in my case because there is no role postgres so I'm unable to execute any command with -u postgres, that's why I would like to init the db with a postgres role creation

from postgres.

@tomera-cyera I believe postgres in this case refers to the OS user which is postgres not the db role.

from postgres.

No, I refer to the postgres db role in case I initialize the container with data-dir that does not have the role postgres I want to make sure the postgres role will be created if not exist
@LaurentGoderre

from postgres.

OOh you mean at initialization?

from postgres.