Re: Restore database from files (not dump files)?

From: wheel <wheel(at)wheel(dot)not>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Restore database from files (not dump files)?
Date: 2006-12-04 17:18:23
Message-ID: MPG.1fddf83774a29a2598973b@newsgroups.comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In article <74A84126-07CC-458C-B4FD-ECD2431831D8(at)mitre(dot)org>,
john(at)mitre(dot)org says...
> >> I have copied the folders back to the base dir (like C:\PostgreSQL
> >> \data
> >> \base\16404) if that's step one but what after that?
> >
> > Just start Postgres. If the data dir is ok, it should run fine.
>
> It's unclear from your description whether the raw DB files were
> moved from another installation - note that the above is only
> guaranteed to work if architecture/compiler/etc. are all the same.
> If the files were created by exactly the same PG instance, then you
> should be okay.
>
> - John D. Burger
> MITRE
>
The raw db files are not from this installation, but same ver of windows
binary pg. Does this mean the db is not going to be useable/recoverable?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2006-12-04 17:32:28 PG Admin
Previous Message novnov 2006-12-04 17:12:59 Re: Speed of postgres compared to ms sql, is this