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

2016-10-16 Thread Yvonne Murphy
Thank you kindly for your reply, I've read that the wraparound has to do with the amount of files in pg_multicast/members. So once the wraparound error happens once will it keep recurring until we upgrade even though we've truncated most of the database, If we exported the db dropped it and

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

2016-10-15 Thread Eduardo Morras
On Sat, 15 Oct 2016 18:40:39 + Yvonne Murphy wrote: > 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 gettin