Skip site navigation (1) Skip section navigation (2)

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

From: Bhushan Verma <verma(dot)bhushan(at)gmail(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: Re: psql: FATAL: the database system is in recovery mode
Date: 2009-06-24 08:24:49
Message-ID: 50a295ab0906240124l5bef2b4cl4a0a6897346a36fd@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-novice
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

In response to

pgsql-novice by date

Next:From: Bhushan VermaDate: 2009-06-24 08:32:54
Subject: Re: psql: FATAL: the database system is in recovery mode
Previous:From: Craig RingerDate: 2009-06-24 06:22:04
Subject: Re: psql: FATAL: the database system is in recovery mode

pgsql-bugs by date

Next:From: Bhushan VermaDate: 2009-06-24 08:32:54
Subject: Re: psql: FATAL: the database system is in recovery mode
Previous:From: Peter EisentrautDate: 2009-06-24 07:59:06
Subject: Re: BUG #4876: author of MD5 says it's seriously broken - hash collision resistance problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group