Re: BUG #7478: Error when using pg_restore

Good morning,

Can I send you when I get home I send you the log. and a print error.

Thank you for your attention.

2012/8/9 Amit Kapila <amit(dot)kapila(at)huawei(dot)com>

> 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.
>
>

--
*Jeferson Braga do Carmo*
*Analista / Desenvolvedor .Net*
61 8237-1888
61 3359-3781