Postgres won't start after setting ssl=on - Mailing list pgsql-general

From Mike Christensen
Subject Postgres won't start after setting ssl=on
Date
Msg-id AANLkTikGe4vhsnO5bJRQtToRqUhdub-RKUYTMQA=uiAV@mail.gmail.com
Whole thread Raw
Responses Re: Postgres won't start after setting ssl=on  (Ben Carbery <ben.carbery@gmail.com>)
Re: Postgres won't start after setting ssl=on  (Darren Duncan <darren@darrenduncan.net>)
Re: Postgres won't start after setting ssl=on  (Rob Sargent <robjsargent@gmail.com>)
List 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

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: LOG: unexpected EOF on client connection
Next
From: Ben Carbery
Date:
Subject: Re: Postgres won't start after setting ssl=on