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

Search Discussions

  • Raghu ram at Nov 8, 2009 at 6:48 am

    On Sun, Nov 1, 2009 at 4:31 PM, Victor Jason 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 at Nov 9, 2009 at 9:58 am

    On Sun, 8 Nov 2009, raghu ram wrote:
    On Sun, Nov 1, 2009 at 4:31 PM, Victor Jason 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@genenames.org
    European Bioinformatics Institute
    Hinxton, Cambridge
    URL: http://www.genenames.org
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedNov 1, '09 at 11:01a
activeNov 9, '09 at 9:58a
posts3
users3
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase