My Oracle Support Banner

PostgreSQL- OGG 19.1.0.0.220831 libpq.so.5 causes issues to login to PSQL (Doc ID 2917257.1)

Last updated on JULY 18, 2023

Applies to:

Oracle GoldenGate - Version 19.1.0.0.4 and later
Information in this document applies to any platform.

Symptoms

Applied 19.1.0.0.220419 on top of 19.1.x for Oracle Goldengate PostgreSQL
Now it was noticed that some additional listed libraries were added to $GGS_HOME/lib:
-r-xr-xr-x. 1 ggsuser ggsuser 278142 Mar 22 16:03 libpq.a
-r-xr-xr-x. 1 ggsuser ggsuser 377834 Mar 22 16:03 libpq.so
-r-xr-xr-x. 1 ggsuser ggsuser 377834 Mar 22 16:03 libpq.so.5
-r-xr-xr-x. 1 ggsuser ggsuser 377834 Mar 22 16:03 libpq.so.5.14

Now the local psql command is failing with:
psql: <OGG_HOME>/lib/libpq.so.5: no version information available (required by psql)
psql: <OGG_HOME>9/lib/libpq.so.5: no version information available (required by psql)
psql: <OGG_HOME>9/lib/libpq.so.5: no version information available (required by psql)
psql: error: connection to server at "<hostname>" (<Ip Address>), port <port no> failed: FATAL: SSL connection is required. Please specify SSL options and retry.



Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.