Re: Unexpected block ID found when reading data

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

> On 3 Aug 2021, at 09.11, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> wrote:
>
> On 8/2/21 6:42 PM, Gilar Ginanjar wrote:
>> Hi,
>> I have a db dump (.backup) that i want to restore. But it comes up with error:
>> "found unexpected block ID when reading data"
>> Is there any chance i can save my backup? The problem is I don't have the database anymore.
>> I used psql 12.5 when dumping the database approx a year ago.
>
> What command and version of pg_dump did you use to dump it?
>
> What command and program(and version) did you use to restore it?
>
> What version of Postgres where you restoring to?
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com