| 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: | Whole Thread | Raw Message | 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++ |