Postgres won't start after setting ssl=on

From: Mike Christensen <mike(at)kitchenpc(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Postgres won't start after setting ssl=on
Date: 2010-10-10 03:52:50
Message-ID: AANLkTikGe4vhsnO5bJRQtToRqUhdub-RKUYTMQA=uiAV@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, I'm trying to require SSL for Postgres connections from certain
IPs.. This is on Postgres 9.0.

First, I've followed the directions at:

http://www.postgresql.org/docs/9.0/static/ssl-tcp.html

I've created the files server.crt and server.key. I've also removed
the passphrase from the key so Postgres can start automatically.
Finally, I ran:

chmod 0600 server.key

The permissions on server.key are now:

-rw------- 1 root root 887 Oct 10 03:42 server.key

However, when I set ssl = on in postgresql.conf and start the server,
I get the logged error:

2010-10-10 03:47:07 UTC FATAL: could not load private key file
"server.key": Permission denied

I'm logged on as root. Any ideas? Thanks!

Mike

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben Carbery 2010-10-10 04:00:05 Re: Postgres won't start after setting ssl=on
Previous Message Scott Marlowe 2010-10-10 01:51:36 Re: LOG: unexpected EOF on client connection