Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2011
    Posts
    14

    Unanswered: psql: FATAL: the database system is starting

    Success. You can now start the database server using:
    "C:\pgsql\\bin\postgres" -D "C:/pgsql/data"
    or
    "C:\pgsql\\bin\pg_ctl" -D "C:/pgsql/data" -l logfile start

    C:\pgsql>"C:\pgsql\\bin\pg_ctl" -D "C:\pgsql\/data" -l logfile start
    server starting
    C:\pgsql>cd C:\pgsql\\bin

    C:\pgsql\bin>psql.exe -d postgres -p 5432 -U Admin
    psql: FATAL: the database system is starting up

    to wait till 15 min database server is not starting
    how could i solve this database system starting error

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    What does the logfile say?

  3. #3
    Join Date
    Apr 2011
    Posts
    14

    the database system is starting

    hi shammat,
    the log file will say like this

    LOG: database system was shut down at 2011-05-07 10:50:51 IST
    LOG: database system is ready to accept connections
    LOG: autovacuum launcher started
    LOG: server process (PID 3404) was terminated by exception 0xC000013A
    HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
    LOG: terminating any other active server processes
    LOG: statistics collector process (PID 1724) was terminated by exception 0xC000013A
    HINT: See C include file "ntstatus.h" for a description of the hexadecimal value.
    LOG: all server processes terminated; reinitializing
    LOG: database system was interrupted; last known up at 2011-05-07 10:50:51 IST
    LOG: database system was not properly shut down; automatic recovery in progress
    LOG: record with zero length at 0/4FF8D0
    LOG: redo is not required

  4. #4
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    You should post that to the Postgres mailing list.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •