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.
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++ |