Hi Steinar, Steinar H. Gunderson [2008-03-11 22:16 +0100]: > pg_restore: [archiver (db)] could not execute query: ERROR: encoding > MULE_INTERNAL does not match server's locale nb_NO.UTF-8 > DETAIL: The server's LC_CTYPE setting requires encoding UTF8. > Command was: > CREATE DATABASE sgwebtest WITH TEMPLATE = template0 ENCODING = > 'MULE_INTERNAL';
> I don't really know how or why this happened (or what MULE_INTERNAL is), > but I couldn't find a good way of resolving it short of dropping the > database. Is this a regression from 8.1 somehow? The upgrade error is bug http://bugs.debian.org/472930, which I need to work around in pg_upgradecluster somehow. The interesting part here is to find out why your old cluster got that MULE_INTERNAL encoding in the first place. Do you see that encoding anywhere in "psql -l" for the old cluster version? In the past, unexpected encodings came from ABI changes in libpq which did not get reflected in the SONAME. However, my p-common test suite is now pretty good in catching them, and has found such a problem in 8.3beta already (got fixed in 8.3 final), so I don't think there are a lot of those cases. Can you please check whether psql -l shows any different (and correct) encodings if you downgrade libpq5 to 8.2? Thanks, Martin -- Martin Pitt | http://www.piware.de Ubuntu Developer (www.ubuntu.com) | Debian Developer (www.debian.org)
signature.asc
Description: Digital signature
