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
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.
Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
Re: 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
Attachment
Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
-----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.
Re: 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
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.
Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
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.