View Single Post

   
  #2 (permalink)  
Old 04-12-2008, 01:05 AM
Andrew Sullivan
 
Posts: n/a
Default Re: Retore Postgres DB without dump

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


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply With Quote