WSL/SLF GitLab Repository

30_add_postgis.sh 409 Bytes
Newer Older
Sam's avatar
Sam committed
1
2
3
#!/bin/bash
set -e

4
psql -v ON_ERROR_STOP=1 --username postgres --dbname postgres <<-EOSQL
Sam's avatar
Sam committed
5
6
7
8
    CREATE EXTENSION IF NOT EXISTS postgis;
    CREATE EXTENSION IF NOT EXISTS postgis_topology;
    CREATE EXTENSION IF NOT EXISTS fuzzystrmatch;
    CREATE EXTENSION IF NOT EXISTS postgis_tiger_geocoder;
9
10
    ALTER VIEW geometry_columns OWNER TO "$DB_USER";
    ALTER TABLE spatial_ref_sys OWNER TO "$DB_USER";
Sam's avatar
Sam committed
11
EOSQL