[ADMIN] Oldest xmin is far in the past

Hi, Coming back from vacation, I find a PostgreSQL database cluster (Pg version: 9.0.4) with 5 databases, which for the past 5 days have logged these messages: WARNING: oldest xmin is far in the past HINT: Close open transactions soon to avoid wraparound problems. The cluster has been runn

Re: [ADMIN] Oldest xmin is far in the past

On Sat, Jun 30, 2012 at 3:55 PM, Jerry Sievers wrote: > Christian Rosnes writes: > > > Hi, > > > > Coming back from vacation, I find a PostgreSQL database cluster (Pg > version: 9.0.4) > > with 5 databases, which for the past 5 days have logged these messages: &

Re: [ADMIN] Oldest xmin is far in the past

On Sat, Jun 30, 2012 at 4:32 PM, Jerry Sievers wrote: > Christian Rosnes writes: > > Doing a: > > > > ? psql -U postgres -d postgres -c "select * from? pg_prepared_xacts;" > > > > I see that there are 72 transactions (across the 5 databases in this >