PostgreSQL- OGG 19.1.0.0.220831 libpq.so.5 causes issues to login to PSQL
(Doc ID 2917257.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterInformation 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 |