Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 64C952E0060 for ; Fri, 11 Apr 2008 13:41:06 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 08895-04 for ; Fri, 11 Apr 2008 13:41:03 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by developer.postgresql.org (Postfix) with ESMTP id 9BE2F2E0054 for ; Fri, 11 Apr 2008 13:41:03 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=crankycanuck.ca) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1JkMIr-0001uZ-S8 for pgsql-admin@postgresql.org; Fri, 11 Apr 2008 12:40:41 -0400 Received: by crankycanuck.ca (Postfix, from userid 1000) id 87C745014A; Fri, 11 Apr 2008 12:40:16 -0400 (EDT) Date: Fri, 11 Apr 2008 12:40:16 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Retore Postgres DB without dump Message-ID: <20080411164016.GA28760@crankycanuck.ca> Mail-Followup-To: Andrew Sullivan , pgsql-admin@postgresql.org References: <47FF722D.20705@adm.unige.ch> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <47FF722D.20705@adm.unige.ch> User-Agent: Mutt/1.5.13 (2006-08-11) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200804/97 X-Sequence-Number: 28861 On Fri, Apr 11, 2008 at 04:14:05PM +0200, Baudrion Philippe wrote: > - So, I have build and installed a 7.4 version of Postgres > - Copy the files in an empty database > - Connection was ok, but "\dt" told me "no relations found". > > What can I try next ? > I also have the original "pg_clog" and "pg_xlog" directories, and I have > also tried to replace them. What can I do with the WAL segments ? If you didn't put everything back in the same place, you won't get a data area. Just start up the 7.4 back end against the entire data tree of the old 7.4 installation. a