CentOS

I suspect the issue is that you've added that directory to your PATH or to some LD_LIBRARY* variable so that it's being searched automatically and ahead of the /lib64. Yes, removing the whole package is likely to fix it but that's quite a big hammer.

Now it's working fine after uninstalling Postgre Enterprise version

Thanks,
Hemanth BITRA.

Is there is any way to prevent this issue before installing Postgres enterprise version.

Yes. Don't add the /opt/postgresql directories to your PATH or any LD_LIBRARY* environment variables.

TrevorH wrote:Yes. Don't add the /opt/postgresql directories to your PATH or any LD_LIBRARY* environment variables.

I didn't add path to environment variable but postgres enterprise application itself creating some profile like profile_sql.sh
while installing in /opt

Then it's broken and you should report it to the people that created it.

TrevorH wrote:Then it's broken and you should report it to the people that created it.

Hello TrevorH.

This issue is resolved after uninstalling postgres enterprise application.

Regards,
Hemanth.