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

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

From
Khangelani Gama
Date:

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.

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

Did you mean these to be backticks?

so (for clarity):
rpm -e $(rpm -qa | grep post | grep 8.4)

?
Hi,

On Thu, 2014-12-04 at 16:22 +0200, Khangelani Gama wrote:


> [root@f020100 data]# rpm -e 'rpm -qa | grep post | grep 8.4'
>
> *error: package rpm -qa | grep post | grep 8.4 is not installed*

yum remove postgresql84*

would do the trick. However, then you may need to run

yum reinstall postgresql92-server postgresql92

if the symlinks are lost.

Regards,

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


Attachment
-----Original Message-----
From: Devrim Gündüz [mailto:devrim@gunduz.org]
Sent: 04 December 2014 05:33 PM
To: Khangelani Gama
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Postgres 9.2.4 : psql: symbol lookup error: psql:
undefined symbol: PQconnectdbParams


Hi,

On Thu, 2014-12-04 at 16:22 +0200, Khangelani Gama wrote:


> [root@f020100 data]# rpm -e 'rpm -qa | grep post | grep 8.4'
>
> *error: package rpm -qa | grep post | grep 8.4 is not installed*

yum remove postgresql84*

would do the trick. However, then you may need to run

yum reinstall postgresql92-server postgresql92

if the symlinks are lost.

Regards,

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR





Thanks very much for feedback from everyone, I manage to remove
postgresql84* . I am now struggling with the following


Could not retrieve mirrorlist
http://mirrorlist.centos.org/?release=6&arch=x86_64&repo=os error was
14: PYCURL ERROR 6 - "Couldn't resolve host 'mirrorlist.centos.org'"
Error: Cannot retrieve repository metadata (repomd.xml) for repository:
base. Please verify its path and try again  You could try
using --skip-broken to work around the problem
** Found 2 pre-existing rpmdb problem(s), 'yum check' output follows:
1:cups-libs-1.4.2-50.el6.5.ucs1.i686 is a duplicate with
1:cups-libs-1.4.2-50.el6.5.x86_64
fsckyes-1.0.0-2.noarch is a duplicate with fsckyes-1.0.0-1.noarch


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.



>[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.
 

 

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

 

>[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

 

 

 

 

 

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.