diff options
| author | Patrick Uiterwijk <puiterwijk@redhat.com> | 2014-12-16 23:42:53 +0000 |
|---|---|---|
| committer | Patrick Uiterwijk <puiterwijk@redhat.com> | 2014-12-16 23:42:53 +0000 |
| commit | 9d744d71e386e29ee7df13e8044e3b59dafc0190 (patch) | |
| tree | ba905809c6b31a3ee1f584a0086da5d95fecbf79 /roles/postgresql_server | |
| parent | 65fcd27282e38452345676f17bcec11d5bc438d7 (diff) | |
| download | ansible-9d744d71e386e29ee7df13e8044e3b59dafc0190.tar.gz ansible-9d744d71e386e29ee7df13e8044e3b59dafc0190.tar.xz ansible-9d744d71e386e29ee7df13e8044e3b59dafc0190.zip | |
Put pg into pg-8 compat mode for sqlalchemy with binary content
Diffstat (limited to 'roles/postgresql_server')
| -rw-r--r-- | roles/postgresql_server/templates/postgresql.conf | 7 |
1 files changed, 7 insertions, 0 deletions
diff --git a/roles/postgresql_server/templates/postgresql.conf b/roles/postgresql_server/templates/postgresql.conf index e8c058b99..5f9314c62 100644 --- a/roles/postgresql_server/templates/postgresql.conf +++ b/roles/postgresql_server/templates/postgresql.conf @@ -1,3 +1,10 @@ +{% if ansible_hostname.startswith("db-fas01") %} +# This enabled pg-8 compatibility for bytea fields +# Fixes errors with sqlalchemy with binary data when app is on RHEL6 and server is PG9 +# Reference: https://bitbucket.org/zzzeek/sqlalchemy/issue/2016/pickletype-does-not-work-with-postgresql +bytea_output = 'escape' +{% endif %} + # ----------------------------- # PostgreSQL configuration file # ----------------------------- |