X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5C59A55554 for ; Thu, 24 Feb 2005 15:02:54 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 55569-03 for ; Thu, 24 Feb 2005 15:02:47 +0000 (GMT) Received: from mail21.nhs.uk (mail21.nhs.uk [62.6.139.215]) by svr1.postgresql.org (Postfix) with ESMTP id 05EE255DB1 for ; Thu, 24 Feb 2005 15:02:46 +0000 (GMT) Received: from [10.191.254.3] (helo=relayint1.nhs.uk) by mail21.nhs.uk with esmtp (MTC MTA) id 1D4KVz-0000Sh-Ep for pgsql-sql@postgresql.org; Thu, 24 Feb 2005 15:02:55 +0000 Received: from relay.nhs.uk (194.62.42.144) by relayint1.nhs.uk (Syntegra-I1 7.0.008) id 4212933C002BB9E9 for pgsql-sql@postgresql.org; Thu, 24 Feb 2005 15:02:55 +0000 Received: from smtp.gosh.nhs.uk (195.105.8.13) by relay.nhs.uk (Syntegra-4 7.0.008) id 421DE93900002C27 for pgsql-sql@postgresql.org; Thu, 24 Feb 2005 15:02:55 +0000 Received: from GATEWAYS-MTA by smtp.gosh.nhs.uk with Novell_GroupWise; Thu, 24 Feb 2005 15:02:38 +0000 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.3 Date: Thu, 24 Feb 2005 15:02:35 +0000 From: "Mark Roberts" To: Subject: Postgres 8 - Database access, new install. Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=__Part4063129B.0__=" X-Guinevere: 2.0.16 ; Great Ormond Street X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.787 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_30_40, HTML_MESSAGE, HTML_TEXT_AFTER_BODY, HTML_TEXT_AFTER_HTML X-Spam-Level: X-Archive-Number: 200502/304 X-Sequence-Number: 20414 --=__Part4063129B.0__= Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Hi all, Ive just installed the latest version of Postgres 8 on a RedHat 9 server. The problem im having is than when I try to login to the database i.e. 'psql -U postgres template1' im getting the following message: psql: relocation error: psql: undefined symbol: PQsetErrorVerbosity Upon reading an answer to a previous question this could be cause by a version conflict i.e using old 7.x librarys. So ive checked this, and yes there is another version 7.3 installed which is the default RedHat install. However when checking using 'ldd `which psql` the following libraries are displayed which I believe to be correct: libpq.so.3 => /usr/lib/libpq.so.3 (0x40026000) libpam.so.0 => /lib/libpam.so.0 (0x4003c000) libssl.so.4 => /lib/libssl.so.4 (0x40044000) libcrypto.so.4 => /lib/libcrypto.so.4 (0x40079000) libcom_err.so.2 => /lib/libcom_err.so.2 (0x4016a000) libz.so.1 => /usr/lib/libz.so.1 (0x4016c000) libreadline.so.4 => /usr/lib/libreadline.so.4 (0x4017a000) libtermcap.so.2 => /lib/libtermcap.so.2 (0x401a7000) libcrypt.so.1 => /lib/libcrypt.so.1 (0x401ab000) libresolv.so.2 => /lib/libresolv.so.2 (0x401d8000) libnsl.so.1 => /lib/libnsl.so.1 (0x401ea000) libdl.so.2 => /lib/libdl.so.2 (0x401ff000) libm.so.6 => /lib/tls/libm.so.6 (0x40203000) libc.so.6 => /lib/tls/libc.so.6 (0x42000000) libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x40226000) libgssapi_krb5.so.2 => /usr/kerberos/lib/libgssapi_krb5.so.2 (0x40284000) libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3 (0x40297000) libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3 (0x40299000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000) Anyways im now desperately stuck, I have 2 versions of postgres install (my mistake), and I dont know how to remove them and start a fresh install because: rpm -qa | grep postg (shows current rpms) postgresql-server-8.0.1-1PGDG postgresql-8.0.1-1PGDG Does anyone have any idea of how to resolve this problem, I can connect using PGAdminIII but I really would like to be able to login in properly from Command-line also. Many Thx, Mark. _______________________________________ Disclaimer: Great Ormond Street Hospital for Children NHS Trust SECURITY WARNING RE: PATIENT OR OTHER CONFIDENTIAL DATA. Please note that Internet E-mail is simply not a secure communication medium. We strongly advise that you understand & observe this lack of security when e-mailing us. FREEDOM OF INFORMATION ACT 2000: The information contained in this e-mail may be subject to public disclosure under this Act. Unless the information is legally exempt from disclosure, the confidentiality of this e-mail and your reply cannot be guaranteed. This email and any files transmitted with it are intended solely for the use of the individual to whom they are addressed. If you have received this email in error please notify your email administrator. Any views or opinions are solely those of the author of this email and do not represent those of Great Ormond Street Hospital for Children NHS Trust unless specifically stated. VIRUSES: This email message has been checked for the presence of computer viruses by Sophos antivirus software. However, this does not guarantee that this email is free of viruses, and the recipient should perform their own check. --=__Part4063129B.0__= Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML
Hi all, Ive just installed the latest version of Postgres 8 on a = RedHat 9 server. The problem im having is than when I try to login to the = database i.e. 'psql -U postgres template1' im getting the following = message:
 
