BEGIN;

CREATE EXTENSION IF NOT EXISTS postgis;
UPDATE pg_database SET datistemplate = true WHERE datname = 'template_postgis';

COMMIT;