=?ISO-8859-1?Q?J=E9r=F4me?= BENOIS <benois@xxxxxxxxxxxxxxxxxxxx> writes: > Le jeudi 14 septembre 2006 =C3=A0 10:56 -0500, Scott Marlowe a =C3=A9crit : >> I'm gonna make a SWAG here and guess that maybe your 7.4 db was initdb'd >> with a locale of C and the new one is initdb'd with a real locale, like >> en_US. Can J=C3=A9r=C3=B4me confirm or deny this? > The locale used to run initdb is : > su - postgres > :~$ locale > LANG=POSIX It'd be more convincing if "show lc_collate" etc. display C or POSIX. The fact that postgres' current default environment is LANG=POSIX doesn't prove much about what initdb saw. regards, tom lane
