Re: Super user password explicit in patroni yml
| От | Ron Johnson |
|---|---|
| Тема | Re: Super user password explicit in patroni yml |
| Дата | |
| Msg-id | CANzqJaCSGSRXnA6voPqHm2sMbEp_cH=+DnD0h2QnBku+pBohUA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Super user password explicit in patroni yml (kamal deen <kamaldeendba@gmail.com>) |
| Ответы |
Re: Super user password explicit in patroni yml
|
| Список | pgsql-admin |
On Wed, Feb 26, 2025 at 2:07 PM kamal deen <kamaldeendba@gmail.com> wrote:
Hi All,
[snip]
And also pls share the best way to rotate the DB user password in postgres.
I wrote a shell script to generate(*) a password, run the ALTER ROLE command, push the VALID UNTIL out by 3 months, and either(**) "sed edit .pgpass" or send the user an email with the new password.
*Via picking two random words from /usr/share/dict/words, a random 2 digit number, concatenated with a period. "openssl rand -base64 48" works, too. Got the basics from a StackExchange post.
**Depending on the user
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
В списке pgsql-admin по дате отправления: