Re: Immediate standby promotion - Mailing list pgsql-hackers

From Fabrízio de Royes Mello
Subject Re: Immediate standby promotion
Date
Msg-id CAFcNs+ofS8aqDN+TbnvZ5JBb2NTfWOo+7uNTF67ebO432W=hHA@mail.gmail.com
Whole thread Raw
In response to Re: Immediate standby promotion  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Immediate standby promotion
List pgsql-hackers
<div dir="ltr"><div class="gmail_extra"><br />On Thu, Aug 14, 2014 at 4:27 PM, Robert Haas <<a
href="mailto:robertmhaas@gmail.com">robertmhaas@gmail.com</a>>wrote:<br />><br />> We already have the
facilitiesto stop replay at a defined place.  But<br /> > then what?  Without this patch, do well tell the customer
tostop<br />> replay, do a pg_dump of the whole database, and restore it into a new<br />> database?  Because
that'scrazy.<br />><br /><br /></div><div class="gmail_extra"> Yeah... and as Fujji already said another case is
whensome operation error occurs in the master (like a wrong "drop database") and we have a time-delayed standby that
canbe used to recover the mistake quickly.<br /></div><div class="gmail_extra"><br /><br />--<br />Fabrízio de Royes
Mello<br/>Consultoria/Coaching PostgreSQL<br />>> Timbira: <a
href="http://www.timbira.com.br">http://www.timbira.com.br</a><br/>>> Blog sobre TI: <a
href="http://fabriziomello.blogspot.com">http://fabriziomello.blogspot.com</a><br/> >> Perfil Linkedin: <a
href="http://br.linkedin.com/in/fabriziomello">http://br.linkedin.com/in/fabriziomello</a><br/>>> Twitter: <a
href="http://twitter.com/fabriziomello">http://twitter.com/fabriziomello</a></div></div>

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: ALTER TABLESPACE MOVE command tag tweak
Next
From: Tomas Vondra
Date:
Subject: Re: 9.5: Memory-bounded HashAgg