Re: Restarting postgres server - Mailing list pgsql-general

From Jeff Davis
Subject Re: Restarting postgres server
Date
Msg-id 1179182496.24902.104.camel@dogma.v10.wvs
Whole thread Raw
In response to Restarting postgres server  (George Heller <george.heller@yahoo.com>)
List pgsql-general
On Mon, 2007-05-14 at 15:21 -0700, George Heller wrote:
> psql: could not connect to server: No such file or
> directory
>         Is the server running locally and accepting
>         connections on Unix domain socket
> "/tmp/.s.PGSQL.5432"?
>
> I have a lot of data in there, so I dont want to get
> it erased. Any ideas of how I can get this working, if
> I need to restart the postmaster, what would be the
> command? I am just a beginner with this thing, so
> please bear with me.

Try to start the server again, with:

pg_ctl -D /usr/local/pgsql/data start

and see the log output. The logs should tell you what the problem is.

Regards,
    Jeff Davis


pgsql-general by date:

Previous
From: George Heller
Date:
Subject: Restarting postgres server
Next
From: "Reuven M. Lerner"
Date:
Subject: Recovering a messed-up database