Forum OpenACS Q&A: error PostgreSQL installation

currently i'm installing postgres 7.4.5
i have done all the instruction on the document provided
but i have a problem on psql command
i have successfully created the database
but i cannot entering the psql command

this was what had appeared:
*****************************************************************

[postgres@localhost postgresql-7.4.5]$ createdb test
CREATE DATABASE
[postgres@localhost postgresql-7.4.5]$ psql test
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

psql: relocation error: psql: undefined symbol: PQgetssl
[postgres@localhost postgresql-7.4.5]$
*****************************************************************

hope u all can help me solving this problem
i'm doing my thesis right now
A.S.A.P
thank you!

hi patrick..

i have entered the cdm "which psql"
then it appears "usr/bin/psql"
i entered the cmd "ldd/usr/bin/psql"
it appears like this..

***************************************************************
[postgres@localhost postgresql-7.4.10]$ which psql
/usr/bin/psql
[postgres@localhost postgresql-7.4.10]$ ldd /usr/local/bin/psql
ldd: /usr/local/bin/psql: No such file or directory
[postgres@localhost postgresql-7.4.10]$ ldd /usr/bin/psql
libpq.so.3 => /usr/local/pgsql/lib/libpq.so.3 (0x40017000)
libpam.so.0 => /lib/libpam.so.0 (0x40040000)
libssl.so.4 => /lib/libssl.so.4 (0x40048000)
libcrypto.so.4 => /lib/libcrypto.so.4 (0x4007d000)
libkrb5.so.3 => /usr/kerberos/lib/libkrb5.so.3 (0x4016e000)
libz.so.1 => /usr/lib/libz.so.1 (0x401cc000)
libreadline.so.4 => /usr/lib/libreadline.so.4 (0x401db000)
libtermcap.so.2 => /lib/libtermcap.so.2 (0x40207000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x4020b000)
libresolv.so.2 => /lib/libresolv.so.2 (0x40238000)
libnsl.so.1 => /lib/libnsl.so.1 (0x4024a000)
libdl.so.2 => /lib/libdl.so.2 (0x4025f000)
libm.so.6 => /lib/tls/libm.so.6 (0x40263000)
libc.so.6 => /lib/tls/libc.so.6 (0x42000000)
libgssapi_krb5.so.2 => /usr/kerberos/lib/libgssapi_krb5.so.2 (0x40285000)
libk5crypto.so.3 => /usr/kerberos/lib/libk5crypto.so.3 (0x40298000)
libcom_err.so.3 => /usr/kerberos/lib/libcom_err.so.3 (0x402a8000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
[postgres@localhost postgresql-7.4.10]$

***************************************************************

how can we know that our psql is not connected to SSL as what u have mentioned?
then how can i install those machines?
A.S.A.P
thank you!

As Torben has pointed out, you have a binary that is looking for libs that aren't available. In short, you have a broken installation of PostgreSQL. Probably from a binary package intended for another OS distribution or OS version. Uninstall it and install the correct one for your OS (making sure dependencies are met, rather than ignored).

Which instructions are you following? One of these or another?

https://openacs.org/doc/current/win2k-installation.html
https://openacs.org/doc/current/install-redhat.html
https://openacs.org/doc/current/postgres.html

And where there are choices, which on(s) did you use?

I suspect you have more than one pg installed, maybe 3, based on the different versions that are shown in your examples: 7.4.5, 7.3.2, 7.4.10. Notice, when you start psql:

[postgres@localhost postgresql-7.4.5]$ psql test
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.

I am still unclear on which one of those instructions you are following.

Regardless, I currently do not use RedHat so can only speculate. If remember correctly, Redhat has installation choices. Some automatically install postgres. Perhaps the VMWare image has an install in it already also?

If you try installing again from the beginning, before installing postgres, check for any existing versions. If you find any, you need to decide on whether you want to keep the currently installed version, or uninstall it so you can cleanly install a new one.