GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

GoldenGate connection to PostgreSQL throws error

edited Oct 8, 2020 9:58AM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center