Bug 51994 - psql wont start. Error is psql: undefined symbol: PQgetssl
Summary: psql wont start. Error is psql: undefined symbol: PQgetssl
Alias: None
Product: Red Hat Public Beta
Classification: Retired
Component: postgresql
Version: roswell
Hardware: i386
OS: Linux
Target Milestone: ---
Assignee: Trond Eivind Glomsrxd
QA Contact: David Lawrence
Depends On:
TreeView+ depends on / blocked
Reported: 2001-08-17 21:11 UTC by Need Real Name
Modified: 2009-08-24 21:49 UTC (History)
0 users

Clone Of:
Last Closed: 2001-08-20 20:35:49 UTC

Attachments (Terms of Use)

Description Need Real Name 2001-08-17 21:11:34 UTC
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):

How reproducible:

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.

Additional info:

Comment 1 Trond Eivind Glomsrxd 2001-08-17 21:16:19 UTC
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.

Comment 2 Need Real Name 2001-08-18 03:21:36 UTC

What provides the ssl-support?

Comment 3 Glen Foster 2001-08-20 19:22:46 UTC
We (Red Hat) should really try to fix this before next release.

Comment 4 Trond Eivind Glomsrxd 2001-08-20 20:35:44 UTC
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.

Comment 5 Trond Eivind Glomsrxd 2001-08-20 23:20:09 UTC
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
and server.

Comment 6 Need Real Name 2001-08-21 01:17:34 UTC
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 
off now).

Perhaps this is where the error is.

Comment 7 Trond Eivind Glomsrxd 2001-08-21 02:18:28 UTC
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

Comment 8 Need Real Name 2001-08-22 22:10:29 UTC
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?

Comment 9 Fedora Update System 2009-08-24 21:49:44 UTC
xemacs-21.5.28-10.fc10 has been submitted as an update for Fedora 10.

Note You need to log in before you can comment on or make changes to this bug.