I have the postgres (9.3) logs showing “database xxx must be vacuumed within 3017422 transactions”. My database age is as shown below datname | age ———–+———— template1 | 1642961202 template0 | 1642946792 postgres | 1692961164 xxx | 2144467989 Note : We know the exact table which has aged, it is an audit log table. WeRead more
Blog
We’re currently using Postgres 9.4.14 hosting Zabbix 2.4 database. For a while now, the following message started to happens: < 2017-11-23 15:15:20.037 -03 >HINT: Close open transactions soon to avoid wraparound problems. < 2017-11-23 15:15:20.048 -03 >WARNING: oldest xmin is far in the past < 2017-11-23 15:15:20.048 -03 >HINT: Close open transactions soon to avoidRead more
Satisfaction guarantee
Best Proxy Packs
-
2,000 Private Proxies
$299.00 / month
-
1,000 Private Proxies
$179.00 / month
Like And Follow Us
