FATAL: the database system is starting up

[Victor Jason]

Hi,

Many times after I start the db (/etc/init.d/postgresql), the second I access it I get

"FATAL: the database system is starting up"

Is there a natural way (any cli command or other) to check with the DB if it's still starting up or it is ready?

Thanks
VJ

[raghu ram-4]

Some parts of this message have been removed. Learn more about Nabble's security policy.

On Sun, Nov 1, 2009 at 4:31 PM, Victor Jason <vctrjsn@...> wrote:

Hi,

Many times after I start the db (/etc/init.d/postgresql), the second I access it I get

"FATAL: the database system is starting up"

Is there a natural way (any cli command or other) to check with the DB if it's still starting up or it is ready?

you can check  the status of the database using the pg_ctl utility.
 
cd /usr/local/pgsql/bin

pg_ctl -D <data directory path> status


Thanks & Regards
Raghu

[Michael Lush-2]

On Sun, 8 Nov 2009, raghu ram wrote:

> On Sun, Nov 1, 2009 at 4:31 PM, Victor Jason <vctrjsn@...> wrote:
>> Hi,
>> Many times after I start the db (/etc/init.d/postgresql), the second I
>> access it I get
>>
>> *"FATAL: the database system is starting up"*
>> Is there a natural way (any cli command or other) to check with the DB if
>> it's still starting up or it is ready?
>>
> you can check  the status of the database using the pg_ctl utility.
>
> cd /usr/local/pgsql/bin
>
> pg_ctl -D <data directory path> status

I have the same problem as Victor

In my hands pg_ctl status  just gives me

"pg_ctl: server is running (PID: 26644)"

The only way I know is to attempt to login to the database which
generates that scary error :-}

I'd also like to know if there was a better/nicer/proper way  to determine
if the database was starting up

--
Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Michael John Lush PhD Tel:[phone]
Bioinformatician
HUGO Gene Nomenclature Committee Email: hgnc@...
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

--
Sent via pgsql-novice mailing list (pgsql-novice@...)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice