asbjornenge

if ! $(psql template1 -c 'SHOW SERVER_ENCODING' | grep -q UTF8); then
  psql postgres -c "update pg_database set datallowconn = TRUE where datname = 'template0';"
  psql template0 -c "update pg_database set datistemplate = FALSE where datname = 'template1';"
  psql template0 -c "drop database template1;"
  psql template0 -c "create database template1 with template = template0 encoding = 'UTF8';"
  psql template0 -c "update pg_database set datistemplate = TRUE where datname = 'template1';"
  psql template1 -c "update pg_database set datallowconn = FALSE where datname = 'template0';"
fi

asbjornenge

Docker PostgreSQL How-To

How to use [zaiste/postgresql][1] Docker container.

docker pull zaiste/postgresql

CONTAINER=$(docker run -d -p 5432 \