How to Reinstall postgresql96 for Data Migration; Was: Time to delete old PostgreSQL from MacPorts?

[Steven Smith]

I just discovered that I’ve been impacted by this recent update to the port postgresql96—my fault entirely as there’s been plenty of warning on MacPorts threads.

I have PG96 data files, but see that I’ve auto-uninstalled PG96, and also PG96 no longer builds.

I’d like to migrate to the latest PG17, but without a running PG96 pg_ctl, I’d have to install this binary from upstream, or preferably from a prebuilt MacPorts tarball.

If possible, it would be much simpler to install from an existing prebuilt tarball, if that’s even possible.

Does anyone know how to patch postgresql96 so that it builds on macOS 14, or how to install a prebuilt port from a MacPorts download?

Thanks,

Steve


The known_fail error is in xml.c:

> :info:build xml.c:977:45: error: incompatible function pointer types passing 'void (void *, xmlErrorPtr)' (aka 'void (void *, struct _xmlError *)') to parameter of type 'xmlStructuredErrorFunc' (aka 'void (*)(void *, const struct _xmlError *)') [-Wincompatible-function-pointer-types]
 



> On Jul 12, 2024, at 4:54 PM, David Gilman <davidgilman1 at gmail.com> wrote:
> 
> Is there any opposition to dropping all unsupported PostgreSQL
> versions from MacPorts? That would be any version of PostgreSQL before
> 12. Version 12 runs out of support later this year.
> 
> Right now none of the unsupported versions will build in MacPorts
> without backporting patches[0]. I don't think it's impossible to get
> them building again, the PostgreSQL codebase moves slowly and patches
> can probably be made to apply, I just don't think the effort is
> justified if there aren't any users on these old versions.
> 
> Note that psql and the client library (libpq) are backwards compatible
> going back many versions. You can use newer versions of psql with
> older databases. These ports are only useful if you need to run a
> specific version of the PostgreSQL server itself.
> 
> [0] at least https://github.com/postgres/postgres/commit/400928b83bd254d20f0790d467f221bb52707e6e
> but I'm sure there are more gotchas as you go further back.
> 
> -- 
> David Gilman
> :DG<

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macports.org/pipermail/macports-dev/attachments/20241123/91f2c70e/attachment-0001.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 4421 bytes
Desc: not available
URL: <http://lists.macports.org/pipermail/macports-dev/attachments/20241123/91f2c70e/attachment-0001.bin>