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 699353A1A90 for ; Mon, 20 Dec 2004 00:11:30 +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 15976-04 for ; Mon, 20 Dec 2004 00:11:16 +0000 (GMT) Received: from web50403.mail.yahoo.com (web50403.mail.yahoo.com [206.190.38.68]) by svr1.postgresql.org (Postfix) with SMTP id 3572C3A1A8A for ; Mon, 20 Dec 2004 00:11:18 +0000 (GMT) Received: (qmail 87460 invoked by uid 60001); 20 Dec 2004 00:11:18 -0000 Message-ID: <20041220001118.87459.qmail@web50403.mail.yahoo.com> Received: from [62.252.64.13] by web50403.mail.yahoo.com via HTTP; Sun, 19 Dec 2004 16:11:17 PST Date: Sun, 19 Dec 2004 16:11:17 -0800 (PST) From: Harry Reply-To: harry@uklug.co.uk Subject: Database Recovery To: pgsql-docs@postgresql.org 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.374 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE X-Spam-Level: X-Archive-Number: 200412/28 X-Sequence-Number: 2724 I have just had a bit of a disaster with a database and found very little material online about how to recover from a corrupted database. This is not the first time I have had to recoover data from a postgres database which was caused either by some hardware failure or my own error (not sure which is worse). Is there any material online on how to recover a corrupt postgresql database? If not I would be happy to take a shot at writing something based on my own experiences. The most recent of which (I wrote it tonight) can be found at http://www.hjackson.org/blog/archives/2004/12/postgresql_data.html Its a bit long winded but if there are no docs detailing various recovery procedures and there are people willing to answer questions and make sure I was on the right track then I would be willing to write it? Has it already been written? Thoughts? ===== Harry Join team plico. http://www.hjackson.org/cgi-bin/folding/index.pl __________________________________ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail