Shawn Thomas <thomassd@xxxxxxxxxxxxxxxx> writes: > 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 There's a bit more to it than that, because simply deleting that file would not result in a live server shutting down; before v10, the server only examines its certificate file at startup. > I've since restored the cert but cannot get Postgres to start back up. FWIW, I don't see how removing that file would result in a silent exit without any error messages. I suspect you did more damage to the PG installation than you've realized. As JD mentioned, permissions problems on the executable are a possibility. I'm also wondering if you broke the logging configuration, such that PG tries to write an error log message but can't, or it's writing it somewhere other than where you expect. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
