The Synchronizer database is named datasync. The default user for accessing the Synchronizer database is datasync_user.
Database maintenance activities for the Synchronizer database ensure satisfactory performance for Synchronizer users.
The Synchronizer database is a PostgreSQL database. As with any database, the Synchronizer database requires regular maintenance in order to perform reliably. If you are new to managing a PostgreSQL database, see
Routine Database Maintenance Tasks on the PostgreSQL Documentation Web site for assistance.
The Synchronizer stores Synchronizer system configuration information and pending events when synchronization between the Sync Engine and connectors is interrupted. By default, automatic database maintenance cleans up orphaned and expired records every 2 hours. You can change this interval as needed. For example, you might prefer one-time nightly maintenance.
In Synchronizer Web Admin, click the Sync Engine (default) to display the Engine Configuration page, then click to display the Engine XML Source window.
Add the following tags between the <settings> and </settings> tags:
Replace seconds with the time interval for database maintenance.
For example, you could specify 86400 to perform database maintenance once a day, at midnight.
Clickto save your change, then click to return to the Engine Configuration page.
In a terminal window, restart the Sync Engine to put the new database maintenance setting into effect.