Re: Losing data - Mailing list pgsql-general

From Tom Lane
Subject Re: Losing data
Date
Msg-id 6570.1213937353@sss.pgh.pa.us
Whole thread Raw
In response to Re: Losing data  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
Robert Treat <xzilla@users.sourceforge.net> writes:
> On Thursday 19 June 2008 14:06:38 Garry Saddington wrote:
>> The problem seems to have started last friday, when reports started to go
>> missing.

> Out of curiosity, what is your vacuum strategy?

If you're thinking "transaction ID wraparound", I believe we can rule
that out, because Garry says he's running PG 8.1.  8.1 is not terribly
proactive about preventing wraparound (no forced autovacuums), but it
will squawk loudly about impending wraparound and shut down before it
hits the wall.

My bet is that something was changed in the client-side software last
week that has broken its commit-issuing behavior.

            regards, tom lane

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Losing data
Next
From: Volkan YAZICI
Date:
Subject: Re: Logging Parameter Values