Re: PITR Multiple recoveries

2018-02-08 Thread Sébastien Boutté
Hi Jeff, You mean that ? Is this correct ? hot_stanby = on to be sure it plays WAL and stays in standby mode ? 1. Stop Postgres 2. Restore Local basebackup (untar, un gzip) 3. Create (recovery.conf) standby_mode + hot_standby on (postgresql.conf) 4. Start Postgres 5. Wait to see in log "database

Re: PITR Multiple recoveries

2018-02-08 Thread Jeff Janes
On Thu, Feb 8, 2018 at 5:07 AM, Sébastien Boutté 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: >