Обсуждение: BUG #18373: failed: could not open certificate file "/root/.postgresql/postgresql.crt": Permission denied

Поиск
Список
Период
Сортировка
The following bug has been logged on the website:

Bug reference:      18373
Logged by:          Syed Naqi Hussain
Email address:      syednaqi.hussain@veritas.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.