Re: PostgreSQL Point In Time Recovery

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: PostgreSQL Point In Time Recovery
Дата
Msg-id CAMkU=1yLU90dz_9vJqxs4Nm7jj9sKNH0JbGwCW60Z0fenhxWEA@mail.gmail.com
обсуждение исходный текст
Ответ на PostgreSQL Point In Time Recovery  (Jayadevan M <maymala.jayadevan@gmail.com>)
Ответы Re: PostgreSQL Point In Time Recovery  (John R Pierce <pierce@hogranch.com>)
Re: PostgreSQL Point In Time Recovery  (Jayadevan <maymala.jayadevan@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Wed, Oct 23, 2013 at 9:10 PM, Jayadevan M <maymala.jayadevan@gmail.com> wrote:
and set up the archiving process. With this approach, if my database crashes after a couple of weeks after the base backup is taken, recovering would mean replaying the WAL logs for about 2 weeks, right? To avoid that, what is the standard process followed - take a base backup every day or once a week?
Regards,
Jayadevan

I restore from my base backup plus WAL quite often.  It is how I get a fresh dev or test instance when I want one.  (It is also how I have confidence that everything is working well and that I know what I'm doing should the time come to do a real restore).  When that starts to take an annoyingly long time, I run a new base backup.  How often that is, can be anywhere from days to months, depending on what's going on in the database.

Cheers,

Jeff

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index
Следующее
От: Rémi Cura
Дата:
Сообщение: Re: GIST index : order Hack : getting the order used by CLUSTER .. USING my_index