FROM mdillon/postgis

COPY ./nga_bth.sql /docker-entrypoint-initdb.d/
COPY ./nga_preg.sql /docker-entrypoint-initdb.d/
COPY ./nga_adm1.sql /docker-entrypoint-initdb.d/

EXPOSE 5432

docker build -t dillon .

docker run -d -p 4000:5432 --name postgis_test -e POSTGRES_DB=gis -e POSTGRES_USER=postgres -it -e POSTGRES_PASSWORD=postgres dillon:latest

server started
CREATE DATABASE

ALTER ROLE


/usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/nga_adm1.sql
SET
SET
BEGIN
CREATE TABLE
ALTER TABLE
2017-11-29 19:07:35.043 UTC [73] ERROR:  function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist at character 8
2017-11-29 19:07:35.043 UTC [73] HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2017-11-29 19:07:35.043 UTC [73] STATEMENT:  SELECT AddGeometryColumn('public','nga_adm1','geom','4326','MULTIPOLYGON',2);
psql:/docker-entrypoint-initdb.d/nga_adm1.sql:18: ERROR:  function addgeometrycolumn(unknown, unknown, unknown, unknown, unknown, integer) does not exist
LINE 1: SELECT AddGeometryColumn('public','nga_adm1','geom','4326','...
               ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.

server started
CREATE DATABASE

ALTER ROLE


/usr/local/bin/docker-entrypoint.sh: running /docker-entrypoint-initdb.d/nga_bth.sql
BEGIN
psql:/docker-entrypoint-initdb.d/nga_bth.sql:2: NOTICE:  table "nga_bth" does not exist, skipping
DROP TABLE
2017-11-29 19:03:39.043 UTC [73] ERROR:  type "raster" does not exist at character 66
2017-11-29 19:03:39.043 UTC [73] STATEMENT:  CREATE TABLE "public"."nga_bth" ("rid" serial PRIMARY KEY,"rast" raster,"filename" text);
psql:/docker-entrypoint-initdb.d/nga_bth.sql:3: ERROR:  type "raster" does not exist
LINE 1: ...ublic"."nga_bth" ("rid" serial PRIMARY KEY,"rast" raster,"fi…