Schema Restore Issue - Mailing list pgsql-admin

From Omkar Dhorge
Subject Schema Restore Issue
Date
Msg-id CAKewVuuVGGoadrbHJkThSHDAm=H_YoHBzzeznbSzFGt2n0nP3Q@mail.gmail.com
Whole thread Raw
Responses Re: Schema Restore Issue
List 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 by date:

Previous
From: Wells Oliver
Date:
Subject: Re: FK cascade delete permissions Q
Next
From: Tom Lane
Date:
Subject: Re: Schema Restore Issue