On 03/21/2018 03:08 PM, Adrian Klaver wrote:
On 03/21/2018 01:59 PM, Stuart McGraw wrote:
On 03/21/2018 02:37 PM, Rob Sargent wrote:
Thanks, I forgot that the older repos also received the pg-10 update.
Unfortunately but no luck with Xenial either, slightly different
but similar conflicts.
My main motivation for updating to 10.3 was to be able to load data
dumped from a 10.3 database. pg_restore complained about "unsupported
version (1.13) in file header". However I just discovered I can load
a plain sql dump from that database so panic mode is over :-) and I
can wait until I can upgrade my machine to ubuntu-18.04.
It still seems to me that the best advice for using Postgresql on
Ubuntu is to use the Ubuntu version of Postgresql if you don't need
the latest version; if you do need latest version, use the Pgdg
version but only with a LTS version of Ubuntu.
If you need the latest version of both Ubuntu and Postgresql, you
may be out of luck.
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.
I wasn't thinking of building Postgresql from the postgresql.org
tarball -- I think that's what you are suggesting? I agree that
in and of itself is not a problem. The problem for me is (or
would have been), as you say, the corequisite rebuilding from
source of other packages. Besides python's psycopg2 I have
critical tools that use libdbd-pg-perl or libpq directly like
the Bacula backup system.
So what I was thinking of was rebuilding the Pgdg Ubuntu source
package (I'm assuming one is available somewhere). I have had
good results on Fedora backporting current versions of Postgresql
from later fedora's to my invariably outdated version of Fedora
by rebuilding the later version's Fedora postgresql source rpm.
This produces an installable binary package that will satisfy
the dependencies of all those other programs eliminating the
need to rebuild them. I was guessing I could do something
similar in the Ubuntu world. But, moot now fortunately :-)
