Thread: Schema Restore Issue
Hello,
I am running with some issues while restoring the backup on Postgres.
I took a schema backup and I am again trying to restore the same backup to verify if the backup has all the data/constraints/indexes etc. (I am trying to create a cron job that take a schema backup on daily basis)
Restore process says,
pg_restore: error: found unexpected block ID (-1385344593) when reading data -- expected 3425
Postgres Version I'm using,
PostgreSQL 11.5 (Debian 11.5-3.pgdg90+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0 20170516, 64-bit
Let me know if you have any suggestions.
Thanks in advance!
Regards,
Omkar Dhorge
Omkar Dhorge <omkardhorge@gmail.com> writes: > Restore process says, > pg_restore: error: found unexpected block ID (-1385344593) when reading > data -- expected 3425 Certainly sounds like a corrupted dump file. Did you do anything to it in between dumping and restoring? regards, tom lane
Hello tom,
Thank you for reaching out to me.
pg_restore is able to create tables, sequences but it fails later on while processing the table data.
Let me know if you need any other information.
Thanks in advance!