BUG #18373: failed: could not open certificate file "/root/.postgresql/postgresql.crt": Permission denied

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: syednaqi(dot)hussain(at)veritas(dot)com
Subject: BUG #18373: failed: could not open certificate file "/root/.postgresql/postgresql.crt": Permission denied
Date: 2024-02-29 14:44:31
Message-ID: 18373-01809faff08b12f1@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18373
Logged by: Syed Naqi Hussain
Email address: syednaqi(dot)hussain(at)veritas(dot)com
PostgreSQL version: 15.0
Operating system: Unix
Description:

For Connection string = DRIVER=PostgreSQL
ODBC;SERVER=xy-postgresql;port=14321;Database=mydb;UID=postgres;PWD=*************************;CS=utf8;BoolsAsChar=0;ConnSettings=SET
CLIENT_ENCODING TO
'UTF8';LC_COLLATE='en_US.UTF-8';LC_CTYPE='en_US.UTF-8';ENCODING=UTF8;sslmode=verify-full;pqopt={sslrootcert='/tmp/...../dbcertpem'}

PG15 defaults to using $HOME/.postgresql/postgresql.crt when no sslcert in
the connection string.

This forces clients to include a sslcert in the connection.

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2024-02-29 15:20:24 Re: BUG #18372: Timezone documentation and use of TZ and PGTZ environment variables missing since version 7.4
Previous Message GADACHA Rachid (Acoss) 2024-02-29 13:20:25 RE: [Bugg hash join and parallel worker]