"John T. Dow" <john(at)johntdow(dot)com> writes:
> If you dump in plain text format, you can at least inspect the dumped
> data and fix it manually or with iconv. But the plain text
> format doesn't support large objects (again, not nice).
It does in 8.1 and later ...
> Also, neither of these methods gets information such as the roles,
Use pg_dumpall.
regards, tom lane