Re: How to rebuild tables

On Fri, May 31, 2002 at 07:47:40AM +0200, Kay-Uwe Michaelis wrote:
> Hello list,
>
> a few days ago my HD crashed. Unfortunally i have only a copy of the PGDATA-directory, no pg_dump-file. I installed
thesame postgresql-version (6.3.2) on another system (tested it with some test-db/-tables) and then copied the
PGDATA-directoryto that computer, but that wan't work. The postmaster start correct but every frontend-command ends
witherrors (can't find db in pg_database). 
>
> What should i do to recover these databases.
> Is there a tool to use the old tables in the new database.
> Why doen't work postgresql with these PGDATA-directory ?

Well, you should create the db, then copy the files. Then you need to hope
the pg_xlog directory backed up too. if not, there is some kind of reset log
somewhere which may allow you to read it. but it's still dodgy.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Canada, Mexico, and Australia form the Axis of Nations That
> Are Actually Quite Nice But Secretly Have Nasty Thoughts About America