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(at)gmail(dot)com]
Sent: Thursday, August 09, 2012 7:42 PM
To: Amit Kapila
Cc: pgsql-bugs(at)postgresql(dot)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(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