GoldenGate connection to PostgreSQL throws error
GoldenGate and Postgres are on same machine, GoldenGate Installed with PostgreSQL user
GGSCI () 6> dblogin sourcedb post userid postgres
Password:
2020-10-08 06:53:54 WARNING OGG-00552 Database operation failed: Couldn't connect to post. ODBC error: SQLSTATE 08S01 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Socket closed.
ERROR: Database operation failed: Couldn't connect to post. ODBC error: SQLSTATE 08S01 native database error 0. [Oracle][ODBC PostgreSQL Wire Protocol driver]Socket closed.Failed to open data source post for user postgres.
Below is pg_hba.conf file
# TYPE DATABASE USER ADDRESS METHOD
local all all trust
host all all 0.0.0.0/0 trust
host db1 postgres postgres trust