Append ssl* arguments to the connection string like so. psql 'postgres://...?sslmode=verify-full&sslrootcert=system'