Database backup and restore - Mailing list pgsql-admin

From Colin Stearman
Subject Database backup and restore
Date
Msg-id 012001c29240$0aae42f0$3301a8c0@Colin2000
Whole thread Raw
List pgsql-admin
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.
 
Thanks,
Colin
---------------------------------------------
Colin Stearman
President
Ashdown Technologies
119 E. Main St.
Milford, MA 01757 USA
Tel: +1 508-478-1234
Fax: +1 508-478-1244
www.ashdowntech.com

pgsql-admin by date:

Previous
From: "Fouad Fezzi"
Date:
Subject: Re: pg_hba.conf file review
Next
From: dima
Date:
Subject: Re: Database backup and restore