From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | Andrus <kobruleht2(at)hot(dot)ee> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: How to recover data from cluster |
Date: | 2012-02-16 19:24:55 |
Message-ID: | 4F3D5807.6080401@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Alan Hodgson | 2012-02-16 19:37:43 | Re: How to recover data from cluster |
Previous Message | Jack Christensen | 2012-02-16 19:19:16 | Set returning functions in select column list |