7.0.3 -> 7.1.2; pg_setlocale error

Поиск
Список
Период
Сортировка
От pgsql-admin
Тема 7.0.3 -> 7.1.2; pg_setlocale error
Дата
Msg-id fc.000f567200c3c870000f567200c3c870.c3c908@fc.emc.com.ph
обсуждение исходный текст
Ответы Re: 7.0.3 -> 7.1.2; pg_setlocale error
Список pgsql-admin
Hi,

I am trying to migrate from 7.0.3 to 7.1.2. I just got the
rpms from rawhide of redhat.

While loading the 7.0.3 dump_file to 7.1.2, I got these errors...

ERROR:  stat failed on file '/usr/lib/pgsql/plpgsql.so': No such file or
directory
ERROR:  PL handler function plpgsql_call_handler() doesn't exist
You are now connected as new user postgres.
NOTICE:  copy: line 1, pg_setlocale(): 'LC_COLLATE=Ȁ' cannot be honored.
NOTICE:  copy: line 1, pg_setlocale(): 'LC_CTYPE=°T0@X' cannot be honored.
NOTICE:  copy: line 1, pg_setlocale(): 'LC_MONETARY=X˜' cannot be honored.

and these showed in /var/log/postgresql

Jun 14 15:53:28 hype postgres[13306]: [68] DEBUG:  query: COPY
"pp_payment" FROM stdin;
Jun 14 15:53:28 hype postgres[13306]: [69] DEBUG:  ProcessUtility: COPY
"pp_payment" FROM stdin;
Jun 14 15:53:28 hype postgres[13306]: [70] NOTICE:  copy: line 1,
pg_setlocale(): 'LC_COLLATE=ÈÏ^]^H\200Ð^]^H^P' cannot be honored.
Jun 14 15:53:28 hype postgres[13306]: [71] NOTICE:  copy: line 1,
pg_setlocale(): 'LC_CTYPE=°T0@XÞ^]^H^P' cannot be honored.
Jun 14 15:53:28 hype postgres[13306]: [72] NOTICE:  copy: line 1,
pg_setlocale(): 'LC_MONETARY=XÞ^]^H\230à^]^H^P' cannot be honored.

I fixed the error on plpgsql.so by 'perl -pi.bak -e
's|/usr/lib/pgsql/plpgsql.so|/usr/lib/plpgsql.so|g' dump_file'
but I'm still confuse  with notice on pg_setlocale.

Will it do harm to the data?

Thanks.


sherwin


В списке pgsql-admin по дате отправления:

Предыдущее
От: DHSC Webmaster
Дата:
Сообщение: Re: performance issues
Следующее
От: Tom Lane
Дата:
Сообщение: Re: performance issues