Обсуждение: PITR Multiple recoveries

Поиск
Список
Период
Сортировка

PITR Multiple recoveries

От
Sébastien Boutté
Дата:
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.
7. Stop Postgres
8. ..... some time passed
9. resync wals with latest
10. recreate recovery.conf
11. Start Postgres
11. Wait recovery.done
12. At this point, it's NOK. Latest wals have not been played on local server.

Do you know what i'm missing ? Thanks
 
Regards,

Sebastien Boutte

Re: PITR Multiple recoveries

От
Jeff Janes
Дата:
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

Re: PITR Multiple recoveries

От
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 system is ready to accept read only connections"
6. To Check
7. Stop Postgres
8. ..... some time passed
9. resync wals with latest
10. recreate recovery.conf without standby_mode + hot_standby off
11. Start Postgres
11. Wait recovery.done
12. To Check

Thanks

Sebastien




On Thu, Feb 8, 2018 at 5:11 PM, Jeff Janes <jeff.janes@gmail.com> wrote:
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