Database recovery from tablespace only

From: Phillip Black <phillipvblack(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Database recovery from tablespace only
Date: 2020-03-21 23:48:03
Message-ID: CAPiNrrUcBePufndn26TEFP3BWSoHsrZ560c-huNGSf7caBtsJQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mahendra Singh Thalor 2020-03-21 23:54:29 Re: Why does [auto-]vacuum delay not report a wait event?
Previous Message Tom Lane 2020-03-21 23:22:41 Re: Refactor compile-time assertion checks for C/C++