Arnau <arnaulist@xxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
