Question about timelines
От | Torsten Förtsch |
---|---|
Тема | Question about timelines |
Дата | |
Msg-id | 55B868D3.1090408@gmx.net обсуждение исходный текст |
Ответы |
Re: Question about timelines
|
Список | pgsql-general |
Hi, we have a complex structure of streaming replication (PG 9.3) like: master --> replica1 | +-----> replica2 --> replica21 | +------> replica22 --> replica221 Now I want to retire master and make replica2 the new master: +------> replica1 | replica2 --> replica21 | +------> replica22 --> replica221 replica2 is currently a synchronous replica. If I "promote" replica2 a new timeline is created. Hence, I have to instruct all other replicas to follow that new timeline (recovery_target_timeline = 'latest' in recovery.conf). On the other hand, since replica2 is synchronous it should have all transactions when master is shut down. So, I am thinking do I really need a new timeline? Can't I just remove recovery.conf on replica2 and restart it as a master. The only thing I then have to do is to point replica1 to it. Is that a way to go? If "promoting" is better than why? Thanks, Torsten
В списке pgsql-general по дате отправления: