[oi-dev] Moving on with postgresql

[Till Wegmueller]

Hi Gary

LGTM.
Thanks for the initiative.

-Till

On 19.04.21 12:34, Gary Mills wrote:
> On Sat, Apr 17, 2021 at 04:46:06PM -0500, Gary Mills wrote:
>> OI currently has postgresql versions: 95 96 10 11 12 .  The OI
>> default, in shared-macros.mk, is 95 .  However, the postgresql
>> developers report that 95 is unsupported, but 13 is available and
>> supported.  Something has to change in OI to move forward with
>> postgresql.
> 
> Thanks to all who responded to my original message.  Most people
> wanted to use modern versions of postgres, including 13, which is not
> packaged on OI.  Nobody wanted to use 95, which is an unsupported
> version.  Unfortunately, 95 is still needed by many OI packages,
> and cannot immediately be obsoleted.
> 
> Given these wishes and constraints, here is my proposal for postgres
> packages in OI.  I will change the default to 10 or 11, and upgrade 95
> and 96 to new minor versions, and to python-3.  After all, removing
> python-2 is the whole reason for the current round of package
> upgrades.
> 
> The result of this proposal is that package
> database/postgres-95/library still exists, and that OI packages that
> require these libraries will still work.  Because the postgres default
> has changed, some packages may no longer build.  A short term fix for
> these is to add this statement to Makefile:
> 
>      PG_VERSION=	9.5
> 
> The proposal above is only the first step, but will get OI past the
> python version update.  The next step for postgres will be to obsolete
> 95 and 96, and to add 13.  People upgrading postgres will need to dump
> tables from the old version and load them in the new version, as
> suggested in the postgres manuals.
> 
>