Skip to content

Instantly share code, notes, and snippets.

@mrrooijen
Created December 31, 2011 18:37
Show Gist options
  • Save mrrooijen/1544896 to your computer and use it in GitHub Desktop.
Save mrrooijen/1544896 to your computer and use it in GitHub Desktop.
Make PostgreSQL use UTF-8 encoding instead of ASCII.
# 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