X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D690653320 for ; Mon, 18 Apr 2005 18:35:23 -0300 (ADT) 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 95390-09 for ; Mon, 18 Apr 2005 21:35:16 +0000 (GMT) Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id BF6F353319 for ; Mon, 18 Apr 2005 18:35:15 -0300 (ADT) Received: from pegasus.cs.csubak.edu (unknown [136.168.201.110]) by svr2.postgresql.org (Postfix) with ESMTP id A6E25F0B40 for ; Mon, 18 Apr 2005 22:32:07 +0100 (BST) Received: from [136.168.201.1] (helo=[10.0.200.188]) by pegasus.cs.csubak.edu with esmtp (Exim 3.16 #1) id 1DNdrA-0007wo-00 for pgsql-admin@postgresql.org; Mon, 18 Apr 2005 14:32:36 -0700 Message-ID: <4264275F.8050709@bak.rr.com> Date: Mon, 18 Apr 2005 14:32:15 -0700 From: Steve Garcia User-Agent: Mozilla Thunderbird 1.0.2 (X11/20050330) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: I: file system backup of postgresql db onto another installation References: <200504141752.j3EHqaa8014868@posta.freefile.it> In-Reply-To: <200504141752.j3EHqaa8014868@posta.freefile.it> X-Enigmail-Version: 0.90.2.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit 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: 200504/245 X-Sequence-Number: 17258 Giovanni Gualdi wrote: > of course, I did take care of postmaster.pid file, removing it when > necessary... > thanks > Giovanni > is there any way, > any utility, to recover the data of a postgres DB just starting from > the file system? I did find a utility which does exactly what you want.... Except that it appears that it was abandoned in 2003 and only supports up to 7.3. It gave me errors when I tried to run it on a 7.4 database. The utility was called pgfsck and it was written in Perl, so it should be moderately portable. Someone who understood the new file structure could probably bring it back to life... I managed to solve my problem without loss of data, by dumb luck more than anything else. Good luck!