enable extensions in entrypoint

draaglom · draaglom · commit 80677e99cc79 · 2017-01-18T01:27:05.000Z
diff --git a/9.2/Dockerfile b/9.2/Dockerfile
@@ -58,6 +58,8 @@ VOLUME /var/lib/postgresql/data
 
 COPY docker-entrypoint.sh /
 
+COPY enable-extensions.sh docker-entrypoint-initdb.d/
+
 ENTRYPOINT ["/docker-entrypoint.sh"]
 
 EXPOSE 5432
diff --git a/9.2/enable-extensions.sh b/9.2/enable-extensions.sh
@@ -0,0 +1,8 @@
+#!/bin/bash
+psql template1 -U $POSTGRES_USER --dbname $POSTGRES_DB -c 'create extension json_enhancements;' && \
+psql template1 -U $POSTGRES_USER --dbname $POSTGRES_DB -c "CREATE EXTENSION temporal_tables" && \
+psql template1 -U $POSTGRES_USER --dbname $POSTGRES_DB -c "GRANT ALL ON FUNCTION versioning() TO $POSTGRES_USER" && \
+psql template1 -U $POSTGRES_USER --dbname $POSTGRES_DB -c 'CREATE EXTENSION "uuid-ossp" schema pg_catalog;' && \
+psql template1 -U $POSTGRES_USER --dbname $POSTGRES_DB -c 'CREATE EXTENSION IF NOT EXISTS "pg_trgm"' && \
+psql template1 -U $POSTGRES_USER --dbname $POSTGRES_DB -c 'CREATE EXTENSION IF NOT EXISTS amqp'
+
