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

From Luca Ferrari
Subject Re: Unexpected block ID found when reading data
Date
Msg-id CAKoxK+5qfWq6jPLR2eDw_zGnwAzp=inSP=HusLfd1sbvSJPB7w@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
List pgsql-general
On Tue, Aug 3, 2021 at 4:49 AM Gilar Ginanjar
<gilar@innovation-project.com> wrote:
> pgrestore command:
> pg_restore -U myuser -j8 -d mydb dbdump.backup
>

As a desparate approach I would try to use options -L and -l to
extract objects from the backup and restore a small subset of them, in
order to find out where the error is.
I suspect the compressed archived is damaged.

Luca



pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: pgcrypto - real life examples to encrypt / decrypt
Next
From: Vikas Sharma
Date:
Subject: Re: pgcrypto - real life examples to encrypt / decrypt