Re: [BUGS] Sorry to bother you. Please tell me exactly how the compiler was built ODBC

2012-10-13 Thread Craig Ringer
On 10/12/2012 10:29 PM, Копыченко Павел wrote: Sorry to bother you. Please tell me exactly how the compiler was built ODBC driver psqlodbc-09.01.0200 architecture for Windows 64? What exact version of the compiler? please This isn't a bug report. You might want to ask on the psql-odbc mailing

Re: [BUGS] BUG #7600: Database crash with data corruption

2012-10-13 Thread Craig Ringer
On 10/12/2012 09:35 PM, hankiew...@gmail.com wrote: 5) after recovery was completed we have discovered that sequences on production database had wrong values To follow up on Tom's explanation, if you're relying on sequences not having "holes" then your design is dangerously mistaken. A simple

Re: [BUGS] BUG #7595: terminate process in an unusual way

2012-10-13 Thread Craig Ringer
On 10/11/2012 05:00 PM, hikkis...@hotmail.com wrote: 2012-10-10 16:01:55 KST PANIC: could not write to log file 4, segment 232 at offset 15237120, length 16384: Invalid argument That's a ... weird ... error. Do you have antivirus software running on your computer? That'd be my first suspect.

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-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 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 #7534: walreceiver takes long time to detect n/w breakdown

2012-10-13 Thread Fujii Masao
On Thu, Oct 11, 2012 at 11:52 PM, Heikki Linnakangas wrote: > On 11.10.2012 13:17, Amit Kapila wrote: >>> >>> How does this look now? >> >> >> The Patch is fine and test results are also fine. > > > Ok, thanks. Committed. I found one typo. The attached patch fixes that typo. ISTM you need to upd

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 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

[BUGS] pg_ctl restart issue with relative paths

2012-10-13 Thread Thom Brown
Hi, I have noticed that, using pg_ctl, if you start Postgres using a relative path, then attempt to restart it from anywhere else, it fails. Example: thom@swift /tmp $ pg_ctl -D primary start server starting thom@swift /tmp $ pg_ctl -D primary restart waiting for server to shut down done ser

Re: [BUGS] BUG #7592: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

2012-10-13 Thread Craig Ringer
On 10/10/2012 01:07 PM, devenmtha...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 7592 Logged by: Deven Email address: devenmtha...@gmail.com PostgreSQL version: 9.0.3 Operating system: Windows 2008 R2 WITH SP1 (64 BITS) Description: We

Re: [BUGS] BUG #7592: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

2012-10-13 Thread John R Pierce
On 10/09/12 10:07 PM, devenmtha...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 7592 Logged by: Deven Email address: devenmtha...@gmail.com PostgreSQL version: 9.0.3 Operating system: Windows 2008 R2 WITH SP1 (64 BITS) Description: We ar

Re: [BUGS] BUG #6510: A simple prompt is displayed using wrong charset

2012-10-13 Thread Alexander Law
Hi Noah, Thank you for your review. I agree with you, CONOUT$ way is much simpler. Please look at the patch. Regarding msys - yes, that check was not correct. In fact you can use "con" with msys, if you run sh.exe, not a graphical terminal. So the issue with con not related to msys, but to some

Re: [BUGS] Sorry to bother you. Please tell me exactly how the compiler was built ODBC

2012-10-13 Thread Hiroshi Saito
Hi Копыченко-san. sorry late reaction. Here is explanation of the build method. http://psqlodbc.projects.postgresql.org/win32-compilation.html however, VS2012 is referred to by the reason Microsoft always offers the newest IDE. I had not used VS2012 yet..:-( therefore, It does not know whether i