pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
6+ messages / 4 participants
[nested] [flat]
* Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
@ 2014-12-04 14:22 Khangelani Gama <kgama@argility.com>
0 siblings, 3 replies; 6+ messages in thread
From: Khangelani Gama @ 2014-12-04 14:22 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
@ 2014-12-04 14:35 Jan Harasym <jan.harasym@massive.se>
parent: Khangelani Gama <kgama@argility.com>
2 siblings, 1 reply; 6+ messages in thread
From: Jan Harasym @ 2014-12-04 14:35 UTC (permalink / raw)
To: Khangelani Gama <kgama@argility.com>; +Cc: 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.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
@ 2014-12-04 14:45 Geoff Winkless <pgsqladmin@geoff.dj>
parent: Khangelani Gama <kgama@argility.com>
2 siblings, 0 replies; 6+ messages in thread
From: Geoff Winkless @ 2014-12-04 14:45 UTC (permalink / raw)
To: Khangelani Gama <kgama@argility.com>; +Cc: pgsql-admin
> [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)
?
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
@ 2014-12-04 15:32 Devrim Gündüz <devrim@gunduz.org>
parent: Khangelani Gama <kgama@argility.com>
2 siblings, 1 reply; 6+ messages in thread
From: Devrim Gündüz @ 2014-12-04 15:32 UTC (permalink / raw)
To: Khangelani Gama <kgama@argility.com>; +Cc: pgsql-admin
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
Attachments:
signature.asc (application/pgp-signature, 818B) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
@ 2014-12-04 18:52 Khangelani Gama <kgama@argility.com>
parent: Devrim Gündüz <devrim@gunduz.org>
0 siblings, 0 replies; 6+ messages in thread
From: Khangelani Gama @ 2014-12-04 18:52 UTC (permalink / raw)
To: Devrim Gündüz <devrim@gunduz.org>; +Cc: pgsql-admin
-----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.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
@ 2014-12-08 11:28 Khangelani Gama <kgama@argility.com>
parent: Jan Harasym <jan.harasym@massive.se>
0 siblings, 0 replies; 6+ messages in thread
From: Khangelani Gama @ 2014-12-08 11:28 UTC (permalink / raw)
To: Jan Harasym <jan.harasym@massive.se>; +Cc: pgsql-admin
*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.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2014-12-08 11:28 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-12-04 14:22 Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams Khangelani Gama <kgama@argility.com>
2014-12-04 14:35 ` Jan Harasym <jan.harasym@massive.se>
2014-12-08 11:28 ` Khangelani Gama <kgama@argility.com>
2014-12-04 14:45 ` Geoff Winkless <pgsqladmin@geoff.dj>
2014-12-04 15:32 ` Devrim Gündüz <devrim@gunduz.org>
2014-12-04 18:52 ` Khangelani Gama <kgama@argility.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox