Re: Full backup - pg_dumpall sufficient?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Full backup - pg_dumpall sufficient?
Дата
Msg-id 25763.1233248469@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Full backup - pg_dumpall sufficient?  (Gerhard Wiesinger <lists@wiesinger.com>)
Список pgsql-general
Gerhard Wiesinger <lists@wiesinger.com> writes:
> Any ideas what additionally has to be dumped to pg_dumpall for a full
> backup?

The configuration files (postgresql.conf, pg_hba.conf, pg_ident.conf),
plus any SSL server keys/certs you might be using --- basically, all
the static text files in the toplevel $PGDATA directory.  Those things
are not accessible to a client so pg_dump can't dump them.

Some people put these files in a different directory where they'll be
caught by their regular filesystem backup procedures for the server.

            regards, tom lane

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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Pet Peeves?
Следующее
От: Gerhard Wiesinger
Дата:
Сообщение: Re: Full backup - pg_dumpall sufficient?