Facebook
Twitter
G
Gorgon@
Guest
Hi folks,
Any recommendations on the best way to setup a cronjob for the vacuumdb utility for Postgres?
I know virtually nothing about postgres. I setup a cronjob a while back to run the vacuumdb utility which runs nightly as such:
/usr/bin/vacuumdb -a -q -U root
It seems to have been working fine until I got this message last night:
WARNING: Some databases have not been vacuumed in over 2 billion transactions.
You may have already suffered transaction-wraparound data loss.
According to the postgres docs, a regular vacuum should already be taking care of this. So I'm assuming I'm not using the correct options.
Any suggestions are appreciated.
Thanks,
mikeS
Any recommendations on the best way to setup a cronjob for the vacuumdb utility for Postgres?
I know virtually nothing about postgres. I setup a cronjob a while back to run the vacuumdb utility which runs nightly as such:
/usr/bin/vacuumdb -a -q -U root
It seems to have been working fine until I got this message last night:
WARNING: Some databases have not been vacuumed in over 2 billion transactions.
You may have already suffered transaction-wraparound data loss.
According to the postgres docs, a regular vacuum should already be taking care of this. So I'm assuming I'm not using the correct options.
Any suggestions are appreciated.
Thanks,
mikeS
