Skip to content

update-postgis.sh fails on PostGIS 3.7: postgis_tiger_geocoder is not available #466

Open

Description

@narharim

since 3.7 moved the tiger geocoder out of the postgis tree, update-postgis.sh did not get the same change. It still runs these statements unconditionally

CREATE EXTENSION IF NOT EXISTS fuzzystrmatch;
CREATE EXTENSION IF NOT EXISTS postgis_tiger_geocoder VERSION '$POSTGIS_VERSION';
ALTER EXTENSION postgis_tiger_geocoder UPDATE TO '$POSTGIS_VERSION';

so the script fails on every 3.7 image.

Steps to reproduce

docker run -d --name pgis -e POSTGRES_PASSWORD=pw postgis/postgis:18-3.7.0rc3-alpine
# wait for "PostgreSQL init process complete"
docker exec -u postgres pgis update-postgis.sh

Actual result

Updating PostGIS extensions 'template_postgis' to 3.7.0rc3
NOTICE:  extension "postgis" already exists, skipping
NOTICE:  version "3.7.0rc3" of extension "postgis" is already installed
NOTICE:  extension "postgis_topology" already exists, skipping
CREATE EXTENSION
NOTICE:  version "3.7.0rc3" of extension "postgis_topology" is already installed
ALTER EXTENSION
CREATE EXTENSION
ALTER EXTENSION
CREATE EXTENSION
ERROR:  extension "postgis_tiger_geocoder" is not available
HINT:  The extension must first be installed on the system where PostgreSQL is running.

Expected result

The script updates postgis and postgis_topology and skips the tiger geocoder when the target postgis version no longer provides it, the same way initdb-postgis.sh does.

Activity

  1. ImreSamu commented on Nov 5, 2026

    @ImreSamu
    Member

    Thank you @narharim for the report !
    I have created a qucik fix in #465

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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