<p dir="ltr">Le 10 nov. 2015 2:03 PM, "TOINEL, Ludovic" <<a href="mailto:ludovic.toinel@capgemini.com">ludovic.toinel@capgemini.com</a>> a écrit :<br>
><br>
> Thanks Andrew,<br>
><br>
> We are not allowed to have network connection from the slaves to the master (for security constraints). Only master can communicate with slaves.<br>
> We need database on slaves with mix replicates tables and read/write tables.<br>
><br>
> The solution could be maybe that solution using a slony master has an Hot standby of a master protected somewhere ?<br>
><br>
> [slony slaves] <-----> [slony master - Standby node] <----(log shipping)--|firewall|-- [master protected somewhere]<br>
><br>
> Do you think this solution can work with slony ?<br>
></p>
<p dir="ltr">This will work as long as you don't try to execute write queries on the slony master, because it's a standby node and, as such, can only execute read queries. Meaning I'm wondering why you would use such a scheme.</p>
<p dir="ltr">> Regards,<br>
><br>
> Ludovic Toinel<br>
><br>
> -----Message d'origine-----<br>
> De : <a href="mailto:slony1-general-bounces@lists.slony.info">slony1-general-bounces@lists.slony.info</a> [mailto:<a href="mailto:slony1-general-bounces@lists.slony.info">slony1-general-bounces@lists.slony.info</a>] De la part de Andrew Sullivan<br>
> Envoyé : mardi 10 novembre 2015 12:26<br>
> À : <a href="mailto:slony1-general@lists.slony.info">slony1-general@lists.slony.info</a><br>
> Objet : Re: [Slony1-general] Network connection from slaves to the master<br>
><br>
> On Tue, Nov 10, 2015 at 09:51:29AM +0000, TOINEL, Ludovic wrote:<br>
> > The network allows only flows from master to slaves.<br>
> ><br>
> > Is there any option that I missed to do that ?<br>
><br>
> Not really. In principle you could do this with the log shipping mode, but I don't recall whether doing that on the master was not possible or just a really bad idea. (You could do this with the built-in standby mechanisms of Postgres, though.<br>
><br>
> I do wonder why you have it set up this way, however. Why do you control the flows this way?<br>
><br>
> A<br>
><br>
> --<br>
> Andrew Sullivan<br>
> <a href="mailto:ajs@crankycanuck.ca">ajs@crankycanuck.ca</a><br>
> _______________________________________________<br>
> Slony1-general mailing list<br>
> <a href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br>
> <a href="http://lists.slony.info/mailman/listinfo/slony1-general">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
> _______________________________________________<br>
> Slony1-general mailing list<br>
> <a href="mailto:Slony1-general@lists.slony.info">Slony1-general@lists.slony.info</a><br>
> <a href="http://lists.slony.info/mailman/listinfo/slony1-general">http://lists.slony.info/mailman/listinfo/slony1-general</a><br>
</p>