Setting Up the Database

JetPatch Agent Manager requires you to configure an external third-party PostgreSQL database.

To set up a PostgreSQL database:

1. Set up the third-party PostgreSQL database, version 9.4 or above. For example:
   • PostgreSQL on RHEL
   • PostgreSQL on Ubuntu

   For optimal security, you can implement SSL and Active Directory authentication over SSL.

2. RAM requirements: 16 GB
3. Stop the tomcat service by running:

   /etc/init.d/tomcat_watchdog stop

   /etc/init.d/tomcat stop

4. In an auto-failover high availability environment, stop the NGINX service that performs failover between the two JetPatch servers.
5. On the JetPatch server:
   1. Open the following file:

      /usr/share/tomcat/default/conf/intigua.properties

      _{* Please note that after changing the values in the intigua.properties file, a sever restart is required. You may contact JetPatch to learn more about these changes.}

   2. Make note of the values of the following keys:
      • db.url
      • db.username
      • db.password
   3. Replace the above three keys' values with the correct values for the new database.
6. In an auto-failover high-availability environment, start NGINX.
7. Start the tomcat service by running:

   /etc/init.d/tomcat_watchdog start

   /etc/init.d/tomcat start