Обсуждение: Schema Restore Issue

Поиск
Список
Период
Сортировка

Schema Restore Issue

От
Omkar Dhorge
Дата:
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

Re: Schema Restore Issue

От
Tom Lane
Дата:
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

Re: Schema Restore Issue

От
Omkar Dhorge
Дата:
Hello tom, 
Thank you for reaching out to me.

No, I haven't done anything between dumping and restoring.
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!