Обсуждение: BUG #7478: Error when using pg_restore
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:=20=20=20=20=20=20=20=20 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. I would like to give me a light to this problem. thank you
From: pgsql-bugs-owner@postgresql.org [mailto:pgsql-bugs-owner@postgresql.o= rg] 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:=20=20=20=20=20=20=20=20 > pg_dump -Fc -U usuario -d banco -f d:\arquivo.backup > However the restourar pg_restore with tables that are large give the erro= r: > [compres_io] invalid block type, already checked on some other forums peo= ple > 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.
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
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