Re: How to recover data from cluster

From: Alan Hodgson <ahodgson(at)simkin(dot)ca>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to recover data from cluster
Date: 2012-02-16 19:37:43
Message-ID: 17274925.tATkA7xNlO@skynet.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2012-02-16 19:41:51 Re: How to recover data from cluster
Previous Message Adrian Klaver 2012-02-16 19:24:55 Re: How to recover data from cluster