Re: could not connect error - Mailing list pgsql-general

From Scott Marlowe
Subject Re: could not connect error
Date
Msg-id dcc563d10806021429h2c9c956drefc9409569ff2e18@mail.gmail.com
Whole thread Raw
In response to could not connect error  ("JD Wong" <asi4man@gmail.com>)
List pgsql-general
On Mon, Jun 2, 2008 at 2:45 PM, JD Wong <asi4man@gmail.com> wrote:
> Hey,
>     I'm a first time postgres user.  I was able to access yesterday a
> database I had loaded that same day until the system was shut down without
> warning.  Now I get the error:
>
> createdb: could not connect to database postgres: 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 reinstalled the database with no difference, does anyone know how I may
> resolve the issue?  Thanks in advance.

We might need more info.  What you need to find out is if the database
is capable of coming up, and if not, why not.  what OS, pg version,
etc... are you running?

How do you start your db?  /etc/init.d/....  or pg_ctl or???

You can look in the pg logs to see what it says when it tries to come up.

You can use pg_ctl to see if you can get the db up.

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Forcing Postgres to Execute a Specific Plan
Next
From: PJ
Date:
Subject: what is a "valid link resource"?