On Friday 20 June 2008 05:26, Robert Treat wrote:
> 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?
We back up and vacuum at the same time each day.
In response to
pgsql-general by date
|Next:||From: Gregory Williamson||Date: 2008-06-20 10:29:33|
|Subject: Need to update all entries of one table based on an earlier backup|
|Previous:||From: Volkan YAZICI||Date: 2008-06-20 06:08:34|
|Subject: Re: Logging Parameter Values|