ERROR Postgresqlexecuting SQL; psql returned pid 20656 exit 1: '/usr/bin/psql: /lib64/libpq.so.5: no version information available

Problem:

can’t install on Oracle Linux 8.5
Getting this error

2025-05-16 10:25:13 [ERROR ] [configure] /Stage[main]/Foreman::Database::Postgresql/Postgresql::Server::Db[foreman]/Postgresql::Server::Role[foreman]/Postgresql_psql[CREATE ROLE foreman ENCRYPTED PASSWORD ****]/command: change from [redacted] to [redacted] failed: Error executing SQL; psql returned pid 20656 exit 1: '/usr/bin/psql: /lib64/libpq.so.5: no version information available (required by /usr/bin/psql)
2025-05-16 10:25:13 [ERROR ] [configure] /usr/bin/psql: /lib64/libpq.so.5: no version information available (required by /usr/bin/psql)
2025-05-16 10:25:13 [ERROR ] [configure] /usr/bin/psql: /lib64/libpq.so.5: no version information available (required by /usr/bin/psql)

I can’t seem to resolve.

PLease provide instructions on resolution

/lib64/libpq.so.5 is a symlink to a specific version, current version looks like /usr/lib/libpq.so.5.13
if you look where that comes from on enterprise Linux it’s from the appsteam repo in the libpq package but only on enterprise Linux 9

you’re installing against Oracle Linux 8.5 which isn’t listed as a supported platform, so you’d need a repo aligned to Oracle linux 8.5 that hosted a package that provided that library

There is libpq-13.20-1.el8_10.x86_64.rpm in RedHat 8.5 so I’d expect an Oracle OEL repo to contain it too.

I abandoned the oracle linux server and have successfully installed on a Rocky 9.5 VM.
I’m having issues with remote execution. I can’t seem to get the smart proxy to have the ssh feature. This is on Foreman 3.14.
The features shown are:
Dynflow, Logs, Puppet, Puppet CA, and Script

I’ve tried what I could find online but haven’t been successful so far.

Did you enable the REX feature for your Smart Proxy?

https://docs.theforeman.org/3.14/Installing_Proxy/index-katello.html#enabling-remote-execution_smart-proxy

What I actually should have said, Script is the REX SSH feature :+1:

What exact issues do you have with REX? :slightly_smiling_face: