also, if you store blobs in your database then you need to use pg_dump and
pg_restore to backup/restore them.
----- Original Message -----
From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
> Generally, I'd say that if you intend to restore the entire contents of
your
> dump file, then using the plain text format (& compressing with gzip if
> needed) is the way to go.
>
> If you need the ability to selectively restore some part of the dump file,
> (like one table) then you should use one of the non-text formats for
pg_dump
> and thus need to restore using pg_restore.