Database recovery from tablespace only - Mailing list pgsql-hackers

From Phillip Black
Subject Database recovery from tablespace only
Date
Msg-id CAPiNrrUcBePufndn26TEFP3BWSoHsrZ560c-huNGSf7caBtsJQ@mail.gmail.com
Whole thread Raw
Responses Re: Database recovery from tablespace only  (Justin Pryzby <pryzby@telsasoft.com>)
Re: Database recovery from tablespace only  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
Hey Hackers,

We had a database running on debian where its disks went corrupted. And currently is not possible to access those disks, unreadable.

For backup we used:

File System Level Backup
Continuous Archiving and Point-in-Time Recovery (PITR)

We used tablespaces for the entire database.

When trying to recover from the backup we noticed that the backup was partially complete, here is the info:

PG_VERSION 8.2.4

base  we are missing the files

global  we are missing the files

pg_clog  we are missing the files

pg_multixact  we are missing the files

pg_subtrans  we are missing the files

pg_tblspc  All files are preserved there from a backup

pg_twophase  we are missing the files

pg_xlog  we are missing the files


Previous backups had the same error. We only have backups from the last 2 weeks.

We have a very old (about 10 years old) data/

What are the alternatives for recovery here? (besides trying to recover disk data with specialists)

Thanks!

Phillip Black.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Refactor compile-time assertion checks for C/C++
Next
From: Mahendra Singh Thalor
Date:
Subject: Re: Why does [auto-]vacuum delay not report a wait event?