Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

*From:* pgsql-admin-owner(at)postgresql(dot)org [mailto:
pgsql-admin-owner(at)postgresql(dot)org] *On Behalf Of *Jan Harasym
*Sent:* 04 December 2014 04:35 PM
*To:* Khangelani Gama
*Cc:* pgsql-admin(at)postgresql(dot)org
*Subject:* Re: [ADMIN] Postgres 9.2.4 : psql: symbol lookup error: psql:
undefined symbol: PQconnectdbParams

>[root(at)f020100 data]# rpm -e 'rpm -qa | grep post | grep 8.4'

*>error: package rpm -qa | grep post | grep 8.4 is not installed*

I assume you were going for:

`rpm –e $(rpm –qa | grep post| grep 8.4)` or something.. you’re passing it
a package name of 'rpm -qa | grep post | grep 8.4' which doesn’t exist.

As for the symbol lookup error it appears there is a conflict between the
versions RHEL provides (or older versions) and the version you want to
install.

I recommend removing all versions and installing the version you actually
want.

http://www.postgresql.org/message-id/1325077438786-5105203.post@n5.nabble.com

http://www.postgresql.org/message-id/3626.1325097266@sss.pgh.pa.us

I did the following which removed everything for version 8.4 and it worked.
Thanks very much for all the help

rpm -e `rpm -qa | grep postgres | grep 8.4`

CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addressee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. Any review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intended addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiaries distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other than strictly for business purposes.