2018-01-17 11:43 GMT-05:00 Néstor Ramires <nrami...@rosario.gov.ar>:
>
> postgres=# CREATE DATABASE mi_base
> WITH OWNER = postgres
> ENCODING = 'UTF8'
> CONNECTION LIMIT = -1;
> ERROR: encoding "UTF8" does not match locale "es_AR.iso88591"
> DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1".
> postgres=#
>
> ¿como puedo sortear este inconveniente sin modificar la codificacion por
> defecto?
>

intenta usando template0 como template
"""
CREATE DATABASE mi_base
 WITH OWNER = postgres
 TEMPLATE = template0
 ENCODING = 'UTF8'
 CONNECTION LIMIT = -1;
"""

-- 
Jaime Casanova                      www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Reply via email to