Re: Unexpected block ID found when reading data

Hi, Luca

Thanks for the response.

I’ve tried with option -L and -l before. The schema is fine, but sadly when i try to restore only data on the tables i need, it comes up with the error.

Is there any small chance I can view/save/restore my data? I desperately need it.

Many thanks.

> On 3 Aug 2021, at 17.06, Luca Ferrari <fluca1978(at)gmail(dot)com> wrote:
>
> 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