Hi Greg, Here I want my replication to be bidirectional for some table an unidirectional for other. So I have manage to write a trigger that block all the DML for a table but I still need to now if the DML is sent in the local client or the distant client in order to decide to run the trigger or not.
Regards. djibril -----Message d'origine----- De : Greg Sabino Mullane [mailto:[email protected]] Envoyé : lundi 5 octobre 2015 02:24 À : Djibril DIONE Cc : [email protected] Objet : Re: [Bucardo-general] Bucardo Master and loking slave config On Fri, Oct 02, 2015 at 10:47:55AM +0200, Djibril DIONE wrote: ... > - So I Want to know if there is a way to set up a Master-Slave > replication where the slave will be locked in Read only (only SELECT > statement) You can set an entire database as read only like so: ALTER DATABASE mydb SET DEFAULT_TRANSACTION_READ_ONLY = ON; -- Greg Sabino Mullane [email protected] End Point Corporation PGP Key: 0x14964AC8 _______________________________________________ Bucardo-general mailing list [email protected] https://mail.endcrypt.com/mailman/listinfo/bucardo-general
