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 > From: pgsql-bugs-ow...@postgresql.org [mailto: > pgsql-bugs-ow...@postgresql.org] On Behalf Of jefersonbl...@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: jefersonbl...@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
Re: [BUGS] 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:jefersonbl...@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 From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of jefersonbl...@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: jefersonbl...@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
Re: [BUGS] BUG #7478: Error when using pg_restore
From: pgsql-bugs-ow...@postgresql.org [mailto:pgsql-bugs-ow...@postgresql.org] On Behalf Of jefersonbl...@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: jefersonbl...@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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
