LC_COLLATE and pg_upgrade

Поиск
Список
Период
Сортировка
Искать
От
Bernhard Schrader
Тема
LC_COLLATE and pg_upgrade
Дата
Msg-id
1297357018.2340.10.camel@schrader-laptop
Список
Дерево обсуждения
LC_COLLATE and pg_upgrade Bernhard Schrader <bernhard.schrader@innogames.de>
Re: LC_COLLATE and pg_upgrade Bernhard Schrader <bernhard.schrader@innogames.de>
Re: LC_COLLATE and pg_upgrade Peter Eisentraut <peter_e@gmx.net>
Re: LC_COLLATE and pg_upgrade Bernhard Schrader <bernhard.schrader@innogames.de>
Re: LC_COLLATE and pg_upgrade Peter Eisentraut <peter_e@gmx.net>
Re: LC_COLLATE and pg_upgrade Bruce Momjian <bruce@momjian.us>
Hi all,

I just tried to pg_upgrade a PostgreSQL-8.4 to 9.0.

pg_upgrade stopped with this message:

"old and new cluster lc_collate values do not match"

So i checked the LC_COLLATE on 8.4 and 9.0:

8.4:
postgres=# show lc_collate;
lc_collate 
------------
en_US.utf8
(1 row)

9.0:
postgres=# show lc_collate;
lc_collate 
------------
en_US.UTF-8
(1 row)


Well... I think you see my problem, i don't even know if it is really a
problem... 

Is it possible just to change the lc_collate on the 8.4 machine?
Obviously its the same encoding, or am i wrong?

My second Question, but not that urgent is about two databases which
have LC_COLLATE=C, is there a safe way to get it to UTF-8? 

regards
Bernhard


В списке pgsql-admin по дате отправления
От: Gabriele Bartolini
Дата:
От: CS DBA
Дата:
Сообщение: Re: Postgres on NAS/NFS
FAQ