pg_dump -f your_db.dmp your_db iconv -f ISO8859-1 -t UTF-8 your_db.dmp > utf.dmp psql your_utf_db < utf.dmp