X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C3BD33A1AC8 for ; Mon, 20 Dec 2004 01:08:53 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 30375-02 for ; Mon, 20 Dec 2004 01:08:40 +0000 (GMT) Received: from web50404.mail.yahoo.com (web50404.mail.yahoo.com [206.190.38.69]) by svr1.postgresql.org (Postfix) with SMTP id 313403A1AB3 for ; Mon, 20 Dec 2004 01:08:42 +0000 (GMT) Received: (qmail 24422 invoked by uid 60001); 20 Dec 2004 01:08:42 -0000 Message-ID: <20041220010842.24421.qmail@web50404.mail.yahoo.com> Received: from [62.252.64.13] by web50404.mail.yahoo.com via HTTP; Sun, 19 Dec 2004 17:08:42 PST Date: Sun, 19 Dec 2004 17:08:42 -0800 (PST) From: Harry Reply-To: harry@uklug.co.uk Subject: Re: Database Recovery To: pgsql-docs@postgresql.org In-Reply-To: <20041220004132.GA8996@dcc.uchile.cl> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.28 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200412/33 X-Sequence-Number: 2729 --- Alvaro Herrera wrote: > > http://www.hjackson.org/blog/archives/2004/12/postgresql_data.html > > Huh, this sounds like transaction Id wraparound to me. Do you > regularly run vacuums on the whole database? Did you ask for expert > help on the lists before running to do whatever you did? I didn't run to do anything ;) I had a good think and a good google before I done anything and I have all my data back because of it. Luckily for me the data was neither life or job threatening so I was able to take a few more risks than necessary. I was actually volunteering to write the database recovery section of the docs, not asking for help. As per TID wraparound. I have been lucky enough never to have received anything similar to the following warning (taken from 7.4 docs) play=# vacuum; WARNING: Some databases have not been vacuumed in 1613770184 transactions. Better vacuum them within 533713463 transactions, or you may have a wraparound failure. VACUUM you will also notice that I used a TID of less than 100 million to recover the database. I was nowhere near 0.5 billion as recommended by the docs. Harry ===== Harry Join team plico. http://www.hjackson.org/cgi-bin/folding/index.pl __________________________________ Do you Yahoo!? Yahoo! Mail - Easier than ever with enhanced search. Learn more. http://info.mail.yahoo.com/mail_250