[oi-dev] Moving on with postgresql

[Gary Mills]

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.


-- 
-Gary Mills-		-refurb-		-Winnipeg, Manitoba, Canada-