Re: BUG #14598: Duplicate values found when reindexing unique index

On 3/27/2017 10:20 AM, hubert depesz lubaczewski wrote:
> On Mon, Mar 27, 2017 at 10:15:38PM +0530, Manoj Verma wrote:
>> Dear depesz,
>>
>> I am currently on Rhel 5.8.
>>
>> On which minor version should I upgrade/update, which include major bug
>> fixes like duplicate value issue.
> If you want, for whatever reason, to stay to 8.2, then upgrade to newest
> 8.2 (no idea what it is - it's so ancient that I don't even have it).
>
> Otherwise - upgrade to 9.6.2.

per https://www.postgresql.org/docs/current/static/release.html the
final release of 8.2 was 8.2.23, in December 2011

but, the OP was asking about 8.1, of which the final release was 8.1.23,
in 2010.

However, running out of disk space in the disk volume holding pgdata is
a catastrophic error, that can leave the database in an unknown state,
depending on exactly what was allocating file space when it ran out.

--
john r pierce, recycling bits in santa cruz