ntribution
directory, if desired.
- Original Message -
From: "Dan Langille" <[EMAIL PROTECTED]>
To: "Colin Stearman" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, November 22, 2002 2:46 PM
Subject: Re: [ADMIN] Database backup and restore
Dan,
On first glance at dima's script it does not seem to deal with blobs,
although could easily me made to do so.
Also it does not address automated reloading. In light of the fact that
blobs must be output by -Ft or -Fc in pg_dump, which are tar and custom
respectively, the result of an entire
Am I missing something? There seems to
be no way to dump all databases and then restore them (as you'd have to do on a
version change) if the databases contain blobs.
pg_dump supports dumping of blobs with the -b -Ft
switch, but using pg_dumpall with those switches doesn't seem to work.