pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

Schema Restore Issue
3+ messages / 2 participants
[nested] [flat]

* Schema Restore Issue
@ 2021-01-30 19:34  Omkar Dhorge <omkardhorge@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Omkar Dhorge @ 2021-01-30 19:34 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org

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

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Schema Restore Issue
@ 2021-01-30 22:03  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Omkar Dhorge <omkardhorge@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2021-01-30 22:03 UTC (permalink / raw)
  To: Omkar Dhorge <omkardhorge@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org

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





^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Schema Restore Issue
@ 2021-01-30 22:12  Omkar Dhorge <omkardhorge@gmail.com>
  parent: Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Omkar Dhorge @ 2021-01-30 22:12 UTC (permalink / raw)
  To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin@lists.postgresql.org

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!

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

end of thread, other threads:[~2021-01-30 22:12 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-01-30 19:34 Schema Restore Issue Omkar Dhorge <omkardhorge@gmail.com>
2021-01-30 22:03 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-01-30 22:12   ` Omkar Dhorge <omkardhorge@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox