Re: Postgres does not start, gives no error - Mailing list pgsql-general

From Akhtar Yasmin-B05532
Subject Re: Postgres does not start, gives no error
Date
Msg-id C0F75310EB29C743AAB5403624E7B103022D35B6@az33exm25.fsl.freescale.net
Whole thread Raw
In response to Re: Postgres does not start, gives no error  (Joshua Drake <jd@commandprompt.com>)
Responses Re: Postgres does not start, gives no error
List 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@commandprompt.com]
Sent: Wednesday, September 03, 2008 3:45 PM
To: Akhtar Yasmin-B05532
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres does not start, gives no error

On Wed, 3 Sep 2008 15:34:26 -0700
"Akhtar Yasmin-B05532" <B05532@freescale.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@commandprompt.com]
> Sent: Wednesday, September 03, 2008 3:25 PM
> To: Akhtar Yasmin-B05532
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Postgres does not start, gives no error
>
> On Wed, 3 Sep 2008 15:19:25 -0700
> "Akhtar Yasmin-B05532" <B05532@freescale.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



pgsql-general by date:

Previous
From: Joshua Drake
Date:
Subject: Re: Postgres does not start, gives no error
Next
From: pw
Date:
Subject: Compiling C Trigger function