| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Atkins-Trimnell, Angus Black" <trimnell(at)uic(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Connection to PostgreSQL Using Certificate: Wrong Permissions on Private Key File |
| Date: | 2008-03-29 19:50:20 |
| Message-ID: | 20376.1206820220@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
"Atkins-Trimnell, Angus Black" <trimnell(at)uic(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Verite | 2008-03-29 22:53:06 | Re: Using tables in other PostGreSQL database |
| Previous Message | Tom Lane | 2008-03-29 19:41:47 | Re: suggested wording improvement in psql |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-03-29 21:33:29 | buildfarm member jaguar doesn't like truncate-triggers code |
| Previous Message | Atkins-Trimnell, Angus Black | 2008-03-29 18:05:29 | Connection to PostgreSQL Using Certificate: Wrong Permissions on Private Key File |