Re: psql: FATAL: the database system is in recovery mode

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 <craig(at)postnewspapers(dot)com(dot)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