Re: reindexdb hangs - Mailing list pgsql-admin

From Tom Lane
Subject Re: reindexdb hangs
Date
Msg-id 1367.1189470012@sss.pgh.pa.us
Whole thread Raw
In response to Re: reindexdb hangs  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: reindexdb hangs  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-admin
Alvaro Herrera <alvherre@commandprompt.com> writes:
> I am unsure if I should backpatch to 8.1: the code in cluster.c has
> changed, and while it is relatively easy to modify the patch, this is a
> rare bug and nobody has reported it in CLUSTER (not many people clusters
> temp tables, it seems).  Should I patch only REINDEX?  How far back?

I'd say go as far back as you can conveniently modify the patch for.
This is a potential data-loss bug (even if only for temporary data)
so we ought to take it seriously.

            regards, tom lane

pgsql-admin by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: reindexdb hangs
Next
From: Tom Lane
Date:
Subject: Re: Close open transactions soon to avoid wraparound problems