Re: PITR Multiple recoveries

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: PITR Multiple recoveries
Дата
Msg-id CAMkU=1zvwf2Vt5tTCoi9-QcwbYYv-VyzS3UbmVun_bLnmO58=w@mail.gmail.com
обсуждение исходный текст
Ответ на PITR Multiple recoveries  (Sébastien Boutté <sebastien.boutte@gmail.com>)
Ответы Re: PITR Multiple recoveries  (Sébastien Boutté <sebastien.boutte@gmail.com>)
Список pgsql-general
On Thu, Feb 8, 2018 at 5:07 AM, Sébastien Boutté <sebastien.boutte@gmail.com> wrote:
Hi all,

I'm trying to make my server doing PITR backup, i follow the rules on 

On my local server, i would like to resync multiple times my local database:

What i'm doing :
1. Stop Postgres
2. Restore Local basebackup (untar, un gzip)
3. Create recovery.conf
4. Start Postgres
5. Wait recovery.done
6. At this point, it's OK.

Once recovery is done and the database is open, it is now a primary.  It is no longer eligible for further WAL replay.
(Unless it is was only open in standby mode.)
  
Cheers,

Jeff

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

Предыдущее
От: Steven Hirsch
Дата:
Сообщение: Odd behavior with 'currval'
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Odd behavior with 'currval'