From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Server Crash: Issues Re-starting Postgres |
Date: | 2014-01-07 19:00:01 |
Message-ID: | alpine.LNX.2.00.1401071054020.5681@salmo.appl-ecosys.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
While I was out of the office yesterday the server shut down unexpectedly.
Now I'm having difficulties getting postgres restarted because it's been so
long since I've done this.
Based on error messages when trying to start postgres I killed the .pid
file and /tmp/.s.PGSQL.5432. Obviously the wrong things to do.
As user postgres I try to start the server and see this:
postgres(at)salmo:~$ postgres -D /usr/local/pgsql/data >logfile 2>&1 &
[1] 8453
But, when I try to access a database:
psql: could not connect to server: Permission denied
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
I touched that file in /tmp but that's apparently not what I should have
done.
What is the process I follow to get postgres running again?
TIA,
Rich
From | Date | Subject | |
---|---|---|---|
Next Message | john melesky | 2014-01-07 19:29:39 | Re: Server Crash: Issues Re-starting Postgres |
Previous Message | gabrielle | 2013-11-27 05:14:37 | Fwd: [pdx-groups] Winter Coders Social 7 official announcement |