Search Postgresql Archives

Re: How to recover data from cluster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux