Re: BUG #7478: Error when using pg_restore

Sure, no problem.



But I also might take some time to do further analysis as I am little busy
with other things as well.

Hope it will not impact you much.




With Regards,

Amit Kapila.



From: Jeferson Braga [mailto:jefersonblues@gmail.com]
Sent: Thursday, August 09, 2012 7:42 PM
To: Amit Kapila
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] 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.kapila@huawei.com>

From: pgsql-bugs-owner@postgresql.org
[mailto:pgsql-bugs-owner@postgresql.org] 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:

> 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