Re: Postgresql8.4 install breaks Evolution on Ubuntu 9.10 - Mailing list pgsql-general

From Craig Ringer
Subject Re: Postgresql8.4 install breaks Evolution on Ubuntu 9.10
Date
Msg-id 4B128CDF.1070505@postnewspapers.com.au
Whole thread Raw
In response to Re: Postgresql8.4 install breaks Evolution on Ubuntu 9.10  (Craig Ringer <craig@postnewspapers.com.au>)
Responses Re: Postgresql8.4 install breaks Evolution on Ubuntu 9.10  (Sachin Srivastava <sachin.srivastava@enterprisedb.com>)
List pgsql-general
> So - just use rpath linkage for your added libraries, storing them in a
> private directory. Please.

Argh. It's worse than I hoped.

Libraries the One-Click installer tramples all over include:

   libxml2
   libssl
   libcrypto
   libreadline
   libtermcap
   libuuid

... all of which have the same names and in some cases soversions that
they're likely to have in the OS packages.

As libpq.so.5 is also added to the linker path, if a user has a
distro-packaged version of PostgreSQL which has the same soversion of
libpq then the distro-packaged psql etc is also likely to use the
one-click install's libpq, leading to the potential for all sorts of
exciting breakage if they've been built with different options.

An incomplete list of binaries clearly affected by library conflict
issues such as the libxml one the OP reported is, as checked in my
Ubuntu 9.04 install:

/usr/bin/amstex
/usr/bin/bonobo-browser
/usr/bin/bug-buddy
/usr/bin/compiz.real
/usr/bin/devhelp
/usr/bin/dvd95
/usr/bin/dwell-click-applet
/usr/bin/editor
/usr/bin/ekiga
/usr/bin/eog
/usr/bin/etex
/usr/bin/eview
/usr/bin/evim
/usr/bin/evolution
/usr/bin/evolution-addressbook-export
/usr/bin/ex
/usr/bin/gedit
/usr/bin/gnome-about-me
/usr/bin/gnome-appearance-properties
/usr/bin/gnome-default-applications-properties
/usr/bin/gnome-desktop-item-edit
/usr/bin/gnome-help
/usr/bin/gnome-keyboard-properties
/usr/bin/gnome-open
/usr/bin/gnome-panel
/usr/bin/gnome-phone-manager
/usr/bin/gnome-pilot-make-password
/usr/bin/gnome-text-editor
/usr/bin/gnomevfs-cat
/usr/bin/gnomevfs-copy
/usr/bin/gnomevfs-df
/usr/bin/gnomevfs-info
/usr/bin/gnomevfs-ls
/usr/bin/gnomevfs-mkdir
/usr/bin/gnomevfs-monitor
/usr/bin/gnomevfs-mv
/usr/bin/gnomevfs-rm
/usr/bin/gnome-volume-properties
/usr/bin/gpilot-applet
/usr/bin/gpilotd
/usr/bin/gpilotd-control-applet
/usr/bin/gpilotd-session-wrapper
/usr/bin/gpilot-install-file
/usr/bin/grip
/usr/bin/gthumb
/usr/bin/gview
/usr/bin/gvim
/usr/bin/gvimdiff
/usr/bin/inkscape
/usr/bin/inkview
/usr/bin/jadetex
/usr/bin/latex
/usr/bin/meinproc4
/usr/bin/msgattrib
/usr/bin/msgcat
/usr/bin/msgcmp
/usr/bin/msgcomm
/usr/bin/msgconv
/usr/bin/msgen
/usr/bin/msgexec
/usr/bin/msgfilter
/usr/bin/msgfmt
/usr/bin/msggrep
/usr/bin/msginit
/usr/bin/msgmerge
/usr/bin/msgunfmt
/usr/bin/msguniq
/usr/bin/nautilus
/usr/bin/panel-test-applets
/usr/bin/pdfetex
/usr/bin/pdffonts
/usr/bin/pdfimages
/usr/bin/pdfinfo
/usr/bin/pdfjadetex
/usr/bin/pdflatex
/usr/bin/pdftex
/usr/bin/pdftoabw
/usr/bin/pdftohtml
/usr/bin/pdftoppm
/usr/bin/pdftops
/usr/bin/pdftotext
/usr/bin/php5-cgi
/usr/bin/php-cgi
/usr/bin/pidgin
/usr/bin/pointer-capture-applet
/usr/bin/polkit-gnome-authorization
/usr/bin/recode-sr-latin
/usr/bin/rgview
/usr/bin/rgvim
/usr/bin/rhythmbox
/usr/bin/rview
/usr/bin/rvim
/usr/bin/seahorse
/usr/bin/seahorse-daemon
/usr/bin/test-moniker
/usr/bin/tracker-search-tool
/usr/bin/vi
/usr/bin/view
/usr/bin/vim
/usr/bin/vimdiff
/usr/bin/vim.gnome
/usr/bin/vinagre
/usr/bin/vino-preferences
/usr/bin/virsh
/usr/bin/virt-viewer
/usr/bin/xfce4-keyboard-settings
/usr/bin/xfce4-settings-helper
/usr/bin/xgettext
/usr/bin/xmlcatalog
/usr/bin/xmllint
/usr/bin/yelp

Other distros will experience different breakage. On Ubuntu 9.10, for
example, the standard readline soversion is .5.2 so the libreadline.so.4
bundled in the oc installer won't break users of the distro-packaged
libreadline. Ditto libssl  and libcrypto (oc: .5.2 ; distro: .0.9.8 ).

This needs really urgent attention. Step 1 is probably to rebuild the
installer using libraries where everything has been given custom
soversions; next step is to use rpath linkage to solve the problem properly.

--
Craig Ringe

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Time zone 'GMT+8'
Next
From: Sachin Srivastava
Date:
Subject: Re: Postgresql8.4 install breaks Evolution on Ubuntu 9.10