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

Re: Losing data

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk>
Subject: Re: Losing data
Date: 2008-06-20 04:26:16
Message-ID: 200806200026.16387.xzilla@users.sourceforge.net (view raw or flat)
Thread:
Lists: 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

In response to

Responses

pgsql-general by date

Next:From: Tom LaneDate: 2008-06-20 04:49:13
Subject: Re: Losing data
Previous:From: Adrian KlaverDate: 2008-06-20 00:35:03
Subject: Re: Importing undelimited files (Flat Files or Fixed-Length records)

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