This document describes how to remotely connect to the embedded Postgres instance.
You need to connect to a database from your embedded Postgres instance from a remote client tool.
By default, Postgres is configured in Cisco Information Server (CIS) to only allow incoming client connections that are local to its host. In order to allow incoming connections from outside hosts, you need to alter this file: /repository/data/pg_hba.conf
Inside, there is a detailed annotation that describes the connectivity restrictions. Add a new line under this section in the pg_hba.conf file:
# TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 password
Your new line contains the IP address or hostname from where you want to allow the remote incoming connection. It also specifies the database, user, and method.
The new line allows connections to Postgres from a remote Microsoft Windows host 172.23.6.88, to connect to any database, as any named Postgres userid which requires password authentication.
host all all 172.23.6.88/32 password
Once this is complete, Postgres needs to be restarted for this to take effect.