Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams - Mailing list pgsql-admin

From Jan Harasym
Subject Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
Date
Msg-id 554d2eb2ec9b4086896a2eeee29bb429@pdc-mail-exch05.ubisoft.org
Whole thread Raw
In response to Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams  (Khangelani Gama <kgama@argility.com>)
Responses Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
List pgsql-admin

>[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@n5.nabble.com

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

 

 

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

pgsql-admin by date:

Previous
From: Harshad Adalkonda
Date:
Subject: Re: How to enable SSL on client
Next
From: Jan Harasym
Date:
Subject: Re: Problem pg_upgradecluster from 9.1 to 9.3