Re: Regular issues faced on postgres 8.1

On Fri, Jan 21, 2011 at 2:07 AM, Kunwar Anjani Tyagi
<kunwar(dot)tyagi(at)newgen(dot)co(dot)in> wrote:
> Missing chunk number 0 for toast value : This case is generated due to
> corruption of toast table of a particular table.Many times reindexing the
> toast table solves the problem.
> Cannot insert a duplicate key into unique index : On analysing this case we
> found that  duplicate rows  get automatically generated , how-ever the
> "oids " still remains different (In some of the cases, oids also same).  If
> a there is a primary key constarint on a column , then  this condition gets
> violated and start throwing error.
> Missing file in clog directory : While doing operations on some records,
> Error comes that an offset of clog file is missing. After analyzing it is
> found that file itself is missing. To resolve this we need to create blank
> files padded with zero, resulting in data loss.

It sounds to me like you have a bad case of filesystem corruption. I
would start by checking your hardware.

PostgreSQL 8.1 is no longer officially supported, and no further bug
fixes will be released. Both performance and reliability of newer
releases are much improved; however, none of that will help you if you
have bad hardware.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company