Postgres Pro
Downloads
Home   >   mailing lists

Re: PITR Multiple recoveries - Mailing list pgsql-general

From Jeff Janes
Subject Re: PITR Multiple recoveries
Date
Msg-id CAMkU=1zvwf2Vt5tTCoi9-QcwbYYv-VyzS3UbmVun_bLnmO58=w@mail.gmail.com
Whole thread Raw
In response to PITR Multiple recoveries  (Sébastien Boutté <sebastien.boutte@gmail.com>)
Responses Re: PITR Multiple recoveries  (Sébastien Boutté <sebastien.boutte@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Steven Hirsch
Date:
Subject: Odd behavior with 'currval'
Next
From: "David G. Johnston"
Date:
Subject: Re: Odd behavior with 'currval'