Thread: How to recover data from cluster

How to recover data from cluster

From
"Andrus"
Date:
PostgreSql 8.4 in windows crashes. After that Windows disk repairing was used to repair hard drive.
After that Data/base directory from crashed server contains lot of files, all files are readable.
 
PostgreSql 8.4 was reinstalled in new server and data directory was set to directory from crashed server.
 
pgAdmin shows that there is only public schema without any tables.
Actually there was two schemas with lot of tables.
 
How to fix this so old data is accessible ?
 
Andrus.

Re: How to recover data from cluster

From
Adrian Klaver
Date:
On 02/16/2012 11:18 AM, Andrus wrote:
> PostgreSql 8.4 in windows crashes. After that Windows disk repairing was
> used to repair hard drive.
> After that Data/base directory from crashed server contains lot of
> files, all files are readable.

There is readable and there is not-corrupt :(

> PostgreSql 8.4 was reinstalled in new server and data directory was set
> to directory from crashed server.
> pgAdmin shows that there is only public schema without any tables.
> Actually there was two schemas with lot of tables.

What does the Postgres log show when you start the database and try to
access the tables?

> How to fix this so old data is accessible ?
> Andrus.


--
Adrian Klaver
adrian.klaver@gmail.com

Re: How to recover data from cluster

From
Alan Hodgson
Date:
On Thursday, February 16, 2012 09:18:34 PM Andrus wrote:
> PostgreSql 8.4 in windows crashes. After that Windows disk repairing was
> used to repair hard drive. After that Data/base directory from crashed
> server contains lot of files, all files are readable.
>
> PostgreSql 8.4 was reinstalled in new server and data directory was set to
> directory from crashed server.
>
> pgAdmin shows that there is only public schema without any tables.
> Actually there was two schemas with lot of tables.
>
> How to fix this so old data is accessible ?
>

It sounds like your new installation is not in fact using the old data
directory, but a new empty one.

Re: How to recover data from cluster

From
Adrian Klaver
Date:
On 02/16/2012 11:37 AM, Alan Hodgson wrote:
> On Thursday, February 16, 2012 09:18:34 PM Andrus wrote:

>>
>
> It sounds like your new installation is not in fact using the old data
> directory, but a new empty one.

To add, are you sure that pgAdmin is pointed at the right server?

>


--
Adrian Klaver
adrian.klaver@gmail.com