psql: relocation error: psql: undefined symbol: PQsetErrorVerbosity
 
Upon reading an answer to a previous question this could be cause by = a version conflict i.e using old 7.x librarys. So ive checked this, and = yes there is another version 7.3 installed which is the default RedHat = install. However when checking using 'ldd `which psql` the following = libraries are displayed which I believe to be correct:
 
        libpq.so.3 =3D> = /usr/lib/libpq.so.3 (0x40026000)
      &nb= sp; libpam.so.0 =3D> /lib/libpam.so.0 (0x4003c000)
   =      libssl.so.4 =3D> /lib/libssl.so.4 (0x40044000)<= BR>        libcrypto.so.4 =3D> = /lib/libcrypto.so.4 (0x40079000)
      &nb= sp; libcom_err.so.2 =3D> /lib/libcom_err.so.2 (0x4016a000)
 &nbs= p;      libz.so.1 =3D> /usr/lib/libz.so.1 = (0x4016c000)
        libreadline.so.4= =3D> /usr/lib/libreadline.so.4 (0x4017a000)
    =     libtermcap.so.2 =3D> /lib/libtermcap.so.2 (0x401a7000= )
        libcrypt.so.1 =3D> = /lib/libcrypt.so.1 (0x401ab000)
      &nbs= p; libresolv.so.2 =3D> /lib/libresolv.so.2 (0x401d8000)
  &= nbsp;     libnsl.so.1 =3D> /lib/libnsl.so.1 = (0x401ea000)
        libdl.so.2 = =3D> /lib/libdl.so.2 (0x401ff000)
      = ;  libm.so.6 =3D> /lib/tls/libm.so.6 (0x40203000)
  &n= bsp;     libc.so.6 =3D> /lib/tls/libc.so.6 = (0x42000000)
        libkrb5.so.3 = =3D> /usr/kerberos/lib/libkrb5.so.3 (0x40226000)
   &n= bsp;    libgssapi_krb5.so.2 =3D> /usr/kerberos/lib/libgss= api_krb5.so.2 (0x40284000)
        = libcom_err.so.3 =3D> /usr/kerberos/lib/libcom_err.so.3 (0x40297000)
&= nbsp;       libk5crypto.so.3 =3D> = /usr/kerberos/lib/libk5crypto.so.3 (0x40299000)
    =     /lib/ld-linux.so.2 =3D> /lib/ld-linux.so.2 (0x4000000= 0)
Anyways im now desperately stuck, I have 2 versions of postgres = install (my mistake), and I dont know how to remove them and start a fresh = install because:
 
rpm -qa | grep postg  (shows current rpms)
postgresql-server-8.0.1-1PGDG
postgresql-8.0.1-1PGDG
 
Does anyone have any idea of how to resolve this problem, I can = connect using PGAdminIII but I really would like to be able to login in = properly from Command-line also.
 
Many Thx, Mark.

_______________________________________
Disclaimer: Great Ormond Street Hospital for Children NHS Trust

SECURITY WARNING RE: PATIENT OR OTHER CONFIDENTIAL DATA. Please note
that Internet E-mail is simply not a secure communication medium.
We strongly advise that you understand & observe this lack of security
when e-mailing us.

FREEDOM OF INFORMATION ACT 2000: The information contained in this e-mail
may be subject to public disclosure under this Act. Unless the information
is legally exempt from disclosure, the confidentiality of this e-mail and
your reply cannot be guaranteed.

This email and any files transmitted with it are intended solely for
the use of the individual to whom they are addressed. If you have
received this email in error please notify your email administrator.

Any views or opinions are solely those of the author of this email
and do not represent those of Great Ormond Street Hospital for
Children NHS Trust unless specifically stated.

VIRUSES: This email message has been checked for the presence of
computer viruses by Sophos antivirus software. However, this does
not guarantee that this email is free of viruses, and the recipient
should perform their own check.
--=__Part4063129B.0__=--