Re: Losing data - Mailing list pgsql-general

From Robert Treat
Subject Re: Losing data
Date
Msg-id 200806200026.16387.xzilla@users.sourceforge.net
Whole thread Raw
In response to Re: Losing data  (Garry Saddington <garry@schoolteachers.co.uk>)
Responses Re: Losing data  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Losing data  (Garry Saddington <garry@schoolteachers.co.uk>)
List pgsql-general
On Thursday 19 June 2008 14:06:38 Garry Saddington wrote:
> > In any case, however, if PostgreSQL reported the transaction complete and
> > the machine didn't experience any hardware problems (like sudden power or
> > disk failure), I would certainly not suspect PostgreSQL as the source of
> > the problem.
>
> What has happened to the reports then? I have used this combination of Zope
> and Postgres for 5 years with no problems like this before and we have
> written one complete set of reports on this server in the past 6 weeks. The
> problem seems to have started last friday, when reports started to go
> missing.

Out of curiosity, what is your vacuum strategy?

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL

pgsql-general by date:

Previous
From: "Mark Wilden"
Date:
Subject: Re: Vacuum and inserts
Next
From: Tom Lane
Date:
Subject: Re: Losing data