Re: Dump/restore with bad data and large objects

"John T. Dow" <john@johntdow.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