• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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