Postgres SSL & DB password rotation - Mailing list pgsql-admin

From kamal deen
Subject Postgres SSL & DB password rotation
Date
Msg-id CAAGAcEfZ7Hb2S+GEa9=CC9cBR0HOAGL=MdZO4kB=mOVoLDEnZQ@mail.gmail.com
Whole thread Raw
List pgsql-admin
Hi All ,

We are started working on enable SSL on our postgres databases, currently we are using three certs ( root.crt, server.crt, server.key).

Is there a way we can enable only root.crt cert or combine all three into one single certs to connect DB.


Pls suggest if any best practice for dynamic password vault and rotation for postgres DB user.


Regards,
SK

pgsql-admin by date:

Previous
From: Dutch Glory
Date:
Subject: connection to server at "localhost" (::1), port 5432 failed: FATAL: Ident authentication failed for user "postgres"
Next
From: Ron Johnson
Date:
Subject: Re: connection to server at "localhost" (::1), port 5432 failed: FATAL: Ident authentication failed for user "postgres"