I seems that the 8.3 upgrade does not allow LATIN1 encoding at all (at least on my system):
dev:~# pg_createcluster 8.3 main --start ... dev:~# su - postgres [EMAIL PROTECTED]:~$ createdb -p 5433 -E LATIN1 xyz createdb: database creation failed: ERROR: encoding LATIN1 does not match server's locale en_US.UTF-8 DETAIL: The server's LC_CTYPE setting requires encoding UTF8. I think there is a relation to postgresql bug #3924 (http://www.nabble.com/BUG--3924:-Create-Database-with-another-encoding-as-the-encoding-from-postgres-td15246051.html), about not being able to create LATIN1 databases on a UTF8 cluster, and this being a Feature. If I create a 8.3 cluster with pg_createcluster --locale=C, I can create LATIN1 databases just fine. According to 8.3 release notes, C is the only locale compatible with all db encodings. The pg_upgradecluster script gets the server locale from the old cluster, in my case en_US. Apparently this is not compatible with LATIN1. By the way, I do have the en_US locale compiled on my system (it's in locale -a). -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
