reassign 539585 postgresql-common 94 tag 539585 moreinfo thanks Hello Salvatore,
Salvatore Tomaselli [2009-08-02 9:56 +0200]: > My locale is UTF8. > Migrating from 8.1 to 8.3 the new cluster was LATIN9. But your 8.1 cluster was UTF8? Can you please give me the output of /usr/lib/postgresql/8.1/bin/pg_controldata /var/lib/postgresql/8.1/main|grep LC /usr/lib/postgresql/8.3/bin/pg_controldata /var/lib/postgresql/8.3/main|grep LC > So i guess the new clusters should be automatically created with the > system encoding by default The default mode for pg_upgradecluster is to use the same encoding as the old cluster. This is also checked in postgresql-common's test suite, so I'm fairly sure that it works in the general case. Did you use pg_upgradecluster for this migration or used pg_dump/pg_restore manually? Martin -- Martin Pitt | http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org) -- To UNSUBSCRIBE, email to [email protected] with a subject of "unsubscribe". Trouble? Contact [email protected]
