For the record, this is the reproduction recipe: setup:
sudo pg_createcluster 8.2 main --start sudo -u postgres createdb -E latin1 latintest sudo -u postgres createdb utf8test sudo -u postgres psql -c "create table t(x varchar); insert into t values(E'A\xC3\xB6B');" utf8test sudo -u postgres psql -c "create table t(x varchar); insert into t values(E'A\xF6B');" latintest verify that 8.2 DBs have correct encoding: $ psql -Atc 'select * from t' utf8test AöB $ psql -Atc 'select * from t' latintest | iconv -f latin1 AöB upgrade to 8.3 which breaks: sudo pg_upgradecluster 8.2 main I am not yet quite clear how to work around this problem yet. My preferred approach would be to create the 8.3 databases with a proper encoding on upgrade and convert it on the fly. But at least I can put above recipe into the postgresql-common test suite. Martin -- Martin Pitt | http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) ** Changed in: postgresql-common (Ubuntu) Importance: Undecided => Medium Status: New => Confirmed ** Attachment added: "unnamed" http://launchpadlibrarian.net/12980864/unnamed -- postgresql-8.3 cluster locale should not be utf8 https://bugs.launchpad.net/bugs/207779 You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. -- ubuntu-bugs mailing list [email protected] https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
