Re: Retore Postgres DB without dump - Mailing list pgsql-admin

From Andrew Sullivan
Subject Re: Retore Postgres DB without dump
Date
Msg-id 20080411164016.GA28760@crankycanuck.ca
Whole thread Raw
In response to Retore Postgres DB without dump  (Baudrion Philippe <Philippe.Baudrion@adm.unige.ch>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Baudrion Philippe
Date:
Subject: Retore Postgres DB without dump
Next
From: Shane Ambler
Date:
Subject: Re: Retore Postgres DB without dump