| 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: | Whole Thread | Raw Message | 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 |