| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Michael Grant <soft(at)bdanube(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: 'pg_ctl status' not working |
| Date: | 2003-11-09 23:19:55 |
| Message-ID: | 10103.1068419995@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Michael Grant <soft(at)bdanube(dot)com> writes:
> Logged in as the 'postgres' user, 'ps x' shows that postmaster is
> running. 'psql' works properly and I am able to connect to
> databases--but 'pgctl status' returns 'postmaster or postgres is not
> running'. Any idea why?
Most likely, pg_ctl has the wrong idea about which data directory to
look in. Do you have PGDATA set in your user environment? Does it
match where the postmaster is actually running?
> Postgres 7.3.3 on Max OS X 10.3
I'd suggest updating to 7.3.4 --- 7.3.3 has a nasty bug that once in a
while will keep the postmaster from restarting after shutdown.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Grant | 2003-11-10 00:23:19 | Re: 'pg_ctl status' not working |
| Previous Message | Josh Berkus | 2003-11-09 22:08:54 | Re: The data directory was initialized by PostgreSQL version 7.4, which is not compatible with this version 7.3.3. |