Обсуждение: 'pg_ctl status' not working

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 'pg–ctl status' returns 'postmaster or postgres is not
running'. Any idea why?

Postgres 7.3.3 on Max OS X 10.3

Thanks,
Michael

--
Where are we going? And what am I doing in this handbasket?

Michael Grant <soft@bdanube.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 'pg�ctl 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

On Nov 9, 2003, at 5:19 PM, Tom Lane wrote:

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

That was it. I thought PGDATA was set, but it turns out I had left off
the first "root" slash in the pathname.


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


Thanks for the tip. I need to recompile sooner or later anyway....

Michael

--
"Our armies do not come into your cities and lands as conquerors, but
as liberators."
- British General Stanley Maude, Baghdad, 1917