The PostgreSQL plug-in discovers server resources using a SIGAR query. It searches for a process named postgres or postmaster.

After you configure the username and password for connecting to PostgreSQL, databases, tables, and indexes are auto-discovered.

The table indicates the default conventions the PostgreSQL plug-in uses to name the resources it discovers.

PostgreSQL and vPostgreSQL Resources

Resource Type

Name Format

Example

vPostgreSQL

PostgreSQL

Host:Port

12.555.55.55.Local:5432

vPostgreSQL Database

PostgreSQL Database

Database Database

Database ContractAPAC

vPostgreSQL Table

PostgreSQL Table

Table Database.Schema.Table

Table ContractAPAC.Contract.Customer

vPostgreSQL Index

PostgreSQL Index

Index Database.Schema.Index

Index ContractAPAC.Contract.Customer.CustID