Beginning of Chapter Next Chapter

10.11. Schedule Server Maintenance

The server maintenance utility is designed to perform automated maintenance on xTuple databases running on older versions of PostgreSQL. If you are running a newer version of PostgreSQL (i.e., version 8.2 and newer), you should use PostgreSQL's native auto vacuum functionality instead of the xTuple server maintenance utility.

Note

When the server maintenance utility is run, a VACUUM FULL ANALYZE operation is run on your database, followed by a REINDEX. The user who schedules server maintenance must be a superuser (i.e., have the ability to create system users). For more information on these operations and also to learn more about the native auto vacuum feature found in newer versions of PostgreSQL, visit the PostgreSQL website at http://www.postgresql.com.

To run the server maintenance utility, select the "Schedule Server Maintenance" option. The following screen will appear:

Schedule Server Maintenance

When scheduling server maintenance, you are presented with the following options:

Action

Displays the name of the action to be performed by the Batch Manager. In this case, the name of the action is serverMaintenance.

Response Email

By default, the email address of the logged-in user will be entered here. This address may be edited or changed.

Scheduled

Select one of the following Schedule options:

ASAP

Select to have the job run as soon as possible.

Scheduled

Schedule a date and time to run the job. Specify a date in the first field using a standard date format. Use the arrow buttons in the second field to specify a time of day.

Note

When a job is submitted to the Batch Manager with a scheduled time of ASAP, the Batch Manager sets the scheduled time to the current time. However, a job will not necessarily be run immediately if it is scheduled for the current time. Any pre-existing jobs with scheduled times prior to the current time must be completed first. In other words, ASAP jobs will not necessarily be run immediately. Previously scheduled jobs will be run first.

To the far right of the screen, the following buttons are available:

CANCEL

Closes the screen without performing server maintenance, returning you to the application desktop.

SUBMIT

Select to submit requested action to the Batch Manager for processing.