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