If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > PostgreSQL > psql: FATAL: the database system is starting

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-06-11, 08:49
shilpa24 shilpa24 is offline
Registered User
 
Join Date: Apr 2011
Posts: 14
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
Reply With Quote
  #2 (permalink)  
Old 05-06-11, 09:46
shammat shammat is offline
Registered User
 
Join Date: Nov 2003
Posts: 2,408
What does the logfile say?
Reply With Quote
  #3 (permalink)  
Old 05-09-11, 00:48
shilpa24 shilpa24 is offline
Registered User
 
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
Reply With Quote
  #4 (permalink)  
Old 05-09-11, 02:22
shammat shammat is offline
Registered User
 
Join Date: Nov 2003
Posts: 2,408
You should post that to the Postgres mailing list.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On