Re: Super user password explicit in patroni yml
| От | kamal deen |
|---|---|
| Тема | Re: Super user password explicit in patroni yml |
| Дата | |
| Msg-id | CAAGAcEdPLiRqHwjT04iKyUy_1+qsF+0xEZi8rWuY9Qc4_vf_eA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Super user password explicit in patroni yml (Ron Johnson <ronljohnsonjr@gmail.com>) |
| Ответы |
Re: Super user password explicit in patroni yml
Re: Super user password explicit in patroni yml |
| Список | pgsql-admin |
Thank you John,
Without .pgpass file patroni can connect to postgres ?
How patroni service works in this sinario?
Any insight on that postgres patroni configuration?
***//Authentication Config Sample from Patrnoi yml file // ***
=================
pgpass: /tmp/pgpass
authentication:
replication:
username: replicator
password: **********
superuser:
username: postgres
password: **********
===================
Regards,
SK
On Thu, Feb 27, 2025, 12:58 AM Ron Johnson <ronljohnsonjr@gmail.com> wrote:
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 по дате отправления: