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)
signature.asc
Description: Digital signature
