Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.

In response to

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group