mirror of
https://github.com/pgpointcloud/pointcloud.git
synced 2025-12-08 20:36:04 +00:00
26 lines
800 B
Bash
26 lines
800 B
Bash
#!/bin/sh
|
|
|
|
##### Script based on initialization script from postgis-docker #####
|
|
|
|
set -e
|
|
|
|
# Perform all actions as $POSTGRES_USER
|
|
export PGUSER="$POSTGRES_USER"
|
|
|
|
# Create the 'template_postgis' template db
|
|
"${psql[@]}" <<- 'EOSQL'
|
|
CREATE DATABASE template_postgis IS_TEMPLATE true;
|
|
EOSQL
|
|
|
|
# Load PostGIS into both template_database and $POSTGRES_DB
|
|
for DB in template_postgis "$POSTGRES_DB"; do
|
|
echo "Loading PostGIS and POINTCLOUD extensions into $DB"
|
|
"${psql[@]}" --dbname="$DB" <<-'EOSQL'
|
|
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;
|
|
CREATE EXTENSION IF NOT EXISTS pointcloud;
|
|
CREATE EXTENSION IF NOT EXISTS pointcloud_postgis;
|
|
EOSQL
|
|
done |