The following bug has been logged online:
Bug reference: 5361
Logged by: Alexender
Email address: bavcom@mail.ru
PostgreSQL version: 8.4
Operating system: Ubuntu server 9.10 (Karmic)
Description: KOI8U issue
Details:
This is real problem.
Dump from Postgres 8.2 can't be restored in Postgres 8.4
if I use on server 8.2 encodings KOI8 and --lc-collate and --lc-ctype
uk_UA.KOI8-U
Because conversion is not supported between KOI8R and KOI8U and
dump 8.2 have string "SET client encodigs KOI8" which KOI8R in 8.4 but I
need in postgres 8.4 "SET client encodigs KOI8U" in dump file because i used
--lc-collate and --lc-ctype = uk_UA.koi8-U.
[Solved]
The only way I solve it change in plain/text dump string
on "SET client encodings KOI8U" and use database in koi8U encoding with
--lc-collate and --lc-ctype = uk_UA.koi8-U.
But it's dfficult to change it in large file.