Database

Solução para o erro para permissão negada ao inicializar o PostgreSQL

RT.DB.FAQ-39995
2015-06-11 11:34:19 BRT LOG: database system was interrupted; last known up at 2015-06-11 09:37:18 BRT
2015-06-11 11:34:19 BRT LOG: incomplete startup packet
2015-06-11 11:34:19 BRT FATAL: the database system is starting up
2015-06-11 11:34:20 BRT FATAL: could not open file "/etc/ssl/private/ssl-cert-snakeoil.key": Permiss?o negada
2015-06-11 11:34:20 BRT LOG: startup process (PID 5445) exited with exit code 1
2015-06-11 11:34:20 BRT LOG: aborting startup due to startup process failure


cd /var/lib/postgresql/9.1/main
rm server.crt
rm server.key
cp -rf /etc/ssl/certs/ssl-cert-snakeoil.pem server.crt
cp -rf /etc/ssl/private/ssl-cert-snakeoil.key server.key
chmod -R 700 server.*
chown postgres:postgres server.*
/etc/init.d/postgresql start

Caso ainda não funcionar
chmod -R 770 /etc/ssl/private/ssl-cert-snakeoil.key /etc/ssl/certs/ssl-cert-snakeoil.pem