Server Crash: Issues Re-starting Postgres

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Server Crash: Issues Re-starting Postgres
Date: 2014-01-07 20:02:38
Message-ID: alpine.LNX.2.00.1401071200101.5681@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 &
[1] 9746
postgres(at)salmo:~$ LOG: could not bind Unix socket: Address already in use
WARNING: could not create Unix-domain socket
LOG: database system was shut down at 2014-01-07 11:52:08 PST
LOG: database system is ready to accept connections
LOG: autovacuum launcher started

And, when I (as a user) 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"?

What is the process I follow to get postgres running again?

TIA,

Rich

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ChoonSoo Park 2014-01-07 20:45:46 Re: Is there a way to return "true"/"false" string for boolean type?
Previous Message Susan Cassidy 2014-01-07 20:01:38 Re: When starting postgres, it hangs like it is still connected to stdout