Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1XxwUY-0006W6-62 for pgsql-admin@arkaria.postgresql.org; Mon, 08 Dec 2014 11:28:38 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XxwUX-000225-LK for pgsql-admin@arkaria.postgresql.org; Mon, 08 Dec 2014 11:28:37 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1XxwUW-000201-DN for pgsql-admin@postgresql.org; Mon, 08 Dec 2014 11:28:36 +0000 Received: from eu1sys200aog122.obsmtp.com ([207.126.144.153]) by magus.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1XxwUR-0004QX-Rc for pgsql-admin@postgresql.org; Mon, 08 Dec 2014 11:28:35 +0000 Received: from mail-wi0-f170.google.com ([209.85.212.170]) (using TLSv1) by eu1sys200aob122.postini.com ([207.126.147.11]) with SMTP ID DSNKVIWLXv2u08VQufUWieDKVYLUGejW3q4P@postini.com; Mon, 08 Dec 2014 11:28:31 UTC Received: by mail-wi0-f170.google.com with SMTP id bs8so6820066wib.1 for ; Mon, 08 Dec 2014 03:28:30 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:from:references:in-reply-to:mime-version :thread-index:date:message-id:subject:to:cc:content-type; bh=ntKXgInj4oAslQsI9lSU0SX2gs7KykQIsOVhjD/+yl0=; b=QqG7kLNZk19LD+35O0qYYcCIE8yuOZxAELB7GJ3YNxl/ILzZYnj+vKiP4DTNOkcwwd zIs+xFZaSJxoBml+z5h2LkeadHXF/RrXFCItt6qvunAtuGjbfynfgjrQTES6nHxszEU4 jqFGAWCcuesIh6Tv4wuHGMjRXR57pf/JVqM7N51OHHsh+qN1hBZQ/+VMyE7cYEF0FTVK +WwuHngSOxYfn7nGyrJ00KUtCHpb/d9ceGt0Z7bVfNg2tGJlMU7aV1N9mbr3e6s9yb3o WpoICLuGonAH96eAB1lW8d4RDmYjCHh46fGPv6QGAxDU5pV5AkSH+wRsQ02w1QRhA9MG oZrg== X-Gm-Message-State: ALoCoQnUjbQDlW17hdReudvrWXSrsKKQH+sIgr+tZFwPuumg/KVPzHEq+rfzhJwWLgla5jk9d1TOJ4mceH/XpqDSsLpOzCmIC/4FY4afrpC/n7XjaAwYX/x+8Szhb27IZFRHZT23YdGaap25pOYig9RHMtB3Z3y4wg== X-Received: by 10.194.110.161 with SMTP id ib1mr46397782wjb.78.1418038110137; Mon, 08 Dec 2014 03:28:30 -0800 (PST) X-Received: by 10.194.110.161 with SMTP id ib1mr46397766wjb.78.1418038109981; Mon, 08 Dec 2014 03:28:29 -0800 (PST) From: Khangelani Gama References: <068af4d4c163f7533e77701e1784066e@mail.gmail.com> <554d2eb2ec9b4086896a2eeee29bb429@pdc-mail-exch05.ubisoft.org> In-Reply-To: <554d2eb2ec9b4086896a2eeee29bb429@pdc-mail-exch05.ubisoft.org> MIME-Version: 1.0 X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQLGbg34zprSdUJw8hKqsB7VaUiiMAJOg/MtmoZjdzA= Date: Mon, 8 Dec 2014 13:28:28 +0200 Message-ID: Subject: Re: Postgres 9.2.4 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams To: Jan Harasym Cc: pgsql-admin@postgresql.org Content-Type: multipart/alternative; boundary=089e0102fc52d2e1160509b2b9f0 X-Pg-Spam-Score: -4.2 (----) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --089e0102fc52d2e1160509b2b9f0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable *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 =E2=80=93e $(rpm =E2=80=93qa | grep post| grep 8.4)` or something.. yo= u=E2=80=99re passing it a package name of 'rpm -qa | grep post | grep 8.4' which doesn=E2=80=99t ex= ist. 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.c= om 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 addre= ssee only, and may contain the confidential information of Argility (Proprietary) Limited and/or its subsidiaries. An= y review, use or dissemination thereof by anyone other than the intended addressee is prohibited.If you are not the intend= ed addressee please notify the writer immediately and destroy the e-mail. Argility (Proprietary) Limited and its subsidiari= es distance themselves from and accept no liability for unauthorised use of their e-mail facilities or e-mails sent other tha= n strictly for business purposes. =0D --089e0102fc52d2e1160509b2b9f0 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable

=C2=A0

From: pgsql-admin-owner@postgresql.org [mailto= :pgsql-admin-owner@post= gresql.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: undefine= d symbol: PQconnectdbParams

= =C2=A0

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

<= p class=3D"MsoNormal">>err= or: package rpm -qa | grep post | grep 8.4 is not installed

<= p class=3D"MsoNormal">=C2=A0<= /span>

I assume you were going for:

`rpm =E2=80=93e $(rpm =E2=80=93qa | gr= ep post| grep 8.4)` or something.. you=E2=80=99= re passing it a package name of 'rpm -qa | grep post | grep 8.4&= #39; which doesn=E2=80=99t exist.

=C2=A0

As for the symbol lookup error it appears there is a conf= lict between the versions RHEL provides (or older versions) and the version= you want to install.

=C2=A0

I recommend removing all versions and installing the version you actu= ally want.

=C2= =A0

http://www.postgresql.o= rg/message-id/1325077438786-5105203.post@n5.nabble.com

http://www.postgresql.org/message-id/362= 6.1325097266@sss.pgh.pa.us

=C2=A0

= =C2=A0

=C2=A0

=C2=A0

= =C2=A0

I did= the following which removed everything for version 8.4 and it worked. Than= ks very much for all the help

=C2=A0

rpm -e `rpm -qa | grep postgres | grep 8.4`

=C2=A0

=C2=A0

=C2=A0

=C2=A0<= /p>

=C2= =A0

=C2=A0

 =

=C2=A0

CONFIDENTIALITY NOTICE
The contents of and attachments to this e-mail are intended for the addre=
ssee only, and may contain the confidential
information of Argility (Proprietary) Limited and/or its subsidiaries. An=
y review, use or dissemination thereof by anyone
other than the intended addressee is prohibited.If you are not the intend=
ed addressee please notify the writer immediately
and destroy the e-mail. Argility (Proprietary) Limited and its subsidiari=
es distance themselves from and accept no liability
for unauthorised use of their e-mail facilities or e-mails sent other tha=
n strictly for business purposes.
=0D
--089e0102fc52d2e1160509b2b9f0--