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 97B5F3E8-0808-4E3D-8D5B-012661182685@innovation-project.com
Whole thread Raw
In response to Re: Unexpected block ID found when reading data  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
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.klaver@aklaver.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.klaver@aklaver.com




pgsql-general by date:

Previous
From: Gilar Ginanjar
Date:
Subject: Re: Unexpected block ID found when reading data
Next
From: Vikas Sharma
Date:
Subject: Re: pgcrypto - real life examples to encrypt / decrypt