Can't restart Postgres

From: Shawn Thomas <thomassd(at)u(dot)washington(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Can't restart Postgres
Date: 2017-02-14 19:17:27
Message-ID: 7B3B5240-A057-4B53-8C7A-6436C55F8942@u.washington.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I inadvertently deleted the ssl-cert-snakeoil.pem out from under a running Postgres instance (9.4) which caused it to shut down. 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 complicates the debugging and troubleshooting. There doesn't seem to be a way to do anything with Postgres outsided the of Debian'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(at)9(dot)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(at)9(dot)4-main(dot)service: control process exited, code=exited status=1

Any help/advice would be greatly appreciated.

-Shawn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2017-02-14 19:23:49 Re: database folder name and tables filenames
Previous Message John McKown 2017-02-14 18:42:44 Re: postgresql how to duplicate rows in result.