Re: [BUGS] BUG #6661: out-of-order XID insertion in KnownAssignedXids

2012-06-08 Thread Simon Riggs
On 7 June 2012 17:49, Andres Freund wrote: > A patch implementing that is attached. Unfortunately not really tested yet > because its kinda hard to hit that code-path. > > Valentine, can you test that patch? Patch looks good, so as soon as we confirm it we can apply. --  Simon Riggs   

Re: [BUGS] BUG #6661: out-of-order XID insertion in KnownAssignedXids

2012-06-08 Thread Valentine Gogichashvili
Hi Andres, unfortunately I did not manage to keep the snapshot of the database, that had this issue. Can that be, that this issue only happens when the recovering from the WAL files and not over the steaming replication? On other standbys, having no WAL delay, we did not see this problem yet. Wh

Re: [BUGS] BUG #6661: out-of-order XID insertion in KnownAssignedXids

2012-06-08 Thread Andres Freund
Hi Valentine, On Friday, June 08, 2012 12:25:25 PM Valentine Gogichashvili wrote: > unfortunately I did not manage to keep the snapshot of the database, that > had this issue. Too bad. Let me try if I can reproduce it manually. > Can that be, that this issue only happens when the recovering from

Re: [BUGS] BUG #6661: out-of-order XID insertion in KnownAssignedXids

2012-06-08 Thread Andres Freund
Hi All, On Friday, June 08, 2012 12:42:00 PM Andres Freund wrote: > On Friday, June 08, 2012 12:25:25 PM Valentine Gogichashvili wrote: > > unfortunately I did not manage to keep the snapshot of the database, that > > had this issue. Ok, after some playing I could reproduce the issue: master: S1:

[BUGS] BUG #6678: error in connecting to Pgadmin

2012-06-08 Thread renjibabu
The following bug has been logged on the website: Bug reference: 6678 Logged by: Renji Email address: renjib...@ymail.com PostgreSQL version: 9.1.0 Operating system: windows 7 Description: Hi, I have installed PostgreSQL 9.1 on windows 7 and I am unable to connect to

[BUGS] error connecting to postgresql by pgadmin

2012-06-08 Thread Renji Babu
Hi, I have installed PostgreSQL 9.1 on windows 7 and I am unable to connect to the database after I restart the machine. When I first installed postgres from pgadmin III, Service started and database also got connected. But when I shutdown and tried to start the service again, it is showing as

[BUGS] BUG #6679: Can't connect via JDBC Driver

2012-06-08 Thread mitzanu
The following bug has been logged on the website: Bug reference: 6679 Logged by: Mihai Email address: mitz...@gmail.com PostgreSQL version: 9.1.4 Operating system: WIn 7 Description: I'm using a database management tool that uses a JDBC driver i think this issue is JD

[BUGS] error in connecting to Postgresql 9.1

2012-06-08 Thread Renji Babu
Hi, I have installed PostgreSQL 9.1 on windows 7 and I am unable to connect to the database after I restart the machine. When I first installed postgres from pgadmin III, Service started and database also got connected. But when I shutdown and tried to start the service again, it is showing as th

Re: [BUGS] BUG #6678: error in connecting to Pgadmin

2012-06-08 Thread Craig Ringer
On 06/08/2012 05:08 PM, renjib...@ymail.com wrote: The following bug has been logged on the website: Bug reference: 6678 Logged by: Renji Email address: renjib...@ymail.com PostgreSQL version: 9.1.0 There's your first problem. Why use such an old release? If you're reportin

Re: [BUGS] BUG #6679: Can't connect via JDBC Driver

2012-06-08 Thread Craig Ringer
On 06/08/2012 06:55 PM, mitz...@gmail.com wrote: The following bug has been logged on the website: Bug reference: 6679 Logged by: Mihai Email address: mitz...@gmail.com PostgreSQL version: 9.1.4 Operating system: WIn 7 Description: I'm using a database management tool that

Re: [BUGS] BUG #6650: CPU system time utilization rising few times a day

2012-06-08 Thread Robert Haas
On Fri, Jun 1, 2012 at 2:17 AM, Andrzej Krawiec wrote: > 2012/5/31 Robert Haas : >> How long was strace -s run for to generate this? > > Strace - s was running for about 2 minutes. Hmm, I'm sort of confused then. This only shows a total of 1.815816 seconds of system time, which is a lot less tha

Re: [BUGS] BUG #6666: pg_upgrade 9.2beta1 plpython/plpython2

2012-06-08 Thread Robert Haas
On Fri, Jun 1, 2012 at 11:48 AM, Bruce Momjian wrote: > Should this be back-patched?  (Problem first reported in PG 9.1 due to > the removal of a backward-compatibility symlink.)  I am not sure we have > had enough problem reports to warrant it (3 reports). We back-patch a lot of things based on

Re: [BUGS] BUG #6674: functon aggregat

2012-06-08 Thread Robert Haas
On Sun, Jun 3, 2012 at 5:56 AM, wrote: > The following bug has been logged on the website: > > Bug reference:      6674 > Logged by:          susan > Email address:      shinsetsu...@yahoo.fr > PostgreSQL version: 9.1.3 > Operating system:   windows vista 64b > Description: > > Hi, > when i use s

Re: [BUGS] BUG #6659: Error when install postgres

2012-06-08 Thread Robert Haas
On Thu, May 31, 2012 at 7:54 PM, 김준호 wrote: > I attached log file. > Please analyze the log files. Are these the EnterpriseDB installers? Sorta looks like it, except I'm pretty sure we don't install in C:\Program Files\SuperSignElite-w Server\PostgreSQL Also, I don't see any errors at all in th

Re: [BUGS] BUG #6670: Translate small SQL from 8.0 ti 7.3

2012-06-08 Thread Robert Haas
On Thu, May 31, 2012 at 3:34 AM, wrote: > The following bug has been logged on the website: > > Bug reference:      6670 > Logged by:          Roman > Email address:      byg...@mail.ua > PostgreSQL version: Unsupported/Unknown > Operating system:   Win32 > Description: > > Bruce, tell me PLEASE

Re: [BUGS] 9.2 beta1 libxml2 can't be loaded on Windows

2012-06-08 Thread Dave Page
On Fri, Jun 1, 2012 at 1:39 AM, Edmund Horner wrote: > On 1 June 2012 12:36, Edmund Horner wrote: >> On 1 June 2012 12:14, Edmund Horner wrote: >>> I tried using an older libxml2.dll.  Replace with the one from >>> ftp://ftp.zlatkovic.com/libxml/oldreleases/libxml2-2.6.9.win32.zip >>> (and copyi

Re: [BUGS] BUG #6661: out-of-order XID insertion in KnownAssignedXids

2012-06-08 Thread Simon Riggs
On 8 June 2012 12:40, Andres Freund wrote: > Hi All, > > On Friday, June 08, 2012 12:42:00 PM Andres Freund wrote: >> On Friday, June 08, 2012 12:25:25 PM Valentine Gogichashvili wrote: >> > unfortunately I did not manage to keep the snapshot of the database, that >> > had this issue. > Ok, after

Re: [BUGS] control character check in JSON type seems broken

2012-06-08 Thread Robert Haas
On Mon, Jun 4, 2012 at 8:48 PM, Tom Lane wrote: >> In addition, error message above seems corrupted in my environment. >> Here we check not-escaped control character, so printing it with %c >> formatting might break log files.  How about using decimal or hex dump >> in such cases? > > And so is th

Re: [BUGS] error connecting to postgresql by pgadmin

2012-06-08 Thread Robert Haas
On Fri, Jun 8, 2012 at 5:06 AM, Renji Babu wrote: > I have installed PostgreSQL 9.1 on windows 7 and I am unable to connect > to the database after I restart the machine. > > When I first installed postgres from pgadmin III, Service started and > database also got connected. > > But when I shutdow