Export Data to PostgreSQL
Set up continuous export of assets, vulnerabilities, and scan results from Mondoo to a PostgreSQL database.
Export your Mondoo security data to a PostgreSQL database so you can query it with SQL, build custom reports, or integrate it with applications that already use PostgreSQL. Once configured, Mondoo automatically exports assets, vulnerabilities, and scan results approximately every 24 hours.
Requirements
-
A PostgreSQL database accessible from the internet on port 5432 (the default PostgreSQL port). The database cannot be behind a firewall or use a non-standard port. To learn about setting up PostgreSQL, read the PostgreSQL documentation.
-
Editor or Owner access to the Mondoo space from which you want to export data.
Add a PostgreSQL integration
-
In the Mondoo Console, navigate to the space from which you want to export data. In the side navigation bar, select Integrations. Under Exports, select PostgreSQL.
-
Enter a name for the integration.
-
In the Database server host box, enter the IP address or FQDN of your PostgreSQL server.
-
Under Enter your credentials, enter your PostgreSQL user name and password.
-
Select CREATE EXPORT.
Mondoo begins exporting data from your space. When the initial export completes, the status becomes active. Exports then run automatically approximately every 24 hours.
Manage your integration
To view your integration, select PostgreSQL under Integrations in the side navigation bar, then select the integration.
Trigger a manual export
Exports run approximately every 24 hours. To export immediately, select the SCHEDULE NOW button on the integration detail page.
Statuses
| Status | Meaning |
|---|---|
| active | The integration is healthy and exporting on schedule. |
| pending | Mondoo has not yet attempted the first export. |
| error | Mondoo encountered an error during the last export. |
Remove the integration
Select the trash can icon and confirm the deletion. Mondoo stops future exports but does not delete data already exported to PostgreSQL.