Or you compile it?
That was going to be my next step. But I don't think a simple compile
from source would do because Ubuntu's package manager wouldn't be aware
that Postgresql was now available to satisfy other packages'
dependencies.
So I would need to rebuild the Ubuntu source package. I have done that
on Fedora several times where it has been, in my limited experience,
usually simple and problem free. But I have read that building packages
on Ubuntu is much more arcane so I wasn't looking forward to it.
That is pretty much the case when you build from source, it will live
outside the OS packaging universe. I have built from source on Ubuntu
it is not any more difficult then other distros, just remember to
install build-essential. As far a dependencies basically the only
things that will have a Postgres dependency will be other Postgres
software e.g. psycopg2, etc. That means you will need to build them
from source also, though that is helped along by pg_config which will
find your source install and build the other software to match. It
also means uninstalling the Ubuntu Postgres packages so you don't
cross contaminate.
And I would have expected to need to get a current library or two and
thence a custom load path. That said, it might not have taken as long
as the packaged based efforts. Nothing near as quick as realizing one
can just load the sql though!
