On Thu, Feb 8, 2018 at 5:07 AM, Sébastien Boutté <sebastien.bou...@gmail.com > 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
