psql: FATAL: the database system is in recovery mode - Mailing list pgsql-bugs

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