• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

postgres vacuumdb

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
 
Back
Top