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

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.

>
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com