Re: Unexpected block ID found when reading data

From: Luca Ferrari <fluca1978(at)gmail(dot)com>
To: Gilar Ginanjar <gilar(at)innovation-project(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Unexpected block ID found when reading data
Date: 2021-08-03 10:06:05
Message-ID: CAKoxK+5qfWq6jPLR2eDw_zGnwAzp=inSP=HusLfd1sbvSJPB7w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 3, 2021 at 4:49 AM Gilar Ginanjar
<gilar(at)innovation-project(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vikas Sharma 2021-08-03 11:03:02 Re: pgcrypto - real life examples to encrypt / decrypt
Previous Message Luca Ferrari 2021-08-03 10:02:55 Re: pgcrypto - real life examples to encrypt / decrypt