Postgres Pro
Downloads
Home   >   mailing lists

Re: Unexpected block ID found when reading data - Mailing list pgsql-general

From Vijaykumar Jain
Subject Re: Unexpected block ID found when reading data
Date
Msg-id CAM+6J95EhF609LYf6bEbR+go8=tSca4fTkRZv=w62x5UfdcRdg@mail.gmail.com
Whole thread Raw
In response to Re: Unexpected block ID found when reading data  (Gilar Ginanjar <gilar@innovation-project.com>)
Responses Re: Unexpected block ID found when reading data
Re: Unexpected block ID found when reading data
List pgsql-general
Tree view
On Tue, 3 Aug 2021 at 08:19, Gilar Ginanjar <gilar@innovation-project.com> wrote:
Hi, Adrian

Thanks in advance.

pdgump command:
pg_dump -U myuser -Fc -Z3 -d mydb > dbdump.backup

I'm not sure which pg_dump version did i use before, but I used psql 12.5 to dump and the db version is postgresql 9.6.

pgrestore command:
pg_restore -U myuser -j8 -d mydb dbdump.backup

I’ve tried to restore to postgre 9.6, 12.1 and 12.5

do you remember which patch version 9.6.x did you take the dump from ?

9.6 has had a lot of minor fixes all the way to 9.6.22 , I am speculating, maybe your restoration to the latest minor version is failing.
can you run a pg_restore -f <filename> ... so it creates a sql dump file and check if that is clean ?
and then check the version in the dump file, and compile that version from source (or git) and try if the restore worked fine there.
just saying, in case you are out of options, else ignore.
  

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command
Next
From: Joe Conway
Date:
Subject: Re: pgcrypto - real life examples to encrypt / decrypt