schemas missing from postgis/postgis:17-3.6-alpine on #8
Description
Upgrading to postgis/postgis:17-3.6-alpine breaks the build as the data load script assumes tiger and tiger_data schemas already exist. Needs further investigation to fix.
3.629 ----------------------------------------
3.630 http://clad-github-builder.rit.uw.edu/geo/tiger/TIGER2020 + dc
3.636 ----------------------------------------
3.636 Creating Postgis extensions
3.636 ----------------------------------------
4.362 CREATE EXTENSION
4.390 CREATE EXTENSION
4.854 CREATE EXTENSION
4.876 CREATE EXTENSION
4.877 ----------------------------------------
4.877 Adding US national data
4.877 ----------------------------------------
4.899 ALTER SYSTEM
4.922 ALTER SYSTEM
4.945 ALTER SYSTEM
4.964 NOTICE: schema "tiger_staging" does not exist, skipping
4.964 DROP SCHEMA
4.984 CREATE SCHEMA
5.006 ERROR: schema "tiger_data" does not exist
5.006 LINE 1: CREATE TABLE tiger_data.state_all(CONSTRAINT pk_state_all PR...
5.006 ^
5.006 2025-12-14 00:28:12.752 UTC [74] ERROR: schema "tiger_data" does not exist at character 14
5.006 2025-12-14 00:28:12.752 UTC [74] STATEMENT: CREATE TABLE tiger_data.state_all(CONSTRAINT pk_state_all PRIMARY KEY (statefp),CONSTRAINT uidx_state_all_stusps UNIQUE (stusps), CONSTRAINT uidx_state_all_gid UNIQUE (gid) ) INHERITS(tiger.state);
------