Postgres 8 - Database access, new install.

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.