Re: Database backup and restore

Поиск
Список
Период
Сортировка
От dima
Тема Re: Database backup and restore
Дата
Msg-id 3DDE5628.50403@mail.ru
обсуждение исходный текст
Ответ на Database backup and restore  ("Colin Stearman" <cstearman@infofind.com>)
Ответы Re: Database backup and restore  ("Dan Langille" <dan@langille.org>)
Список 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.
i wrote a script in perl which dumps all the DBs but template*
i can mail it to you if you wish


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Colin Stearman"
Дата:
Сообщение: Database backup and restore
Следующее
От: Timothy D McKernan
Дата:
Сообщение: ram drive