Re: [BUGS] BUG #7590: Data corruption using pg_dump only with -Z parameter

2012-10-13 Thread Jan Vodička
That would be definitely much more comfortable solution. Problem was really in newlines \n vs. \r\n. Replace \r\n -> \n solved problem. Thanks a lot. 2012/10/13 Craig Ringer > On 10/10/2012 03:07 AM, Jan Vodička wrote: > >> = not able to unpack, invalid >> >> Try this one generated by "pg_dump

Re: [BUGS] BUG #7590: Data corruption using pg_dump only with -Z parameter

2012-10-13 Thread Jan Vodička
Thanks. I've already looked. Problem was that Windows replaced '\n' to '\r\n', replacing bytes back '\r\n' -> '\n' solved the problem. It was working on 16GB gzip package. It should be nice to mention this behavior somewhere. Jan Vodicka 2012/10/13 Tom Lane > Craig Ringer writes: > > On 10/1

Re: [BUGS] BUG #7590: Data corruption using pg_dump only with -Z parameter

2012-10-13 Thread Tom Lane
Craig Ringer writes: > On 10/10/2012 02:38 AM, Tom Lane wrote: >> On Windows, that doesn't seem terribly surprising: Windows will probably >> do newline munging on the process's stdout, which will corrupt >> compressed data since it's not plain text. > pg_dump might want to refuse to write to std

Re: [BUGS] BUG #7590: Data corruption using pg_dump only with -Z parameter

2012-10-13 Thread Craig Ringer
On 10/10/2012 03:07 AM, Jan Vodička wrote: = not able to unpack, invalid Try this one generated by "pg_dump -Z1 > backup.gz" in windows: http://mstu.cz/~hrtlik/backup.gz (0.5kB) original "pg_dump > backup.gz" without compression: http://mstu.cz/~hrtlik/backup

Re: [BUGS] BUG #7590: Data corruption using pg_dump only with -Z parameter

2012-10-13 Thread Craig Ringer
On 10/10/2012 02:38 AM, Tom Lane wrote: hrt...@gmail.com writes: The following bug has been logged on the website: Bug reference: 7590 Logged by: Jan Vodi�ka Email address: hrt...@gmail.com PostgreSQL version: 9.2.1 Operating system: Windows 8 Description: "pg_dump -Z1 m

Re: [BUGS] BUG #7590: Data corruption using pg_dump only with -Z parameter

2012-10-09 Thread Jan Vodička
= not able to unpack, invalid Try this one generated by "pg_dump -Z1 > backup.gz" in windows: http://mstu.cz/~hrtlik/backup.gz (0.5kB) original "pg_dump > backup.gz" without compression: http://mstu.cz/~hrtlik/backup.sql If you have any way how to get original, tell me. 2012/10/9 Ryan Kelly

Re: [BUGS] BUG #7590: Data corruption using pg_dump only with -Z parameter

2012-10-09 Thread Jan Vodička
So is there any way how to get plain sql from this "corrupted" backup? It would be nice to mention this behavior in manual. 2012/10/9 Tom Lane > hrt...@gmail.com writes: > > The following bug has been logged on the website: > > Bug reference: 7590 > > Logged by: Jan Vodička > > Em

Re: [BUGS] BUG #7590: Data corruption using pg_dump only with -Z parameter

2012-10-09 Thread Ryan Kelly
On Tue, Oct 09, 2012 at 02:20:40PM +, hrt...@gmail.com wrote: > The following bug has been logged on the website: > > Bug reference: 7590 > Logged by: Jan Vodička > Email address: hrt...@gmail.com > PostgreSQL version: 9.2.1 > Operating system: Windows 8 > Description:

Re: [BUGS] BUG #7590: Data corruption using pg_dump only with -Z parameter

2012-10-09 Thread Tom Lane
hrt...@gmail.com writes: > The following bug has been logged on the website: > Bug reference: 7590 > Logged by: Jan Vodička > Email address: hrt...@gmail.com > PostgreSQL version: 9.2.1 > Operating system: Windows 8 > Description: > "pg_dump -Z1 my_db > backup" always