"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