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