1. Microservices Architecture Documentation
  2. Performance
  3. Monitor
  4. Monitor Lag
  5. Monitor Lag Using Automatic Heartbeat Tables
  6. Update Heartbeat Tables
  7. Configure Automation Task to Update Heartbeat Table for PostgreSQL

Configure Automation Task to Update Heartbeat Table for PostgreSQL

The Oracle GoldenGate 23ai for PostgreSQL web interface provides the functionality to create a cron job for periodically updating the heartbeat table.

Following are the steps to create this task from the web interface:

  1. Log in to the Administration Service using the Administrator credentials.

  2. From the left-navigation pane, expand Tasks and select the Update Heartbeat Tasks option.


    Automation Task option to update heartbeat for PostgreSQL

  3. Click the plus sign on the Update Heartbeat Tasks page. The Create a New Heartbeat Task dialog box is displayed.
    Create a new Update Heartbeat Task dialog box with options to choose database credential alias, domain, and specify a frequency interval for performing the automatic update of the heartbeat table.

  4. Specify the following values in the dialog box and click Submit:

    • Name: Specify a name for the task.

    • Credential Domain: Select the domain name from the drop down list.

    • Credential Alias: Select the credential alias for the PostgreSQL database instance for which you are creating the update heartbeat task.

    • Frequency Interval: Specify the frequency interval for running the update task. The minimum value is 60 (default) and the maxium value can be set to 7999.

To modify or delete an Update Heartbeat task, you can use the following steps:

  1. From the left-navigation pane of the Administration Service interface, select Tasks.

  2. Click Update Heartbeat Tasks. A list of existing Update Heartbeat Tasks is displayed.

  3. From the Actions column, click the pencil icon. The Edit Update Heartbeat Task dialog box is displayed.

  4. You can change or modify, the credential domain, alias, or the frequency interval and click Submit. The modified Update Heartbeat Task is listed on the Update Heartbeat Tasks page.

  5. To delete a task, click the Delete icon from the Actions column for the task. Click OK to confirm deletion.