I’ve got a small issue.
My cookbook works perfectly on Ubuntu 12.04, where postgresql 9.1 is
However, when deploying to another node - a VM provider that only has
Ubuntu up to 11.04 - I’m having encoding issues as in:
#<ActiveRecord::StatementInvalid: PG::Error: ERROR: new encoding (UTF8) is
incompatible with the encoding of the template database (SQL_ASCII)
HINT: Use the same encoding as in the template database, or use template0
: CREATE DATABASE “app_production” ENCODING = ‘utf8’>
The simplest solution, I think, would be to just install 9.1. I’ve already
tried setting up the system locale to “en_US.utf8” before installing
postgresql, but it did not seem to work.
Any straightforward way to build from source or specify Ubuntu 11.04 to use
9.1 using opscode’s postgresql cookbook? From what I’ve seen, it’s not; it
will just get what’s available in apt. I may end up just writing a series
of execute statements to compile 9.1 from source.
Any hints appreciated,