Postgres Pro
Downloads
Home   >   mailing lists

Re: FATAL: the database system is starting up - Mailing list pgsql-novice

From raghu ram
Subject Re: FATAL: the database system is starting up
Date
Msg-id d331f2ee0911072248y4a0aedf6gc10717ea896e7a70@mail.gmail.com
Whole thread Raw
In response to FATAL: the database system is starting up  (Victor Jason <vctrjsn@gmail.com>)
Responses Re: FATAL: the database system is starting up  (Michael Lush <mjlush@ebi.ac.uk>)
List pgsql-novice
Tree view


On Sun, Nov 1, 2009 at 4:31 PM, Victor Jason <vctrjsn@gmail.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


Thanks & Regards
Raghu

pgsql-novice by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Table design for basic user management
Next
From: Michael Wood
Date:
Subject: Re: Table design for basic user management