Bug#461836: postgresql-common: Locale problems with pg_upgradecluster

2008-03-02 Thread Tijs van Dam
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 lo

Bug#461836: postgresql-common: Locale problems with pg_upgradecluster

2008-03-01 Thread Martin Pitt
Hi again, ah, I was able to get something like this the other way round: $ sudo locale-gen de_DE $ sudo pg_createcluster 8.1 test --start $ sudo -u postgres createdb -E LATIN1 test $ sudo rm -r /usr/lib/locale/de_DE $ sudo pg_upgradecluster 8.1 test Upgrading database test... pg_r

Bug#461836: postgresql-common: Locale problems with pg_upgradecluster

2008-03-01 Thread Martin Pitt
Hi all, it seems that Bastian put his finger on it. All of you had some databases encoded in a latin encoding. I got a confirmation from Rory that on his system no latin encoding existed any more, i. e. "locale -a" output just showed some .UTF-8 and C/POSIX. Can the others of you confirm that th

Bug#461836: postgresql-common: Locale problems with pg_upgradecluster

2008-02-07 Thread Bastian Kleineidam
Hi, I had the same problem. The situation I (and probably you) had was: - old 8.2 cluster with default encoding: [EMAIL PROTECTED] + encoding of databases "template0", "template1" and "postgres": [EMAIL PROTECTED] + encoding of database "test": UTF-8 - current system locale: de_DE.UTF-8 My c

Bug#461836: postgresql-common: Locale problems with pg_upgradecluster

2008-01-20 Thread Sami Liedes
Package: postgresql-common Version: 83 Severity: normal Hi, I tried to run pg_upgradecluster, but I get locale-related errors: # pg_upgradecluster 8.2 main Creating new cluster (configuration: /etc/postgresql/8.3/main, data: /var/lib/