Super user password explicit in patroni yml

From: kamal deen <kamaldeendba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Super user password explicit in patroni yml
Date: 2025-02-26 19:06:49
Message-ID: CAAGAcEe8qmL05tCLX_y8cPK8UHoxVOnC6BW1Or33-pH9xcxgQw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

As part of the security standardization we are working on postgres super
user DB password rotation POC.

In that POC we have successfully rotated the password with the help of
password management tool.

We have noticed in patroni yml file for authentication we are explicitly
using super user name and credentials same for replicator user as well.

Is there any option we can pass this password instead of direct mentioning
or using .pgpass file.

Our intention here is we should not expose superuser password anywhere at
server level.

If we change the super user password at DB level should we update the same
in patroni yml every time ? If we not update that password in patroni yml
file is that impact anything of replication , API calls , primary and
replica connectivity?

And also pls share the best way to rotate the DB user password in postgres.

Your valuable suggestion is highly appreciated.

Regards,
SK.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron Johnson 2025-02-26 19:27:52 Re: Super user password explicit in patroni yml
Previous Message Frank Zhou 2025-02-26 15:03:20 Re: Monitoring postgresql 14 in a paasrole