Re: [GENERAL] How to recover data from cluster
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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] How to recover data from cluster
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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] 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.kla...@gmail.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] How to recover data from cluster
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 ? Andrus.