Export Data to PostgreSQL

Export your Mondoo security data to PostgreSQL so you can query it with SQL, build custom reports, or feed an application that already runs on Postgres. For how exports work in general, read Continuous Data Exports.

Requirements

• A PostgreSQL database accessible from the internet on port 5432. The database cannot be behind a firewall or use a non-standard port. See the PostgreSQL documentation for setup.
• Editor or Owner access to the Mondoo space.

Create the integration

1. In the Mondoo App, navigate to the space. In the side navigation, select Integrations. Under Exports, select PostgreSQL.

   

2. Enter a name for the integration.

3. Fill in:

   • Database server host. The IP address or FQDN of your PostgreSQL server.
   • Credentials. Your PostgreSQL user name and password.

4. Select CREATE EXPORT.

Mondoo starts the initial export. When it completes, the integration's status becomes active and subsequent exports run automatically every ~24 hours.

Manage this integration

After it's created, find your integration under Integrations in your space's side navigation. Select it to open the detail page, where you can:

• Trigger a manual export. Exports run automatically about every 24 hours. To export immediately, select SCHEDULE NOW.
• Check the status. active means the integration is healthy and exporting on schedule. pending means Mondoo hasn't attempted the first export yet. error means the last export failed.
• Remove the integration. Select the trash can icon and confirm. Mondoo stops future exports but does not delete data that has already been exported.

Next steps

• Export data to other destinations