PostgreSQL: PO Box

Setup PostgreSQL Application Integration on Zilla

1. Visit the Zilla application and login using your admin credentials and then click Add Application in the top right.

   

    

2. A window with a search bar appears, type in PostgreSQL in the search bar and hit enter. PostgreSQL app entry will appear at the top of the list, click Add to Applications button to the right.

   

3. Fill in the form with appropriate details and then click Add to Applications.

   

4. You will have the PostgreSQL app added into applications tab and a detailed view of PostgreSQL application appears. Click gear icon in top right corner. Integration configuration pop up will appear.

   

5. Enable the Zilla Universal Sync (ZUS) and fill in the config details.
   All or any of the configurations can be kept blank here and can be provided in the ZINC local configurations. The configurations are

   1. Database Server Host: The host in the database connection string specifies the hostname or IP address of the database server.

   2. Database Server Port: The port in the database connection string specifies the port number on which the database server is listening. The default value is 5432.

   3. Database Name: The database name in the database connection string specifies the name of the database to connect to.

   4. Database Connection Parameters: It the parameters string from the database connection string. e.g. retry=true&service_name=Zilla

   5. Database Query: It is the query to retrieve the data from the database. This should be readonly query.

   6. Database Dialect: The dialect in the database connection string specifies the type of database you are connecting to. The dialect value should be postgresql .

   7. Database Driver: The driver in the database connection string specifies the database driver to be used for the connection. The driver value should be psycopg2 .

   8. Database Connection String: The database connection string is an alternative method to configure the database connection. Instead of specifying individual values like host, port, database, username, password, dialect, and driver, you can provide a single connection string. The format should be: 'dialect+driver://username:password@host:port/database?parameters'. If this value is provided, it will be masked after saving because it contains username and password.

   9. Database User: The username in the database connection string specifies the user account to connect to the database.

   10. Database Password: The password in the database connection string specifies the password for the user account to connect to the database.
       

       

6. Click Next and the sync will begin.

When you have finished with all the steps above, return to Zilla and review the information that was synced.

Having trouble? Try our Troubleshooting articles or contact support@zillasecurity.com.