[GENERAL] postgres MultiXact 9.3 corruption resolved but advice needed

2016-10-15 Thread Yvonne Murphy
Our application runs against postgres 9.3.9.0-2921310. We recently run into the dreaded ERROR: MultiXactId 82578299 has not been created yet -- apparent wraparound. We've truncated this big table. Will truncating save us from getting this error soon again or does this bug have nothing to do wit

Re: [GENERAL] postgres MultiXact 9.3 corruption resolved but advice needed

2016-10-16 Thread Yvonne Murphy
ped it and then recreated it. It would create a new data directory with a small members directory. Would this give us some breathing space until we hit the corruption again Thanks > On 15 Oct 2016, at 20:51, Eduardo Morras wrote: > > On Sat, 15 Oct 2016 18:40:39 +0000 > Yvonne Mu