psql: FATAL: the database system is in recovery mode

Поиск
Список
Период
Сортировка
От Bhushan Verma
Тема psql: FATAL: the database system is in recovery mode
Дата
Msg-id 50a295ab0906232259s3ed694adjbd9021437ad3afc5@mail.gmail.com
обсуждение исходный текст
Ответы Re: psql: FATAL: the database system is in recovery mode  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Re: psql: FATAL: the database system is in recovery mode  (Craig Ringer <craig@postnewspapers.com.au>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Jim Michaels"
Дата:
Сообщение: BUG #4876: author of MD5 says it's seriously broken - hash collision resistance problems
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: psql: FATAL: the database system is in recovery mode