From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | Shawn Thomas <thomassd(at)u(dot)washington(dot)edu>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Can't restart Postgres |
Date: | 2017-02-14 19:31:21 |
Message-ID: | e786e027-01c3-eef3-caa6-0b550ba33aa5@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/14/2017 11:17 AM, Shawn Thomas wrote:
> 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.
It is likely a permissions issue. What does the systemctl log say?
JD
>
> -Shawn
>
--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.
From | Date | Subject | |
---|---|---|---|
Next Message | Shawn Thomas | 2017-02-14 19:43:52 | Re: Can't restart Postgres |
Previous Message | Tom Lane | 2017-02-14 19:23:49 | Re: database folder name and tables filenames |