Postgres Pro
Downloads
Home   >   mailing lists

Re: Facing issue with cert authentication - Mailing list pgsql-admin

From Jeff Janes
Subject Re: Facing issue with cert authentication
Date
Msg-id CAMkU=1zJFfYm5k=Bka3cxcwbvY1wXj5e1KhXx=yo7+9d8R8XYA@mail.gmail.com
Whole thread Raw
In response to Re: Facing issue with cert authentication  (Holger Jakobs <holger@jakobs.com>)
List pgsql-admin
Tree view
On Thu, Dec 22, 2022 at 4:40 AM Holger Jakobs <holger@jakobs.com> wrote:

Can you try:

psql "host=postgres.app.net user=\"S114546\" dbname=appdb sslmode=verify-full sslcert=cert.pem sslkey=cert-key.pem sslrootcert=tls-ca-bundle.pem"

This should keep the user name in upper case.

On the command line, case folding is not done, so adding the quotes doesn't do what you want.  It is once you are inside psql (which is presumably where the user is created via CREATE USER) where the case folding kicks in.

Cheers,

Jeff

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Facing issue with cert authentication
Next
From: Dhirendra Singh
Date:
Subject: Re: Facing issue with cert authentication