pg_dump
- From
- Sergey Khvatov (2:5020/175.2)
- To
- Anton V. Yuzhaninov (2:5054/37.63)
- Date
- 2005-03-21T13:54:34Z
- Area
- RU.UNIX
From: "Sergey Khvatov" <xbatob@techno.spb.ru>
Sat Mar 19 2005 00:01, Anton V. Yuzhaninov wrote to All:
AVY> From: "Anton V. Yuzhaninov" <citrin@icn.bmstu.ru>
AVY> Hello, All!
AVY> Подскажите как правильно в postgresql бэкапить базы в юникоде?
AVY> Пишу
AVY> pg_dump -U pgsql --blobs --format=c --compress=1 jabberd2 > dump
AVY> и получаю кучу ошибок вида
AVY> pg_dump: WARNING: ignoring unconvertible UTF-8 character 0xe280ba
Судя по всему, у тебя база в юникоде, а текущая локаль - 8-битная. Выражаю
соболезнования.
Попробуй сделать dump под utf-8:
LANG=ru_RU.UTF-8 pg_dump ...
При restore надо будет делать то же самое.
--- ifmail v.2.15dev5
* Origin: FidoNet Online - http://www.fido-online.com (2:5020/175.2)
SEEN-BY: 50/203 421 53/558 450/186 208 247 452/25 100 460/15 112 461/33 74 106
SEEN-BY: 461/640 462/28 30 464/34 562 465/192 204 467/24 469/125 478/44 55
SEEN-BY: 550/5068 2432/200 4600/126 4614/20 4623/56 178 4625/9 4626/100
SEEN-BY: 4635/83 99 1024 4641/444 4652/15 4657/50 5000/197 5001/50 5001
SEEN-BY: 5002/76 5002 5003/34 75 5010/53 5011/13 5012/23 5015/4 28 5020/18 20
SEEN-BY: 5020/52 104 115 128 150 175 178 313 371 400 434 486 508 545 549 556
SEEN-BY: 5020/600 639 642 715 758 794 830 894 921 937 958 968 982 1100 1169
SEEN-BY: 5020/1212 1234 1604 1626 1630 1642 1653 1826 1930 2020 2047 2140 2200
SEEN-BY: 5020/2238 2590 4400 4441 12000 5021/2 3 11 44 5022/5 128 5023/11
SEEN-BY: 5024/1 73 5025/19 750 5026/45 78 5029/32 5030/49 69 195 382 436 556
SEEN-BY: 5030/611 920 966 1016 1039 1063 1212 1688 1900 5031/47 63 5032/11 16
SEEN-BY: 5033/21 35 5034/8 5035/10 53 63 5036/13 5037/21 36 5040/33 47 59
SEEN-BY: 5041/4 5042/13 21 5045/7 5047/47 5049/50 157 5050/9 41 5051/35
SEEN-BY: 5053/16 5054/1 4 8 9 28 35 36 37 50 63 67 70 75 81 84 5055/95 5058/20
SEEN-BY: 5058/77 5059/9 20 5060/90 5061/26 5062/1 5063/51 5064/35 36 53
SEEN-BY: 5065/777 5067/2 5070/26 66 1222 5071/22 5072/8 5075/37 5077/51 70
SEEN-BY: 5078/4 5079/23 49 5080/80 1003 5083/13 21 5090/23 105 5093/4 33
SEEN-BY: 5096/18 5100/113 6000/12 6023/1 6033/2727 6045/7 6055/5 86 6083/11
SEEN-BY: 6096/10
PATH: 5020/175 4441 52 5054/1 37