PostgreSQL Integration

Guide for Resmo PostgreSQL integration

Resmo seamlessly integrates with PostgreSQL to ensure the utmost safety and compliance of your PostgreSQL environment.

What does Resmo offer to PostgreSQL users?

• Collect your directory assets like users, schemas, and tables from your PostgreSQL database.

• Ability to query your PostgreSQL users, schemas, tables, and much more.

• Set up custom rules and run custom SQL queries to improve asset visibility.

How does the integration work?

Resmo PostgreSQL Integration collects resources by using our database agent. After you create, integrate, and set the configurations as specified in the How to Install section, the database agent starts to operate. Once triggered, it sends requests to our servers, pulling resources inside the database.

Then, we process them on the server. You can use the database agent as a binary or docker image, depending on the installation path you choose. Resmo performs the resource validation with a unique IngestKey. Note: An IngestKey is different for each integration.

Available resources:

PostgreSQLResource Directory

Integration Walkthrough

How to install

1. Login to your Resmo account and navigate to the Integrations page. Then, find and click PostgreSQL.

2. Click the Add Integration button from the bottom right corner of the opening modal.

3. Copy and paste your PostgreSQL ingest key (Ingest Key is used as a secret for authentication).

4. Hit the Create button.

5. Go to Resmo-Database-Agent.

6. Click on "tags".

7. If you want to binary version, click on the desired OS version of the Resmo Database Agent.

8. After downloading you can run the database agent via providing the config values.

9. Config list:

   • IngestKey: Ingest key of your integration. (Required)

   • DSN: Database connection URL (Required). We expect the URL to follow a specific format starting with "postgresql://...".

   • Schedule: Schedule for running queries(Optional)

   • Timeout: Timeout duration for database connections, ingesting etc. (Optional, 10 seconds default)

   • DbIdentifier: Database identifier for related Resmo resources.

10. You can run database runner for the binary version with commands:

    • `./resmo-database-agent -ingestKey="d1f947fa-f585-11ed-b67e-0242ac120002" -dsn="postgresql://resmo:resmo@localhost:5432" -schedule="10m" -timeout="10s" -dbIdentifier="postgres-prod"` or:

    • `INGEST_KEY="d1f947fa-f585-11ed-b67e-0242ac120002" DSN="postgresql://resmo:resmo@localhost:5432" ./resmo-database-agent`

11. Or you can use the docker version via command:

    • `docker pull ghcr.io/resmoio/resmo-database-agent:latest`

    • `docker run ghcr.io/resmoio/resmo-database-agent -ingestKey="d1f947fa-f585-11ed-b67e-0242ac120002" -dsn="postgresql://resmo:resmo@localhost:5432" -schedule="10m" -timeout="10s" -dbIdentifier="postgres-prod"` or:

      • `docker run -e DSN="postgresql://resmo:resmo@localhost:5432" -e RESMO_INGEST_KEY="d1f947fa-f585-11ed-b67e-0242ac120002" /resmo-database-agent`

12. You are ready! Now you can start querying your PostgreSQL database resources!

How to uninstall

1. Go to your Integrations page on Resmo and click on PostgreSQL.

2. Navigate to the Connected Integrations tab on the opening modal.

3. Select the PostgreSQL account you want to remove or disable. Click the Disable/Delete button from the top right of the modal.

Note that account removal cannot be undone; you would need to integrate again. Instead, you can choose to disable an integration until you enable it back.