Skip to content

Instantly share code, notes, and snippets.

@pcdinh
Forked from mrrooijen/PostgreSQL-UTF8.sh
Created June 28, 2013 05:26
Show Gist options
  • Save pcdinh/5882652 to your computer and use it in GitHub Desktop.
Save pcdinh/5882652 to your computer and use it in GitHub Desktop.
# Or set it to template0 in Rails (ActiveRecord)
production:
template: template0
UPDATE pg_database SET datistemplate = FALSE WHERE datname = 'template1';
DROP DATABASE template1;
CREATE DATABASE template1 WITH TEMPLATE = template0 ENCODING = 'UNICODE';
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template1';
\c template1
VACUUM FREEZE;
UPDATE pg_database SET datallowconn = FALSE WHERE datname = 'template1';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment