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

Re: [GENERAL] Restoring fscked up postgres 7.1

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Kristaps Armanis <krisha(at)grafton(dot)lv>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] Restoring fscked up postgres 7.1
Date: 2005-01-21 15:30:07
Message-ID: 20050121153001.GC3749@svana.org (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
On Fri, Jan 21, 2005 at 03:33:28PM +0200, Kristaps Armanis wrote:
> Last night no crash, not anything, just @ one moment all records for
> last year where gone, all ros created for last year & tables created
> while this time - and not in only one database, but all 6 DB's on this
> server.

Looks like XID wraparound, you hit the 4 billion transaction mark. This
was fixed in 7.2 IIRC. Unfortunatly I don't know of an easy way to
recover, but this should give you something to search the archives for.

Hope this helps,
-- 
Martijn van Oosterhout   <kleptog(at)svana(dot)org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

In response to

Responses

pgsql-admin by date

Next:From: Haron, CharlesDate: 2005-01-21 15:43:00
Subject: Re: Trouble Escaping Quotes
Previous:From: Rao KumarDate: 2005-01-21 15:27:32
Subject: postgresql 7.4.6 - FATAL Database Startup Message

pgsql-general by date

Next:From: Marco ColomboDate: 2005-01-21 15:41:57
Subject: Re: Multiline plpython procedure
Previous:From: Greg StarkDate: 2005-01-21 14:27:23
Subject: Re: Calculating a moving average

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