Re: Retore Postgres DB without dump

[Andrew Sullivan <ajs(at)crankycanuck(dot)ca>]

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