Re: Restarting postgres server

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: George Heller <george(dot)heller(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restarting postgres server
Date: 2007-05-14 22:41:36
Message-ID: 1179182496.24902.104.camel@dogma.v10.wvs
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Barlow 2007-05-14 23:01:01 stats collector spins my disk up every 500ms (8.2.3)
Previous Message George Heller 2007-05-14 22:21:58 Restarting postgres server