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 <fluca1...@gmail.com> wrote:
> 
> On Tue, Aug 3, 2021 at 4:49 AM Gilar Ginanjar
> <gi...@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



Reply via email to