vScope logo
PostgreSQL logo

PostgreSQL

Inventory PostgreSQL clusters, databases, and roles

Details

Connect vScope to PostgreSQL and inventory database clusters, schemas, roles, and replication topology. Get an up-to-date view of your entire PostgreSQL environment, and see it in context with assets from the rest of your infrastructure.

  • Cluster and database inventory

    Document PostgreSQL clusters with version, port, configuration settings, and connection limits. Inventory each database including size, encoding, collation, owner, and last-access data.

  • Backup status and scheduled jobs

    Inventory backups by type, tool, size, and retention time. Track scheduled jobs and set up alerts for failed runs from pg_cron or pgAgent.

  • Roles and connections

    Document all roles and users with their privileges, group memberships, and connection limits. Identify superuser accounts, roles with replication rights, and idle or stale active connections.

Asset Types

  • Database
  • Schema
  • User
  • Backup
  • Job

Example of Bundled Content

  • Core Configuration for PostgreSQL Clusters
  • PostgreSQL Database Documentation
  • PostgreSQL Backup Status
  • Roles with Superuser Privileges
  • Failed PostgreSQL Jobs – 30 days
  • Idle & Stale Connections

Get Visibility.

Recent blog posts

All posts