<div dir="ltr">With asyncronous replication if standby server is disconnected, you can work (query, update, insert, delete, ...) in master server. When standby server is connected, then standby server will be synced if time was not long (depending on your configuration).<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Mar 29, 2016 at 7:35 PM, Jose Baez <span dir="ltr"><<a href="mailto:pepote@gmail.com" target="_blank">pepote@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><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>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><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>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">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>