PG BUG #15865 - rollback pg fixes

[joshmoore]

Making this the central card for rolling back all pinned PG versions due to the ALTER TABLE bug.

see: https://forum.image.sc/t/fyi-not-possible-to-create-new-omero-instance-with-latest-postgresql-versions/26929

Rollbacks

• [x] https://github.com/ome/omero-install/pull/211 (reverted)
• [x] https://github.com/ome/docker-example-omero/pull/2 (https://github.com/ome/docker-example-omero/pull/3)
• [x] https://github.com/ome/omero-server-docker/pull/29 (https://github.com/ome/omero-server-docker/pull/30)
• [x] https://github.com/ome/omero-test-infra/commit/ab36e4d34d17d6f6c9d2c86a3773e169361386e6 (https://github.com/ome/omero-test-infra/pull/40)
• [x] https://github.com/ome/docker-example-omero-websockets/pull/2 (reverted)
• [ ] devspaces (likely not necessary)
• [x] https://github.com/ome/prod-playbooks/pull/184/commits/bdf22cd090f5b8058710d57238e4d6d986ae28aa
  • [x] https://github.com/ome/ansible-example-omero-onenode/pull/2/commits/a76824bb2c596b4a3fb6c7888ab84b6370d5d015
  • [x] https://github.com/ome/ansible-example-omero-public-user/pull/1/commits/75d912f1e73904a9897c493b5e92080757cb01a6
  • [x] https://github.com/ome/ansible-example-omero-three-nodes/pull/1/commits/26d9d8b798b52de7c26deeec6ae20daafbe68884
• [x] https://github.com/IDR/deployment/pull/191
• [ ] https://github.com/IDR/deployment/pull/192

Issue updates

• [ ] https://github.com/openmicroscopy/openmicroscopy/issues/6069
• [ ] https://github.com/ome/docker-example-omero/issues/1
• [ ] https://github.com/ome/omero-web-docker/issues/31
• [ ] https://twitter.com/MackeyTech/status/1142233368949477376
• [x] finally https://forum.image.sc/t/fyi-not-possible-to-create-new-omero-instance-with-latest-postgresql-versions/26929

Other required PRs (don't need rollback)

• https://github.com/ome/omero-plugins/pull/12
• https://github.com/ome/minimal-omero-client/pull/42

[joshmoore]

Note this has now appeared on the Debian horizon: https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=932247

[joshmoore]

As mentioned in https://forum.image.sc/t/fyi-not-possible-to-create-new-omero-instance-with-latest-postgresql-versions/26929/8, the storm has passed.