Monthly Archives: February 2010

pg_dump failed – invalid byte sequence for encoding “UTF8″

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.