Re: BUG #7478: Error when using pg_restore

From: pgsql-bugs-owner(at)postgresql(dot)org [mailto:pgsql-bugs-owner(at)postgresql(dot)org] On Behalf Of jefersonblues(at)gmail(dot)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(at)gmail(dot)com
> PostgreSQL version: 9.1.4
> Operating system: Windows 7
> Description:

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

> However the restourar pg_restore with tables that are large give the error:
> [compres_io] invalid block type, already checked on some other forums people
> 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.