Re: [GENERAL] 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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general