Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group