Remotely Connect to the Embedded Postgres Instance
Article ID: KB0080304
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.0 and later |
Description
You need to directly connect to a (meta) database from your embedded Postgres instance from a remote client tool.
Issue/Introduction
This document describes how to remotely connect to Tibco Data Virtualization's (TDV) embedded Postgres instance, also known as the "repository".
Resolution
By default, Postgres is configured in TDV to only allow incoming client connections that are local to its own host.
In order to allow incoming connections from outside hosts, you need to alter this file in the TDV installation: /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.
Example
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.11/32 password
Once this is complete, Postgres needs to be restarted for this to take effect.
In order to allow incoming connections from outside hosts, you need to alter this file in the TDV installation: /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.
Example
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.11/32 password
Once this is complete, Postgres needs to be restarted for this to take effect.
Feedback
Yes
No
Powered by
