Re: Postgres does not start, gives no error

From: "Akhtar Yasmin-B05532" <B05532(at)freescale(dot)com>
To: "Joshua Drake" <jd(at)commandprompt(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Postgres does not start, gives no error
Date: 2008-09-03 22:47:04
Message-ID: C0F75310EB29C743AAB5403624E7B103022D35B6@az33exm25.fsl.freescale.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

The log says,
postmaster successfully started

But I don't think its started as, while connecting to db, I get the
following error in the logs as,

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"?

-----Original Message-----
From: Joshua Drake [mailto:jd(at)commandprompt(dot)com]
Sent: Wednesday, September 03, 2008 3:45 PM
To: Akhtar Yasmin-B05532
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Postgres does not start, gives no error

On Wed, 3 Sep 2008 15:34:26 -0700
"Akhtar Yasmin-B05532" <B05532(at)freescale(dot)com> wrote:

> Even the command pg_ctl -D /home/data/www/pg7/data start Does not
> start the server, I mean the message I get on running the command, is:
> postmaster successfully started

O.k. what does the log say?

Joshua D. Drake

>
> But the status still shows,
> pg_ctl: postmaster or postgres is not running
>
> Also when I try to access psql, it gives me the following error..
>
> 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"?
>
>
>
> -----Original Message-----
> From: Joshua Drake [mailto:jd(at)commandprompt(dot)com]
> Sent: Wednesday, September 03, 2008 3:25 PM
> To: Akhtar Yasmin-B05532
> Cc: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Postgres does not start, gives no error
>
> On Wed, 3 Sep 2008 15:19:25 -0700
> "Akhtar Yasmin-B05532" <B05532(at)freescale(dot)com> wrote:
>
> >
> > It says,
> > pg_ctl: 5432: not found
> > postmaster successfully started
>
> pg_ctl doesn't take a -p argument for the port. -p is reserved for the

> path to the postmaster. Try:
>
> pg_ctl -D /home/data/www/pg7/data start
>
> Joshua D. Drake
>
>
> --
> The PostgreSQL Company since 1997: http://www.commandprompt.com/
> PostgreSQL Community Conference: http://www.postgresqlconference.org/
> United States PostgreSQL Association: http://www.postgresql.us/ Donate

> to the PostgreSQL Project: http://www.postgresql.org/about/donate
>
>
>

--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/ Donate
to the PostgreSQL Project: http://www.postgresql.org/about/donate

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pw 2008-09-03 23:02:17 Compiling C Trigger function
Previous Message Joshua Drake 2008-09-03 22:44:37 Re: Postgres does not start, gives no error