Super user password explicit in patroni yml

Поиск
Список
Период
Сортировка
От kamal deen
Тема Super user password explicit in patroni yml
Дата
Msg-id CAAGAcEe8qmL05tCLX_y8cPK8UHoxVOnC6BW1Or33-pH9xcxgQw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Super user password explicit in patroni yml
Список 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.

В списке pgsql-admin по дате отправления: