1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

postgres vacuumdb

Discussion in 'Plesk for Linux - 8.x and Older' started by Gorgon@, Jun 23, 2005.

  1. Gorgon@

    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.