cockroach db about crystal-pg HOT 2 OPEN

The options params at least I don’t think is a general postgres protocol thing. libpq does a few to manage how it operates but it's all over the place what libpq does with them. Some change what types of SCRAM is accepted, some say where to look for certs. So I'm not sure what a options=--cluster%3Dkcrystal-1234 would actually do?

from crystal-pg.

@wontruefree You should be able to connect with below connection string, you need to add the cluster name as db prefix and accept cleartext auth method.

But the problem is that it seems like the option sslmode=verify-full has no effect, it still connects without providing the sslrootcert.

postgresql://user:[email protected]:26257/crystal-1234.defaultdb?auth_methods=cleartext,md5,scram-sha-256&sslmode=verify-full&sslrootcert=$HOME/.postgresql/root.crt

@will Does crystal-pg support sslmode=verify-full?

from crystal-pg.