On 11/10/2015 08:03 AM, TOINEL, Ludovic wrote: > Thanks Andrew, > > We are not allowed to have network connection from the slaves to the master > (for security constraints). Only master can communicate with slaves. > We need database on slaves with mix replicates tables and read/write tables.
I presume that this is a restriction on your routers or gateways and that the initiating SYN packet for a new TCP connection cannot come from what you envision to be the Slave. If that is correct, you can run all the slon daemons on what you consider the Master. All TCP connections are then initiated from the Master. This has little to no effect on how Slony functions. Regards, Jan > > The solution could be maybe that solution using a slony master has an Hot > standby of a master protected somewhere ? > > [slony slaves] <-----> [slony master - Standby node] <----(log > shipping)--|firewall|-- [master protected somewhere] > > Do you think this solution can work with slony ? > > Regards, > > Ludovic Toinel > > -----Message d'origine----- > De : slony1-general-boun...@lists.slony.info > [mailto:slony1-general-boun...@lists.slony.info] De la part de Andrew Sullivan > Envoyé : mardi 10 novembre 2015 12:26 > À : slony1-general@lists.slony.info > Objet : Re: [Slony1-general] Network connection from slaves to the master > > On Tue, Nov 10, 2015 at 09:51:29AM +0000, TOINEL, Ludovic wrote: >> The network allows only flows from master to slaves. >> >> Is there any option that I missed to do that ? > > 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. > > I do wonder why you have it set up this way, however. Why do you control the > flows this way? > > A > > -- > Andrew Sullivan > a...@crankycanuck.ca > _______________________________________________ > Slony1-general mailing list > Slony1-general@lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > _______________________________________________ > Slony1-general mailing list > Slony1-general@lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general > -- Jan Wieck Senior Software Engineer http://slony.info _______________________________________________ Slony1-general mailing list Slony1-general@lists.slony.info http://lists.slony.info/mailman/listinfo/slony1-general
