The Postgres Database/Table monitoring point makes an ODBC connection to the Postgres Database and checks if the Table is accessible and contains information.
The parameters that are unique to the Postgres Database/Table include:
|
Server Name |
DNS name of server where the Postgres database is located |
|
Database |
Database name to check |
|
Tbl Name w/Owner |
Table name to check, including table owner Example: GIS.Roads |
|
userID |
User ID with access to the Postgres Table. If using Windows AD authentication, enter Domain\UserID Note: userID should be entered as encrypted information |
|
userPW |
User PW for access to the PostgresTable Note: userPW should be entered as encrypted information |
Next, configure the GeoMonCharts UI web.config file with the database information added for this monitoring porting, following the instructions in Editing the Geomonitor UI Web Config for Microsoft Usage Database.