Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 6C85A9FB42F for ; Fri, 13 Oct 2006 04:52:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 28369-01 for ; Fri, 13 Oct 2006 07:52:08 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.203]) by postgresql.org (Postfix) with ESMTP id 8AB1C9FB502 for ; Fri, 13 Oct 2006 04:44:52 -0300 (ADT) Received: by nz-out-0102.google.com with SMTP id 34so339258nzf for ; Fri, 13 Oct 2006 00:44:51 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=UbkMHnpHp7BP4yfGiU4Hy4xEI6knXkF+7KQ9bTUNx7xzgaNggjm/Y/35JL9k3XqZFk7kda71bu6k44Fa6Pq/xL6y92cy9jM81wPXlta8seBO687cadO6yYy2brEgeV17Pi41PFYw0QLtOx8TLBVEjxkg3uwdXRdlU8OBn9VF/qM= Received: by 10.65.23.15 with SMTP id a15mr4364415qbj; Fri, 13 Oct 2006 00:44:51 -0700 (PDT) Received: by 10.65.211.3 with HTTP; Fri, 13 Oct 2006 00:44:51 -0700 (PDT) Message-ID: Date: Fri, 13 Oct 2006 09:44:51 +0200 From: "Frenzen Garduan" To: pgsql-admin@postgresql.org Subject: [pg 8.0] Restore from incremental "data folder" backup after server crash MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_55330_5521734.1160725491083" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.551 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_10_20, HTML_MESSAGE, SPF_PASS X-Spam-Level: * X-Archive-Number: 200610/86 X-Sequence-Number: 23389 ------=_Part_55330_5521734.1160725491083 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello. Some days ago our server with postgres 8.0 crashed. that woudn't be so much fatal if we would have a complete backup, but there isnt one. We only have a incremental backup from the psql data folder, including - the complete "base" dir, - "pg_control" and "pgstat.stat" from "global" dir - one 32kb file from "pg_clog" folder - one 160kb file from "pg_subtrans" folder - one 16mb file from "pg_xlog" and at least the postgres.log Is there any possibility to extract or restore our database data, or just parts of them? I have to extract as much as possible databases/tables... Or is there any tool to extract the data? The Database structur isnt so important, but the data from some tables... At all the database consists around 20 databases with ca. 30-40 tables per database. Thank you for your help and sorry for my bad english. ------=_Part_55330_5521734.1160725491083 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello.
Some days ago our server with postgres 8.0 crashed. that woudn't be so much fatal if we would have a complete backup, but there isnt one. We only have a incremental backup from the psql data folder, including
- the complete "base" dir,
- "pg_control" and "pgstat.stat" from "global" dir
- one 32kb file from "pg_clog" folder
- one 160kb file from "pg_subtrans" folder
- one 16mb file from "pg_xlog"
and at least the postgres.log

Is there any possibility to extract or restore our database data, or just parts of them? I have to extract as much as possible databases/tables... Or is there any tool to extract the data? The Database structur isnt so important, but the data from some tables... At all the database consists around 20 databases with ca. 30-40 tables per database.

Thank you for your help and sorry for my bad english. ------=_Part_55330_5521734.1160725491083--