Re: 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

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

Hi

Please help me

I am working on a CentOS release 6 server, I am struggling with the environment setup. Please help.

data]# createdb -U postgres db0201
createdb: symbol lookup error: createdb: undefined symbol: PQconnectdbParams

data]# psql -U postgres -l
psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

When I try to locate version 8.4 I don’t get the rpms so I can remove them. The server had some 8.4 installations

lib]# rpm -qa | grep postgresql
postgresql92-contrib-9.2.4-1PGDG.rhel6.x86_64
postgresql84-8.4.17-1PGDG.rhel6.x86_64
postgresql92-libs-9.2.4-1PGDG.rhel6.x86_64
postgresql84-server-8.4.17-1PGDG.rhel6.x86_64
postgresql92-server-9.2.4-1PGDG.rhel6.x86_64
postgresql84-libs-8.4.17-1PGDG.rhel6.x86_64
postgresql92-9.2.4-1PGDG.rhel6.x86_64
lib]#

[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

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.