Thanks for your response. As follows is log details ERROR: table "transactionrecord_5917" does not exist STATEMENT: drop table TransactionRecord_5917; ERROR: table "pagerecord_5917" does not exist STATEMENT: drop table PageRecord_5917; ERROR: table "urlrecord_5917" does not exist STATEMENT: drop table URLRecord_5917; LOG: server process (PID 29225) was terminated by signal 11: Segmentation fault LOG: terminating any other active server processes LOG: all server processes terminated; reinitializing FATAL: the database system is in recovery mode LOG: database system was interrupted; last known up at 2009-06-23 12:49:49 IST FATAL: the database system is in recovery mode FATAL: the database system is in recovery mode LOG: database system was not properly shut down; automatic recovery in progress FATAL: the database system is in recovery mode LOG: redo starts at 0/185239F8 FATAL: the database system is in recovery mode FATAL: the database system is in recovery mode FATAL: the database system is in recovery mode LOG: record with zero length at 0/185A67FC LOG: redo done at 0/185A67D0 LOG: last completed transaction was at log time 2009-06-23 14:49:10.37602+05:30 FATAL: the database system is in recovery mode LOG: autovacuum launcher started LOG: database system is ready to accept connections
With Regards, Bhushan On 6/24/09, Craig Ringer <cr...@postnewspapers.com.au> wrote: > > Bhushan Verma wrote: > > > server closed the connection unexpectedly > > This probably means the server terminated abnormally > > before or while processing the request. > > connection to server was lost > > > Look in the PostgreSQL server logs for more information. It's probably > in /var/log/postgresql or something like that - it depends on exactly > how the distro packaged PostgreSQL. > > -- > > Craig Ringer > -- With Regards, Bhushan