Re: BUG #7478: Error when using pg_restore

From: pgsql-bugs-owner@postgresql.org [mailto:pgsql-bugs-owner@postgresql.o=
rg] On Behalf Of jefersonblues@gmail.com
Sent: Friday, August 03, 2012 4:07 PM

> The following bug has been logged on the website:

> Bug reference:      7478
> Logged by:          jeferson
> Email address:      jefersonblues@gmail.com
> PostgreSQL version: 9.1.4
> Operating system:   Windows 7
> Description:=20=20=20=20=20=20=20=20

> pg_dump -Fc -U usuario -d banco -f d:\arquivo.backup

> However the restourar pg_restore with tables that are large give the erro=
r:
> [compres_io] invalid block type, already checked on some other forums peo=
ple
> have had the same problem when using and enjoying the dump format with
> custom, I tried restourar the contents into a file. sql but when you get =
14
> gigs of the entity for it.

Could you provide the exact error message and any logs related to this?
Have you tried it with less data?

With Regards,
Amit Kapila.