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
