From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Kay-Uwe Michaelis <kum(at)kumichaelis(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to rebuild tables |
Date: | 2002-05-31 09:05:55 |
Message-ID: | 20020531190555.A18673@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2002-05-31 09:07:31 | Re: restoring DB |
Previous Message | Curt Sampson | 2002-05-31 08:59:59 | sort_mem sizing (Non-linear Performance) |