Re: Connection to PostgreSQL Using Certificate: Wrong Permissions on Private Key File

From: Kevin Hunter <hunteke(at)earlham(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Angus Black Atkins-Trimnell <trimnell(at)uic(dot)edu>, Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Connection to PostgreSQL Using Certificate: Wrong Permissions on Private Key File
Date: 2008-03-30 02:54:16
Message-ID: 20080329225416.29704416@mailer.earlham.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

At 3:50p -0400 on Sat, 29 Mar 2008, Tom Lane wrote:
>> 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.

I just checked the 8.3 documentation and didn't see any mention of
the private key file requirements. Modulo the fact that I don't know
the docs /that/ well, would a HINT be helpful here? Or a pointer to
the correct doc section?

Kevin

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Reece Hart 2008-03-30 03:46:00 Re: Survey: renaming/removing script binaries (createdb, createuser...)
Previous Message Daniel Verite 2008-03-29 22:53:06 Re: Using tables in other PostGreSQL database

Browse pgsql-hackers by date

  From Date Subject
Next Message Neil Conway 2008-03-30 04:08:53 Re: Integer datetime by default
Previous Message Alex Hunsaker 2008-03-30 01:40:19 Re: [badalex@gmail.com: Re: [BUGS] Problem identifying constraints which should not be inherited]