Re: recovery from incomplete backup (pgsql 8.3)

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Henrik <lists(at)kirneh(dot)eu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: recovery from incomplete backup (pgsql 8.3)
Date: 2013-09-29 00:54:19
Message-ID: 52477A3B.9050109@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Muhammad Bashir Al-Noimi 2013-09-29 05:05:39 Re: Building with MinGW issue
Previous Message Adrian Klaver 2013-09-28 22:43:56 Re: recovery from incomplete backup (pgsql 8.3)