Scenario using pg_rewind

From: "Kato, Sho" <kato-sho(at)jp(dot)fujitsu(dot)com>
To: "'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>
Subject: Scenario using pg_rewind
Date: 2018-02-27 07:40:27
Message-ID: 25C1C6B2E7BE044889E4FE8643A58BA9639C52B4@G01JPEXMBKW03
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


I have a question of how to use pg_rewind.
I see the manual. It says bringing an old master server back online after failover is typical case.

A typical scenario is to bring an old master server back online after failover, as a standby that follows the new master.

I came up with an another scenario where user uses a synchronized old master as a new master.
If so, pg_rewind need to copy WAL from a source server.
Is pg_rewind assuming to use the old master as a new master?

If pg_rewind is used only for a standby server installation,
pg_rewind does not need to get WAL from source server, does it?


Kato Sho


Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2018-02-27 07:47:22 Re: Two small patches for the isolationtester lexer
Previous Message Masahiko Sawada 2018-02-27 07:21:03 Re: [HACKERS] Transactions involving multiple postgres foreign servers