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

From: Jesper Krogh <jesper(at)krogh(dot)cc>
To: Selva manickaraja <mavles78(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: PostgreSQL logs filling up file system due to duplicate key error
Date: 2011-05-28 13:49:44
Message-ID: 4DE0FD78.6080001@krogh.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 you when it grows significantly.

--
Jesper

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2011-05-28 19:01:35 Re: [ADMIN] pg_class reltuples/relpages not updated by autovacuum/vacuum
Previous Message Scott Ribe 2011-05-28 13:23:57 Re: PostgreSQL logs filling up file system due to duplicate key error