Skip to content

Instantly share code, notes, and snippets.

@asbjornenge

asbjornenge/psqlfix.sh

Forked from fgrehm/psqlfix.sh
Created July 25, 2013 20:07
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save asbjornenge/6083265 to your computer and use it in GitHub Desktop.
Save asbjornenge/6083265 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
psqlfix.sh
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment