Re: [ADMIN] PostgreSQL logs filling up file system due to duplicate key error

2011-05-28 Thread Jesper Krogh
On 2011-05-28 15:19, Selva manickaraja wrote: Please advise as to how we can solve this problem. We are worried that this error could happen over the weekend and without our knowledge the db may just show down again. Add in 2TB of space for the logs and instruct your monitoring system to tell yo

Re: [ADMIN] PostgreSQL logs filling up file system due to duplicate key error

2011-05-28 Thread Scott Ribe
On May 28, 2011, at 7:19 AM, Selva manickaraja wrote: > Though we know this is due to an application bug, the db should not be > repeating it non-stop until halting to an end. This is a bug in your application. It puts a connection into an error state, doesn't rollback, and keeps submitting tra

[ADMIN] PostgreSQL logs filling up file system due to duplicate key error

2011-05-28 Thread Selva manickaraja
Dear All, We have put PostgreSQL9.0 with replication as production database for the past 2 months for our Conventional system. After a good 2 months, we are now planning to migrate our Logistics system which is in Informix. During the last 2 months we had an incident occuring twice on the 14th of