$ sudo aptitude install postgresql libdbd-pg-perl
$ sudo -u postgres pg_dumpall | nkf -w8 | sed 's/EUC_JP/UTF8/g' > dumpall-utf8.txt
$ sudo -u postgres psql -f dumpall-utf8.txt postgres