Re: recovery from incomplete backup (pgsql 8.3)

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.

Should have added that the new server would need to be same OS and 
architecture.

>
> How could I recover data from available backup?
>
>


-- 
Adrian Klaver
adrian.klaver@gmail.com