<div dir="ltr"><div><span style="font-size:12.8px"><i>"your data must be in two servers at least"</i></span><br></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Hmmm... I didn't get that point of view. It sounds reasonable. :))</span></div><div><span style="font-size:12.8px"><br></span></div><div>Thank you!<br></div><div><br></div></div><div class="gmail_extra"><br><div class="gmail_quote">On 29 March 2016 at 18:30, Lucas Luengas <span dir="ltr"><<a href="mailto:lucasluengas@gmail.com" target="_blank">lucasluengas@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div><div><div>Hello.<br><br></div>I think that is not possible. I think you can read data from master node, but you can't update, insert, delete data. <br><br></div>You can try to configure multiple standby servers in "synchronous_standby_names".<br>The documentations says:<br><br><a href="http://www.postgresql.org/docs/9.4/static/runtime-config-replication.html" target="_blank">http://www.postgresql.org/docs/9.4/static/runtime-config-replication.html</a><br><br>... If the current synchronous standby disconnects for whatever reason, it will be replaced immediately with the next-highest-priority standby. Specifying more than one standby name can allow very high availability.<br><br></div>I think if you use synchronous replication is you need your data must be in two servers at least.<br><br></div>Regards.<br></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="h5">On Tue, Mar 29, 2016 at 10:51 AM, Jose Baez <span dir="ltr"><<a href="mailto:pepote@gmail.com" target="_blank">pepote@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5"><div dir="ltr">Hi, everyone!<div><br></div><div>In a synchronous Streaming replic<font face="arial, helvetica, sans-serif" color="#000000">ation (activating "<span style="font-size:12px;white-space:pre-wrap;background-color:transparent"><i>synchronous_standby_names</i>" in PostgreSQL 9.4 or higher</span>) is there any solution/workaround to handle a standby server disconnection and keep working with the master node?</font></div><div><font face="arial, helvetica, sans-serif" color="#000000"><br></font></div><div><br></div><div>Thanks.</div><div><br></div><div><br></div></div>
<br></div></div>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net" target="_blank">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>
</blockquote></div><br></div>