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
|
| Список | 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 onOn my local server, i would like to resync multiple times my local database:What i'm doing :1. Stop Postgres2. Restore Local basebackup (untar, un gzip)3. Create recovery.conf4. Start Postgres5. Wait recovery.done6. 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 по дате отправления: