Starting from TKU September 2020 Database Schema node type and Database Table node type were updated to contain DB Server type. (DRDC1-14748)
e.g. SQL Database Schema type was changed to PostgreSQL Database Schema and SQL Database Table type was replaced with PostgreSQL Database Table.
The current pattern allows to discover and model all databases and tables for PostgreSQL Database Server or EnterpriseDB Postgres Advanced Server instances as Detail nodes.
Configuration Options
There are several configuration options available for this product:
| Option | Default value | Commentary |
|---|---|---|
| ignore_databases | ["postgres", "template0", "template1"] | List of databases to ignore. |
| ignore_schemas | ["pg_catalog", "information_schema"] | List of schemas to ignore. |
| model_schemas_and_tables | true | The pattern only creates schema and table nodes if this is true. Setting this option to true lengthens the runtime but provides a deeper model. |
| adminuser | Empty string | If the pattern cannot find the admin user from the pg_hba.conf file, it uses the value of this string. |
| active_method | true | Only runs commands such as pg_dumpall and psql if this is true. |
Queries Run
The pattern runs the following database queries. When setting up the PostgreSQL credential please ensure it has SELECT access to the relevant databases
| Query | Reason | Permission |
|---|---|---|
| select datname from pg_database | Get database list | select permission on pg_database |
| select schemaname, tablename from pg_tables | Get list of tables | select permission on pg_tables |
| select pg_database_size(db name) | Get database sizes | connect permission on relevant database (see publisher's docs) |
The pattern identifies databases and tables of PostgreSQL Database Server or EnterpriseDB Postgres Advanced Server running on Windows and UNIX platforms.
