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.

Table 1. 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