| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | Holger Jakobs <holger(at)jakobs(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Facing issue with cert authentication |
| Date: | 2022-12-23 01:56:15 |
| Message-ID: | CAMkU=1zJFfYm5k=Bka3cxcwbvY1wXj5e1KhXx=yo7+9d8R8XYA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, Dec 22, 2022 at 4:40 AM Holger Jakobs <holger(at)jakobs(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dhirendra Singh | 2022-12-23 03:31:45 | Re: Facing issue with cert authentication |
| Previous Message | David G. Johnston | 2022-12-22 23:23:36 | Re: Facing issue with cert authentication |