Search Postgresql Archives

Re: recovery from incomplete backup (pgsql 8.3)

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

 



On 09/28/2013 11:31 AM, Henrik wrote:
hello,

I am trying to recover data from postgesql 8.3 incomplete backup. I have
contents of data/base/ (fs snapshot), but there some tablespaces
(indexes, some tables) were in other locations.

On new server (clean install) I created database, replaced base folder,
renamed database folder to match new database's created name. Postgresql
starts successfully, but it does not see tables in database, there are
no related entries in logs.

How could I recover data from available backup?

I would think to have any hope you would need the entire PGDATA directory from the old installation:

http://www.postgresql.org/docs/8.3/static/storage-file-layout.html

Otherwise you are working with a mix of old and new information, in particular old information in base and new information in global.





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