Re: Losing data

From: Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Losing data
Date: 2008-06-20 06:41:42
Message-ID: 200806200741.42355.garry@schoolteachers.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.
garry

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gregory Williamson 2008-06-20 10:29:33 Need to update all entries of one table based on an earlier backup
Previous Message Volkan YAZICI 2008-06-20 06:08:34 Re: Logging Parameter Values