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
Thanks & Regards
Raghu