Re: FATAL: the database system is starting up

On Sun, 8 Nov 2009, raghu ram wrote:
> On Sun, Nov 1, 2009 at 4:31 PM, Victor Jason <vctrjsn(at)gmail(dot)com> 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:44-1223 492626
Bioinformatician
HUGO Gene Nomenclature Committee Email: hgnc(at)genenames(dot)org
European Bioinformatics Institute
Hinxton, Cambridge
URL: http://www.genenames.org
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~