Re: Facing issue with cert authentication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Dec 22, 2022 at 4:40 AM Holger Jakobs <holger@xxxxxxxxxx> 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

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux