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.
