PostGis fails on Ubuntu 24 (Jammy)

[elsoa-invitech]

We got the following error:

TASK [anxs.postgresql : PostgreSQL | Extensions | Make sure the postgis extensions are installed | Debian] ***********************************************************************************
fatal: [SH1A5965]: FAILED! => changed=false 
  msg: No package matching 'postgresql-16-postgis-3.4' is available

This is true, jammy has different package names:

# apt-cache search postgresql.*postgis-
postgresql-14-postgis-3 - Geographic objects support for PostgreSQL 14
postgresql-14-postgis-3-scripts - Geographic objects support for PostgreSQL 14 -- SQL scripts
postgresql-10-postgis-3 - Geographic objects support for PostgreSQL 10
postgresql-10-postgis-3-dbgsym - debug symbols for postgresql-10-postgis-3
postgresql-10-postgis-3-scripts - Geographic objects support for PostgreSQL 10 -- SQL scripts
postgresql-11-postgis-3 - Geographic objects support for PostgreSQL 11
postgresql-11-postgis-3-dbgsym - debug symbols for postgresql-11-postgis-3
postgresql-11-postgis-3-scripts - Geographic objects support for PostgreSQL 11 -- SQL scripts
postgresql-12-postgis-3 - Geographic objects support for PostgreSQL 12
postgresql-12-postgis-3-dbgsym - debug symbols for postgresql-12-postgis-3
postgresql-12-postgis-3-scripts - Geographic objects support for PostgreSQL 12 -- SQL scripts
postgresql-13-postgis-3 - Geographic objects support for PostgreSQL 13
postgresql-13-postgis-3-dbgsym - debug symbols for postgresql-13-postgis-3
postgresql-13-postgis-3-scripts - Geographic objects support for PostgreSQL 13 -- SQL scripts
postgresql-14-postgis-3-dbgsym - debug symbols for postgresql-14-postgis-3
postgresql-15-postgis-3 - Geographic objects support for PostgreSQL 15
postgresql-15-postgis-3-dbgsym - debug symbols for postgresql-15-postgis-3
postgresql-15-postgis-3-scripts - Geographic objects support for PostgreSQL 15 -- SQL scripts
postgresql-16-postgis-3 - Geographic objects support for PostgreSQL 16
postgresql-16-postgis-3-dbgsym - debug symbols for postgresql-16-postgis-3
postgresql-16-postgis-3-scripts - Geographic objects support for PostgreSQL 16 -- SQL scripts
postgresql-17-postgis-3 - Geographic objects support for PostgreSQL 17
postgresql-17-postgis-3-dbgsym - debug symbols for postgresql-17-postgis-3
postgresql-17-postgis-3-scripts - Geographic objects support for PostgreSQL 17 -- SQL scripts
postgresql-18-postgis-3 - Geographic objects support for PostgreSQL 18
postgresql-18-postgis-3-dbgsym - debug symbols for postgresql-18-postgis-3
postgresql-18-postgis-3-scripts - Geographic objects support for PostgreSQL 18 -- SQL scripts

Possible fix: jammy vars sould own release compatibility map.

postgresql_postgis_release_compatibility:
  10: "3"
  12: "3"
  13: "3"
  14: "3"
  15: "3"
  16: "3"

[github-actions]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!

[otakup0pe]

Would welcome a pull request

[github-actions]

This issue has been marked 'stale' due to lack of recent activity. If there is no further activity, the issue will be closed in another 30 days. Thank you for your contribution!