Database backup and restore

Поиск

Список

Период

Сортировка

От	Colin Stearman
Тема	Database backup and restore
Дата	22 ноября 2002 г. 10:58:58
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 по дате отправления:

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Database backup and restore