Red Hat Bugzilla – Bug 51994
psql wont start. Error is psql: undefined symbol: PQgetssl
Last modified: 2009-08-24 17:49:44 EDT
From Bugzilla Helper:
User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Description of problem:
psql crashes with "psql: undefined symbol: PQgetssl" when I try to invoke
psql in interactive mode. the "psql -e template1 < /tmp/filename" command
runs to completion though.
Also, the rh-pgdump.sh doesn't find the binaries from the pervious
version. The /usr/lib/opgsql/backup directory referenced in the script
doesn't exist after 7.1 -> roswell upgrade.
The error occurs even with a fresh install, ie, not restoring the old
database. I can create databases as user postgres, but once I try to
connect, I get the library error
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Install old postgresql and start to do a pg_dumpall
2. run pg_dumpall > /tmp/filename
3. Mv /var/lib/pgsql/data to data.bak
4. Install new postgresql and start
5. run the psql -e template1 < /tmp/filename
6. Attempt to connect to database created from the dump.
7. Cannot connect to any database.
rpm -q postgresql - this doesn't happen in standard use for me, and seems to
indicate there is a mismatch of ssl-support in database and client.
What provides the ssl-support?
We (Red Hat) should really try to fix this before next release.
The ssl support should be built into the database and client. Note that
rh-pgdump.sh script is intended for upgraded from Red Hat Linux 6.x only - use
"pg_dumpall" for newer releases.
Did that - it works just fine here, with postgresql-7.1.3-1. This shouldn't be
different in older releases, though, unless you have a mismatch between client
I did use the pg_dumpall to dump the database. I then used the psql -e
template1 < dumpfile command to restore the database. This operation actually
worked. It's afterwards, when I attempt to connect to the database is when I
get this error. Prior to the upgrade, when I was running 7.1, I had edited the
postgres conf file, I believe pg_hba.conf to allow remote clients to connect to
the server(via the secure one, I forget which option that was, and the box is
Perhaps this is where the error is.
I did upgrade in the way you described when I closed it, and had tested it
afterwards (the database was minimal, though - one table, six records). No
Still having problems.. rpm -qa | grep postgresql shows all the postgresql
packages at version 7.1.2-6
I cleaned out the /var/lib/pgsql dir, and did an initdb as postgres. I
restarted the database. Then, as user postgres, did a `createdb test`, followed
by `psql test` and got the same error again.
This box was upgraded from 7.1.
I have a openssl-0.9.6b-3 providing /lib/libssl.so.0.9.6b(version 1)
I also have a openssl096-0.9.6-5 providing /usr/lib/libssl.so.0.9.6(version 2)
Could this be the problem?
xemacs-21.5.28-10.fc10 has been submitted as an update for Fedora 10.