> 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. And in any case,
> pg_restore seems to be missing its equivalent pg_restoreall. Other than
> (painfully) manually pg_dumping and pg_restoring each database, how else
> could it be done?
> I would search the mailing lists but the site's search engine is down.
i wrote a script in perl which dumps all the DBs but template*
i can mail it to you if you wish
In response to
pgsql-admin by date
|Next:||From: Timothy D McKernan||Date: 2002-11-22 18:25:35|
|Subject: ram drive|
|Previous:||From: Colin Stearman||Date: 2002-11-22 15:58:45|
|Subject: Database backup and restore|