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

From Gilar Ginanjar
Subject Re: Unexpected block ID found when reading data
Date
Msg-id 7D88A569-8920-41E0-BF77-EB16FB2934BB@innovation-project.com
Whole thread Raw
In response to Re: Unexpected block ID found when reading data  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Responses Re: Unexpected block ID found when reading data
List pgsql-general
I’m not sure which patch version i used to dump, but i was using postgre 12.5 for pg_dump back then.

I’m running pg_restore -f dbdump.backup right now, I think it will take some times because it has a large size (around 9 GB). There are no issues yet.

Thanks for advice.


On 3 Aug 2021, at 20.15, Vijaykumar Jain <vijaykumarjain.github@gmail.com> wrote:

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: Tom Lane
Date:
Subject: Re: Unexpected block ID found when reading data
Next
From: Gilar Ginanjar
Date:
Subject: Re: Unexpected block ID found when reading data