recovery from incomplete backup (pgsql 8.3) - Mailing list pgsql-general

From Henrik
Subject recovery from incomplete backup (pgsql 8.3)
Date
Msg-id 52472068.6000003@kirneh.eu
Whole thread Raw
Responses Re: recovery from incomplete backup (pgsql 8.3)  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: recovery from incomplete backup (pgsql 8.3)  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
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?


pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: PostgreSQL 9.2.4 temp files never released?
Next
From: John R Pierce
Date:
Subject: Re: multiple databases vs multiple clusters on the same host