pg_dump output mode

From: Jeff Davis <jdavis-pgsql(at)empires(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_dump output mode
Date: 2005-10-03 06:05:07
Message-ID: 4340CA13.90206@empires.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John Craddock 2005-10-03 06:56:11 Postgresql Vb.1 beta 2 win binary
Previous Message Tom Lane 2005-10-03 05:12:44 Re: Portable PostgreSQL