Re: PITR Multiple recoveries

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Thu, Feb 8, 2018 at 5:07 AM, Sébastien Boutté <sebastien.boutte@xxxxxxxxx> wrote:

Hi all,

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

https://www.postgresql.org/docs/9.5/static/continuous-archiving.html.

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