Installation Guide › Server Installation › Layer 7 Gateway Server › Install the PostgreSQL JDBC Driver

Install the PostgreSQL JDBC Driver

If any tenant OTK/OIDC database are PostgreSQL-driven, use this procedure on all Gateways in the cluster.

Follow these steps:

1. Connect with SSH.
2. Stop the service by running the following command:

   service ssg stop
   

3. Install the JDBC driver by running the following commands:

   cp postgresql-9.3-1100.jdbc41.jar /opt/SecureSpan/Gateway/runtime/lib/ext/.
   chown layer7:layer7 /opt/SecureSpan/Gateway/runtime/lib/ext/postgresql-9.3-1100.jdbc41.jar
   

4. Expose the JDBC driver to the Gateway by modifying system properties. Edit this file:

   /opt/SecureSpan/Gateway/node/default/etc/conf/system.properties
   

5. Add this line:

   com.l7tech.server.jdbcDriver=com.mysql.jdbc.Driver\ncom.l7tech.jdbc.mysql.MySQLDriver\
   ncom.l7tech.jdbc.db2.DB2Driver\ncom.l7tech.jdbc.oracle.OracleDriver\
   ncom.l7tech.jdbc.sqlserver.SQLServerDriver\norg.postgresql.Driver
   

6. Save and exit.
7. Start the service by running the following command:

   service ssg start