Skip to content

Instantly share code, notes, and snippets.

@thilo

thilo/database.yml

Last active December 26, 2015 12:29
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 thilo/7151866 to your computer and use it in GitHub Desktop.
Save thilo/7151866 to your computer and use it in GitHub Desktop.
Download ZIP
How to set a local collation and other encoding settings for postgresql in database yml if the system has other defaults. If you get the error `invalid locale name YOUR_LOCALE` you must generate the locale first with `sudo locale-gen YOUR_LOCALE` Its important that you use the template option together with the collation, otherwise you will get a…
Raw
database.yml
development:
adapter: postgresql
encoding: utf8
ctype: de_DE.utf8
collation: de_DE.utf8
template: template0
socket: /var/run/postgresql
database: professor_s_development
pool: 5
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment