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:

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

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