Postgres won't start after setting ssl=on

Поиск
Список
Период
Сортировка
От Mike Christensen
Тема Postgres won't start after setting ssl=on
Дата
Msg-id AANLkTikGe4vhsnO5bJRQtToRqUhdub-RKUYTMQA=uiAV@mail.gmail.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: LOG: unexpected EOF on client connection
Следующее
От: Ben Carbery
Дата:
Сообщение: Re: Postgres won't start after setting ssl=on