Thread: How to recover data from cluster

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

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.

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