Re: pg_dumpall

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dumpall
Дата
Msg-id 11205.1200593977@sss.pgh.pa.us
обсуждение исходный текст
Ответ на pg_dumpall  (Steve Clark <sclark@netwolves.com>)
Ответы Re: pg_dumpall  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: pg_dumpall  (Glyn Astill <glynastill@yahoo.co.uk>)
Re: pg_dumpall  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-general
Steve Clark <sclark@netwolves.com> writes:
> does pg_dumpall make consistent backups if the database is being used
> concurrently?
> Even though the man page doesn't say it does.

That's intentional, because it doesn't.  What you get is a pg_dump
snapshot of each database in sequence; those snapshots don't all
correspond to the same time instant.  There isn't any good way to
guarantee time coherence of dumps across two databases.

            regards, tom lane

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

Предыдущее
От: Steve Clark
Дата:
Сообщение: pg_dumpall
Следующее
От: Alvaro Herrera
Дата:
Сообщение: testing the news gateway