Postgres 8 - Database access, new install. - Mailing list pgsql-sql
| From | Mark Roberts |
|---|---|
| Subject | Postgres 8 - Database access, new install. |
| Date | |
| Msg-id | s21dec8e.023@smtp.gosh.nhs.uk Whole thread Raw |
| Responses |
Re: Postgres 8 - Database access, new install.
|
| List | pgsql-sql |
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)
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
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.