pg_dump failed – invalid byte sequence for encoding “UTF8″

Posted by admin on February 20, 2010 Leave a comment (0) Go to comments

Using

pg_dump -U projop -E UTF8 -d projop > projop.dump

instead of the usual

pg_dump --no-owner --clean --disable-dollar-quoting --format=p --file projop.dump

I was able to to restore the db.

./klaus hofeditz :: weblog