Re: postgresql-10.3 on unbuntu-17.10 - how??

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 :-)