psql: FATAL: the database system is in recovery mode

From: Bhushan Verma <verma(dot)bhushan(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org, pgsql-bugs(at)postgresql(dot)org
Subject: psql: FATAL: the database system is in recovery mode
Date: 2009-06-24 05:59:12
Message-ID: 50a295ab0906232259s3ed694adjbd9021437ad3afc5@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-novice

Hi All,

I am doing some database related queries and this is working fine at fedora
core 4.
But the same database queries giving the FATAL error on fedora 9.

If I restarts the database on fedora core 9 then this is perfectlry working
without giving any error.

My postgres version is
On Fedora core-9[FC9] Machine:
$ rpm -qa|grep postgres
postgresql-server-8.3.1-1.fc9.i386
postgresql-devel-8.3.1-1.fc9.i386
postgresql-python-8.3.1-1.fc9.i386
postgresql-8.3.1-1.fc9.i386
postgresql-libs-8.3.1-1.fc9.i386

On Fedora core-4[FC49] Machine:
$ rpm -qa|grep postgres
postgresql-server-8.0.3-1
postgresql-libs-8.0.3-1
postgresql-odbc-08.00.0100-1
postgresql-jdbc-8.0.3-1
postgresql-docs-8.0.3-1
postgresql-tcl-8.0.3-1
postgresql-test-8.0.3-1
postgresql-devel-8.0.3-1
postgresql-8.0.3-1
gnucash-backend-postgres-1.8.11-3
freeradius-postgresql-1.0.2-2
postgresql-python-8.0.3-1
postgresql-contrib-8.0.3-1
postgresql-pl-8.0.3-1

Problem is:
----------------
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

connection to server was lost

psql: FATAL: the database system is in recovery mode

psql: FATAL: the database system is in recovery mode

psql: FATAL: the database system is in recovery mode

psql: FATAL: the database system is in recovery mode

psql: FATAL: the database system is in recovery mode

psql: FATAL: the database system is in recovery mode

psql: FATAL: the database system is in recovery mode

psql: FATAL: the database system is in recovery mode

psql: FATAL: the database system is in recovery mode

psql: FATAL: the database system is in recovery mode

psql: FATAL: the database system is in recovery mode

server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
connection to server was lost
psql: FATAL: the database system is in recovery mode

--------------

Is this database bug or there is any versioning incopatability.
Can anyone please help me in this regards.

--
With Regards,
Bhushan

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2009-06-24 06:14:42 Re: psql: FATAL: the database system is in recovery mode
Previous Message Роман Галеев 2009-06-24 05:36:37 Re: BUG #4874: vacuum doest work

Browse pgsql-novice by date

  From Date Subject
Next Message Heikki Linnakangas 2009-06-24 06:14:42 Re: psql: FATAL: the database system is in recovery mode
Previous Message Nagle, Gail A (US SSA) 2009-06-24 00:48:03 Configuring autovacuum for the first time...