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 the same postgresql-version (6.3.2) on another system (tested it with some test-db/-tables) and then copied the PGDATA-directory to that computer, but that wan't work. The postmaster start correct but every frontend-command ends with errors (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(at)svana(dot)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