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@xxxxxxxxx> wrote: > > On Tue, Aug 3, 2021 at 4:49 AM Gilar Ginanjar > <gilar@xxxxxxxxxxxxxxxxxxxxxx> 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
