Re: Clarification on pg_basebackup

Поиск
Список
Период
Сортировка
От Jeff Frost
Тема Re: Clarification on pg_basebackup
Дата
Msg-id 101425DE-8870-4C8F-89FF-186C5D20545D@pgexperts.com
обсуждение исходный текст
Ответ на Re: Clarification on pg_basebackup  ("Campbell, Lance" <lance@illinois.edu>)
Ответы Re: Clarification on pg_basebackup  (Rajesh Madiwale <rajeshmadiwale65@gmail.com>)
Список pgsql-admin
That's right.

BTW, rather than rolling your own solution, you probably want to look at a few off the shelf solutions like:




On Sep 23, 2014, at 9:18 AM, Campbell, Lance <lance@illinois.edu> wrote:

Jason,
Thanks so much.  That makes sense.  That was what I was trying to communicate.  OPIT vs APIT. 
 
So if I am doing a APIT I can do a pg_basebackup each night without the –X option.  I save all WAL files.  If I need to restore during the day I then only have to restore from the last basebackup and apply all of the WAL files from that time forward.  Did I get that correct?    
 


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

Предыдущее
От: Jason Mathis
Дата:
Сообщение: Re: Clarification on pg_basebackup
Следующее
От: Raj Gandhi
Дата:
Сообщение: format() function with string_agg