Обсуждение: Database recovery from tablespace only
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)
Phillip Black.
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!
On Sat, Mar 21, 2020 at 05:48:03PM -0600, Phillip Black wrote: > Hey Hackers, Hi, This list is for development and bug reports. I think you'll want a professional support contract, for postgres or for generic data recovery. https://www.postgresql.org/support/professional_support/ -- Justin
On Sat, Mar 21, 2020 at 4:48 PM Phillip Black <phillipvblack@gmail.com> wrote:
What are the alternatives for recovery here? (besides trying to recover disk data with specialists)
You are running ancient, unsupported, software on hardware that has a lifetime which you've probably also exceeded and are not actively testing backups. Its is unlikely you are going to get a positive result without finally spending some time and money by hiring a specialist. Or, just consider the lost data as an expected outcome given previous behaviors and move forward. Or, at minimum, someone who can sit/login to the computer and network setup in question and interact with it - even if they cannot do the disk data recovery they can at least provide a professional opinion.
David J.