Re: pg_rewind in contrib

<p dir="ltr"><br /> On Mar 26, 2015 4:20 AM, "Vladimir Borodin" <<a
href="mailto:root@simply.name">root@simply.name</a>>wrote:<br /> ><br /> ><br /> >> 26 марта 2015 г., в
7:32,Michael Paquier <<a href="mailto:michael.paquier@gmail.com">michael.paquier@gmail.com</a>> написал(а):<br />
>><br/> >> On Thu, Mar 26, 2015 at 12:23 PM, Venkata Balaji N <<a
href="mailto:nag1010@gmail.com">nag1010@gmail.com</a>>wrote:<br /> >>><br /> >>> Test 1 :<br />
>>><br/> >>> [...]<br /> >>><br /> >>> If the master is crashed or killed abruptly,
itmay not be possible to do a<br /> >>> rewind. Is my understanding correct ?<br /> >><br /> >><br
/>>> Yep. This is mentioned in the documentation:<br /> >> <a
href="http://www.postgresql.org/docs/devel/static/app-pgrewind.html">http://www.postgresql.org/docs/devel/static/app-pgrewind.html</a><br
/>>> "The target server must shut down cleanly before running pg_rewind».<br /> ><br /> ><br /> > You
canstart old master, wait for crash recovery to complete, stop it cleanly and then use pg_rewind. It works.<br />
><pdir="ltr">Shouldn't we have a flag so it does that automatically if necessary?<p dir="ltr">>><br />
>>>Test 2 :<br /> >>><br /> >>> - On a successfully running streaming replication with one
masterand one<br /> >>> slave, i did a clean shutdown of master<br /> >>> - promoted slave<br />
>>>- performed some operations (data changes) on newly promoted slave and did a<br /> >>> clean
shutdown<br/> >>> - Executed pg_rewind on the old master to sync with the latest changes on<br /> >>>
newmaster. I got the below message<br /> >>><br /> >>> The servers diverged at WAL position
0/A2000098on timeline 1.<br /> >>> No rewind required.<br /> >>><br /> >>> I am not getting
thistoo.<br /> >><br /> >><br /> >> In this case the master WAL visibly did not diverge from the
slaveWAL<br /> >> line. A rewind is done if the master touches new relation pages after<br /> >> the
standbyhas been promoted, and before the master is shutdown.<br /> >> -- <br /> >> Michael<br />
>><br/> >><br /> >> -- <br /> >> Sent via pgsql-hackers mailing list (<a
href="mailto:pgsql-hackers@postgresql.org">pgsql-hackers@postgresql.org</a>)<br/> >> To make changes to your
subscription:<br/> >> <a
href="http://www.postgresql.org/mailpref/pgsql-hackers">http://www.postgresql.org/mailpref/pgsql-hackers</a><br/>
><br/> ><br /> ><br /> > --<br /> > Да пребудет с вами сила…<br /> > <a
href="https://simply.name/ru">https://simply.name/ru</a><br/> ><br />