On Oct 3, 2005, at 1:05 AM, Jeff Davis wrote:
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
Come to think of it, I don't know a way to dump an entire cluster in
the custom format, but that might be because pg_restore is designed
to restore a database rather than a cluster.
I think the only difference between "t" and "c" is that "c" is
compressed by default.
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
Strategic Open Source: Open Your i™
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-469-5150
615-469-5151 (fax)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
