Re: incremental backups

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: incremental backups
Дата
Msg-id 27731.1138672692@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: incremental backups  (Rick Gigger <rick@alpinenetworking.com>)
Ответы Re: incremental backups  (Rick Gigger <rick@alpinenetworking.com>)
Список pgsql-general
Rick Gigger <rick@alpinenetworking.com> writes:
> And here is the real million dollar question.  Let's say for some
> reason I don't have the last WAL file I need for my backup to be
> valid.  Will it die and tell me it's bad or will it just start up
> with a screwed up data directory?

It'll restore up to the end of the data it has.  The only case that's
actually "invalid" is not restoring far enough to cover the time window
that the original base backup was taken over.  Otherwise it's just a
situation of restoring up to a particular point in time...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Insert rate drops as table grows
Следующее
От: "Marc G. Fournier"
Дата:
Сообщение: Re: [HACKERS] New project launched : PostgreSQL GUI