Thread: FATAL: The database system is in recovery mode
Hi,
I have got a problem with PostgreSQL 7.3.2 with cygwin under Windows 98. At
our clients sometimes during normal work the database goes into recovery
mode. I do not know what couses it, but it seems that this happens when one
of the client applications freeze (or the client application freeze when
this error occurs?). We got the same application and database under NT and
Windows2000 and those work without problem. As I know the database could go
into recovery mode only at startup time, am I right?
Does anybody know what can be the problem and how can I solve?
Thanks,
Attila
On Fri, 8 Aug 2003, Kenéz Attila wrote: > Hi, > > I have got a problem with PostgreSQL 7.3.2 with cygwin under Windows 98. At > our clients sometimes during normal work the database goes into recovery > mode. I do not know what couses it, but it seems that this happens when one > of the client applications freeze (or the client application freeze when > this error occurs?). We got the same application and database under NT and > Windows2000 and those work without problem. As I know the database could go > into recovery mode only at startup time, am I right? > > Does anybody know what can be the problem and how can I solve? I'd highly recommend against using postgresql with cygwin in production, and further, very highly recommend against using it under win9x, due to the stability issues on that platform. Can you just put it on a Win2K or better a linux box and let the clients all connect to that machine? More than likely, when the client app crashes, it's causing a kill -9 to be send the the backend, which is causing a the database to restart or something along those lines.
> I'd highly recommend against using postgresql with cygwin in production, >and further, very highly recommend against using it under win9x, due to >the stability issues on that platform. Can you just put it on a Win2K or >better a linux box and let the clients all connect to that machine? > I would second this. We actually explicitly limit connections to 50 with Mammoth PostgreSQL for Win32. Also win9x just doesn't have the preemptiveness needed in the kernel to handle something like PostgreSQL. PostgreSQL on Win32 for WinNT/2000/XP is fairly stable though, as long as you leave it at 50 connections or less. > >More than likely, when the client app crashes, it's causing a kill -9 to >be send the the backend, which is causing a the database to restart or >something along those lines. > > >---------------------------(end of broadcast)--------------------------- >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >
Hi Joshua ----- Original Message ----- From: "Joshua D. Drake" <jd@commandprompt.com> To: "scott.marlowe" <scott.marlowe@ihs.com> Cc: "Kenéz Attila" <akenez@energo-szoft.hu>; "PostgreSQL Cygwin (E-mail)" <pgsql-cygwin@postgresql.org>; "Psql_General (E-mail)" <pgsql-general@postgresql.org> Sent: Saturday, August 09, 2003 6:12 PM Subject: Re: [CYGWIN] [GENERAL] FATAL: The database system is in recovery mode [snip] > Also win9x just doesn't have the preemptiveness needed in the kernel to > handle something like PostgreSQL. Not knowing much about 'kernel's, can you explain to me in general terms what preemptiveness means in that context please. > [snip] Thanks Roger