Re: Weird pg_ctl behaviour via ssh

From: Bohdan Linda <bohdan(dot)linda(at)seznam(dot)cz>
To: Bohdan Linda <bohdan(dot)linda(at)seznam(dot)cz>, pgsql-general(at)postgresql(dot)org
Subject: Re: Weird pg_ctl behaviour via ssh
Date: 2008-07-31 10:43:21
Message-ID: 20080731104321.GA12339@bafster.baflabs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 31, 2008 at 11:24:35AM +0200, Bohdan Linda wrote:
> /opt/postgres-8.3.3/bin/psql -h remote -p 5555 postgres
> psql: FATAL: the database system is starting up
>

I am attaching additional info. The /dev/null is understable, but what I
am worried is that if I query status of a server via:

ssh -T remote "export LD_LIBRARY_PATH=/opt/postgres-8.3.3/lib;
nohup /opt/postgres-8.3.3/bin/pg_ctl -w -D /data/pg833-data status 2>&1

I get:

pg_ctl: server is running (PID: 14478)
/opt/postgres-8.3.3/bin/postgres -D /data/pg833-data

But still psql is returning:

psql: FATAL: the database system is starting up

Why we have such inconsistency? How to avoid it?

Thank you,
Bohdan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message marko 2008-07-31 10:53:32 Re: Shared object "libpq.so.3" not found
Previous Message marko 2008-07-31 10:11:24 Re: Shared object "libpq.so.3" not found