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

[Jan Harasym <jan.harasym@xxxxxxxxxx>]

>[root@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@xxxxxxxxxxxxx

http://www.postgresql.org/message-id/3626.1325097266@xxxxxxxxxxxxx

 

 

From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Khangelani Gama
Sent: December 04, 2014 3:22 PM
To: pgsql-admin@xxxxxxxxxxxxxx
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@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.