Schema Restore Issue

Поиск
Список
Период
Сортировка
От Omkar Dhorge
Тема Schema Restore Issue
Дата
Msg-id CAKewVuuVGGoadrbHJkThSHDAm=H_YoHBzzeznbSzFGt2n0nP3Q@mail.gmail.com
обсуждение исходный текст
Ответы Re: Schema Restore Issue
Список pgsql-admin
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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Wells Oliver
Дата:
Сообщение: Re: FK cascade delete permissions Q
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Schema Restore Issue