[GENERAL] Can't restart Postgres
От | Shawn Thomas |
---|---|
Тема | [GENERAL] Can't restart Postgres |
Дата | |
Msg-id | 7B3B5240-A057-4B53-8C7A-6436C55F8942@u.washington.edu обсуждение исходный текст |
Ответы |
Re: [GENERAL] Can't restart Postgres
Re: [GENERAL] Can't restart Postgres |
Список | pgsql-general |
I inadvertently deleted the ssl-cert-snakeoil.pem out from under a running Postgres instance (9.4) which caused it to shutdown. The last line of main.log: FATAL: could not load server certificate file "/etc/ssl/certs/ssl-cert-snakeoil.pem": No such file or directory I've since restored the cert but cannot get Postgres to start back up. It's the Debian 8 packaged version which complicatesthe debugging and troubleshooting. There doesn't seem to be a way to do anything with Postgres outsided the ofDebian's systemd wrappers. All I've got to work with is from /var/syslog: pangaea systemd[1]: Starting PostgreSQL Cluster 9.4-main... pangaea postgresql@9.4-main[28684]: Error: could not exec start -D /var/lib/postgresql/9.4/main -l /var/log/postgresql/postgresql-9.4-main.log-s -o -c config_file="/etc/postgresql/9.4/main/postgresql.conf" : pangaea systemd[1]: postgresql@9.4-main.service: control process exited, code=exited status=1 Any help/advice would be greatly appreciated. -Shawn
В списке pgsql-general по дате отправления: