Ansibles/postgresql — pull request #28 by gaqzi (2014-07-01 12:29:17+00:00)
Title: Don't set client_encoding by default

The current default value of sql_ascii leaves the database incapable of
inputting Unicode data without first setting the connection encoding. If
the client_encoding isn't set at all then the client_encoding is set to
the same as the databases's encoding.

The documentation for [client_encoding] isn't super clear I think, but
leaving this value unset would adhere to the default behavior of a
new installation.

I don't know if there are more configuration variables that have similar
behavior as I'm not an experienced Postgresadmin, this was simply one
to bite me. :)

[client_encoding]: http://www.postgresql.org/docs/9.3/static/runtime-config-client.html#GUC-CLIENT-ENCODING