pangaea:/var/log# systemctl status postgresql ● postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/system/postgresql.service; enabled) Active: active (exited) since Tue 2017-02-14 10:48:18 PST; 50min ago Process: 28668 ExecStart=/bin/true (code=exited, status=0/SUCCESS) Main PID: 28668 (code=exited, status=0/SUCCESS) CGroup: /system.slice/postgresql.service
-Shawn > On Feb 14, 2017, at 11:31 AM, Joshua D. Drake <j...@commandprompt.com> wrote: > > 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@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. > > It is likely a permissions issue. What does the systemctl log say? > > JD > >> >> -Shawn >> > > > -- > Command Prompt, Inc. http://the.postgres.company/ > <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.
