Kloadut / dokku-pg-plugin

PostgreSQL plugin for Dokku
201 stars 75 forks source link

Unicode #74

Closed mcmillion closed 9 years ago

mcmillion commented 9 years ago

I'm trying out Dokku for the first time, and everything seems to be running smoothly except or Unicode support. I've run into this error before with standard installs, but since this is utilizing Docker, I'm not sure how this should be handled:

PG::InvalidParameterValue: ERROR: new encoding (UTF8) is incompatible with the encoding of the template database (SQL_ASCII)

I'm using Digital Ocean's Dokku image, which is currently running v0.3.17 and the latest master of this plugin. Any ideas? All of the documentation that I've seen seems to show Unicode working out of the box, but it looks like my Postgres was set up with ASCII.

Edit: I was able to switch template1 to UTF8 using postgresql:console, but this feels wrong as I'm assuming I'll have to do it with each app.