Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert

2021-09-18 Thread Cameron Murdoch
On Sat, 18 Sep 2021 at 12:57, Thomas Habets wrote: > > But these are two changes: > 1. Actually verify against a CA > 2. Actually check the CN/altnames > > Anything short of "verify-full" is in my view "not checking". Even with a > private CA this allows for a lot of lateral movement in an org, a

Re: [PATCH] Add `verify-system` sslmode to use system CA pool for server cert

2021-09-17 Thread Cameron Murdoch
Hi, I manage a bunch of Postgres servers at Oslo University and we use real ssl certs on all our servers. I was actually really surprised to discover that the libpq default is sslmode=require and that the root cert defaults to a file under the user’s home directory. I have been planning to use ou