Re: Full backup - pg_dumpall sufficient?

Поиск
Список
Период
Сортировка
От Raymond O'Donnell
Тема Re: Full backup - pg_dumpall sufficient?
Дата
Msg-id 4981DFA7.6020000@iol.ie
обсуждение исходный текст
Ответ на Full backup - pg_dumpall sufficient?  (Gerhard Wiesinger <lists@wiesinger.com>)
Ответы Re: Full backup - pg_dumpall sufficient?
Список pgsql-general
On 29/01/2009 16:31, Gerhard Wiesinger wrote:

> I recently read some Mail on the mailinglist where some parts of
> PostgreSQL were not dumped with pg_dumpall and additionally some pg_dump
> was necessary (it was something like internals, catalog, etc.)

It's the other way around - pg_dump dumps just the specified database,
but not cluster-wide stuff like login roles; you need to do a pg_dumpall
to get those as well.

Ray.

------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Text search segmentation fault
Следующее
От: David Fetter
Дата:
Сообщение: Re: Pet Peeves?