[bitnami/postgresql] Run pgsql in non root pod

[urbaman]

Name and Version

bitnami/postgresql 16.4.5

What architecture are you using?

amd64

What steps will reproduce the bug?

• Install the chart
• kubectl exec into the pod
• try any pgsql or postgresql: user 1001 does not exixst

Are you using any custom parameters or values?

no

What is the expected behavior?

Be able to run pg_upgrade or pgsql to import the backup of a previous version of the server

What do you see instead?

I have no name!@postgresql-16-0:/$ psql
psql: error: local user with ID 1001 does not exist
I have no name!@postgresql-16-0:/$ pg_upgrade

could not look up effective user ID 1001: user does not exist
Failure, exiting

Additional information

No response

[yukha-dw]

How about adding parameter -U postgres or any PG user?
https://www.postgresql.org/docs/current/app-psql.html#APP-PSQL-OPTION-USERNAME

[urbaman]

So, it's me being stupid, that obviously works great, and perfectly completed the migration.

Thank you!