Secure Agent Services > Process Server > Upgrading the PostgreSQL database using the replication technique
  

Upgrading the PostgreSQL database using the replication technique

If your Process Server PostgreSQL database version is earlier than version 13.5, you can upgrade the database when the Process Server restarts.
The Process Server PostgreSQL database upgrade is disabled by default. To enable replication upgrade of the PostgreSQL database for a Secure Agent, you must add a custom property for the Secure Agent.
To add a custom property for a Secure Agent, perform the following steps:
  1. 1In Administrator, select Runtime Environments.
  2. 2On the Runtime Environments page, click the name of the Secure Agent.
    3. You might have to expand the Secure Agent group to see the list of Secure Agents within the group.
  3. 3Click the Details tab.
  4. 4In the upper right corner, click Edit.
  5. 5Scroll down to the Custom Configuration Details area.
  6. 6The following image shows the Custom Configuration Details area:
    7. When you edit a Secure Agent, the Custom Configuration Details area appears at the bottom of the page. The Custom Configuration Details area contains the following fields: Service, Type, Sub-type, Name, Value, and Sensitive. The Add and Remove icons appear on the right side.
  7. 7If there are custom properties already configured, click the Add icon to add a new property row.
  8. 8Select the service as Process Server.
  9. 9Select a configuration property type as db.
  10. 10Enter the property name as replication_upgrade and value as true.
  11. 11Click Save.
    12. The status of the Process Server service shows up as Restart Required.
When you restart the Process Server for the first time, the database starts replicating the data from your existing database version. Every time you restart the Process Server, the database verifies the replication status. After the replication is complete, the next time you restart the Process Server, the older version of the PostgreSQL database is shut down and the latest version of the database starts automatically.
This eliminates the effort of manually upgrading the Process Server PostgreSQL database to the latest version by running the scripts provided by Informatica.