Re: Unexpected block ID found when reading data

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(dot)github(at)gmail(dot)com> wrote:
>
> On Tue, 3 Aug 2021 at 08:19, Gilar Ginanjar <gilar(at)innovation-project(dot)com <mailto:gilar(at)innovation-project(dot)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.
>