Database backup and restore

Поиск
Список
Период
Сортировка
От Colin Stearman
Тема Database backup and restore
Дата
Msg-id 012001c29240$0aae42f0$3301a8c0@Colin2000
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Fouad Fezzi"
Дата:
Сообщение: Re: pg_hba.conf file review
Следующее
От: dima
Дата:
Сообщение: Re: Database backup and restore