Recommended way to dump multi db cluster

Поиск
Список
Период
Сортировка
От lst_hoe02@kwsoft.de
Тема Recommended way to dump multi db cluster
Дата
Msg-id 20130808105619.Horde.7kxU4Ktcgakk9mE61CvHKw4@webmail.kwsoft.de
обсуждение исходный текст
Ответы Re: Recommended way to dump multi db cluster
Список pgsql-admin
Hello,

as of now we do a pg_dumpall on most of our PostgreSQL instances. This
has some drawbacks when restore of only one of the databases is
required, because from what i can see pg_restore is not able to limit
the restore to one database?
With pg_dump per database the problem will arise to backup user/roles
and other central settings, so what is the recommended way to dump
multi database instances?

Thanks

Andreas



Вложения

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

Предыдущее
От: Brian Wong
Дата:
Сообщение: Re: After upgrading from 9.1.1 to 9.1.9, pgadmin's server status window gives error
Следующее
От: Jan Lentfer
Дата:
Сообщение: Re: Recommended way to dump multi db cluster