| From: | Omkar Dhorge <omkardhorge(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Schema Restore Issue |
| Date: | 2021-01-30 19:34:05 |
| Message-ID: | CAKewVuuVGGoadrbHJkThSHDAm=H_YoHBzzeznbSzFGt2n0nP3Q@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-01-30 22:03:20 | Re: Schema Restore Issue |
| Previous Message | Wells Oliver | 2021-01-29 19:14:36 | Re: FK cascade delete permissions Q |