Re: Retore Postgres DB without dump

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Retore Postgres DB without dump
Date: 2008-04-11 16:40:16
Message-ID: 20080411164016.GA28760@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shane Ambler 2008-04-11 16:50:53 Re: Retore Postgres DB without dump
Previous Message Baudrion Philippe 2008-04-11 14:14:05 Retore Postgres DB without dump