What pg_dump backup modes do people usually use for a backup of an entire database cluster? I usually use plaintext and pipe it through gzip, however, that doesn't allow you to restore single objects from a complete backup.
Is there a way to back up the entire cluster using the "t" or "c" output
mode for pg_dump? What is the difference between "t" and "c"?
Regards,
Jeff Davis
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
