Re: Connection to PostgreSQL Using Certificate: Wrong Permissions on Private Key File - Mailing list pgsql-general

From Tom Lane
Subject Re: Connection to PostgreSQL Using Certificate: Wrong Permissions on Private Key File
Date
Msg-id 20376.1206820220@sss.pgh.pa.us
Whole thread Raw
In response to Connection to PostgreSQL Using Certificate: Wrong Permissions on Private Key File  ("Atkins-Trimnell, Angus Black" <trimnell@uic.edu>)
Responses Re: Connection to PostgreSQL Using Certificate: Wrong Permissions on Private Key File  (Kevin Hunter <hunteke@earlham.edu>)
List pgsql-general
"Atkins-Trimnell, Angus Black" <trimnell@uic.edu> writes:
> I have tried various owner/group/permissions combinations for
> WEB_HOME/.postgresql/postgresql.key.  I have had it set as root:root with
> 700 permissions, postgresql:root with 700, and postgresql:postgresql with
> 700.  I've also tried these various combinations with 750 permissions.

> Regardless, when I try to connect, I get the following error message:

> Unable to connect to PostgreSQL server: private key file
> "/var/www/.postgresql/postgresql.key" has wrong permissions

The code appears to want 700 and ownership equal to that of the process
executing libpq, ie, the apache server.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: suggested wording improvement in psql
Next
From: "Daniel Verite"
Date:
Subject: Re: Using tables in other PostGreSQL database