PostgresSQL

On this page

PostgreSQL is a Warehouse output connector. Connect to your PostgreSQL database to get all your vulnerability data in one place.

IP Allowlists

You might need to add the Monad IP range of 34.210.32.104/32 to your PostgresSQL allowlist, so Monad can connect to it.

Identify some Configurations of your Postgres Database

There are a number of configuration settings you will need to know about your postgres database.

  1. Host: The hostname of your postgres database.
  2. Port: 5432 by default. You can check your postgresql.conf or ask your administrator if this value has been changed.
  3. User: Your username for accessing the postgres database.
  4. Password: Your password for accessing the postgres database.
  5. Database: Name of the database.

Set up a Postgres output connector in Monad

To set up a Postgres connector, you will need to know the above-mentioned configuration details. Once you have this information, you set up the connector:

  1. Log in to your Monad account, and click Add connector.
  2. Select the Postgres connector.
  3. Optionally, change the default name for the connector. This name serves as a label for the connector in the Monad app, and you can change it later.
  4. Enter the Host, Port, User, Password, and Database name of your postgres database.
  5. In the schema field, enter the schema name under which you want Monad data to be saved to in your postgres database.
  6. (Optional) - select your models to export
  7. Click Connect.

Monad then tests the connection to Postgres, and if successful, begins syncing data from your Monad account into your Postgres warehouse.

This page was last modified: 9 Oct 2023