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
Re: Postgres won't start after setting ssl=on Re: Postgres won't start after setting ssl=on |
Список | 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 по дате отправления: