Skip to content

PostGis fails on Ubuntu 24 (Jammy) #600

@elsoa-invitech

Description

@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"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions