Hi, I am running Postgresql 9.1 and I can see the datfrozenxid is going high and vacuum process is not bringing it down. And this has been happening on template1 database.
2016-02-12 16:51:50.400 CST [19445][@] : [13-1] WARNING: oldest xmin is > far in the past > 2016-02-12 16:51:50.400 CST [19445][@] : [14-1] HINT: Close open > transactions soon to avoid wraparound problems. > 2016-02-12 16:51:50.400 CST [19445][@] : [15-1] LOG: automatic vacuum of > table "template1.pg_catalog.pg_database": index scans: 0 > pages: 0 removed, 1 remain > tuples: 0 removed, 9 remain > system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec > 2016-02-12 16:51:50.411 CST [19435][@] : [82-1] WARNING: oldest xmin is > far in the past > 2016-02-12 16:51:50.411 CST [19435][@] : [83-1] HINT: Close open > transactions soon to avoid wraparound problems. > 2016-02-12 16:51:50.411 CST [19435][@] : [84-1] LOG: automatic vacuum of > table "template1.pg_catalog.pg_largeobject": index scans: 0 > pages: 0 removed, 0 remain > tuples: 0 removed, 0 remain > system usage: CPU 0.00s/0.00u sec elapsed 0.00 sec I vacuum database manually but nothing is working out. Please help, Thanks.
