Arnau <arnaulist(at)andromeiberica(dot)com> writes:
> template1=# create database test with encoding='LATIN9';
> ERROR: encoding LATIN9 does not match server's locale en_US
> DETAIL: The server's LC_CTYPE setting requires encoding LATIN1.
> I've been looking into the documentation to fix this and the only way
> I have found is to use initdb to recreate the cluster, Is there any
> other option?
Nope, sorry. If you need to change the database locale, you have to
re-initdb.
regards, tom lane