Postgres Pro
Downloads
Home   >   mailing lists

Re: Server Crash: Issues Re-starting Postgres [RESOLVED] - Mailing list pgsql-general

From Rich Shepard
Subject Re: Server Crash: Issues Re-starting Postgres [RESOLVED]
Date
Msg-id alpine.LNX.2.00.1401071303250.5681@salmo.appl-ecosys.com
Whole thread Raw
In response to Server Crash: Issues Re-starting Postgres  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
Tree view 
On Tue, 7 Jan 2014, Rich Shepard wrote:

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

   Found the problem and fixed it.

   I had touched /tmp/.s.PGSQL.5432 as root and it was a regular file, not a
socket. Stopping postgres, deleting that file, and restarting the server
fixed the problem. Now /tmp/.s.PGSQL.5432 is a socket and I can access my
databases.

Rich

pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Consistent file-level backup of pg data directory
Next
From: Sergey Konoplev
Date:
Subject: Re: Sudden slow down and spike in system CPU causes max_connections to get exhausted