Re: [GENERAL] Encoding problem using pg_dumpall

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] Encoding problem using pg_dumpall
Дата
Msg-id 28817.1233242176@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Encoding problem using pg_dumpall  ("Moshe Ben-Shoham" <mosheb@nexperience.com>)
Ответы Re: [GENERAL] Encoding problem using pg_dumpall  (Magnus Hagander <magnus@hagander.net>)
Список pgsql-admin
"Moshe Ben-Shoham" <mosheb@nexperience.com> writes:
> C:\Program Files\PostgreSQL\8.3\bin>pg_dumpall -U admint >
> c:\temp\dbdump.sql
> pg_dump: SQL command failed
> pg_dump: Error message from server: ERROR:  character 0xd595 of encoding
> "UTF8" has no equivalent in "WIN1252"

Apparently you have WIN1252 set as the default client encoding, probably
via an environment variable or locale setting.  Either get rid of it,
or override it by including "-E UTF8" in the pg_dump command.

(Hmm, actually it looks like pg_dumpall hasn't got a -E switch,
which seems like an oversight.  So you need to fix your locale,
or else use pg_dump directly.)

            regards, tom lane

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

Предыдущее
От: Devrim GÜNDÜZ
Дата:
Сообщение: Re: finding dev rpms
Следующее
От: Magnus Hagander
Дата:
Сообщение: Re: [GENERAL] Encoding problem using pg_dumpall