Can't add entry for certificate authentication to pg_dist_authinfo about citus HOT 2 CLOSED

ben=# insert into pg_dist_authinfo values (0,'postgres','host=localhost sslmode=verify-full sslcert=/var/lib/postgresql/certs/client.crt sslkey=/var/lib/postgresql/keys/client.key sslrootcert=/var/lib/postgresql/certs/ca.crt');
ERROR: new row for relation "pg_dist_authinfo" violates check constraint "authinfo_valid"
DETAIL: Failing row contains (0, postgres, host=localhost sslmode=verify-full sslcert=/var/lib/postgresql/c...).

You cannot put the entire connection string as the auth info.
Only { "password", "sslcert", "sslkey" } parameters can be defined here.

Other connection parameters that are common to all nodes should be defined by using citus.node_conninfo

So the connection string is generated by combining info from pg_dist_authinfo, pg_dist_node tables and citus.node_conninfo value at run time.

from citus.

@emelsimsek Thanks for the clarification. I've removed sslrootcert and host it's working now.

from citus.