[Bucardo-general] Bucardo Master and loking slave config
Djibril DIONE
dione.djibril at gmail.com
Mon Oct 5 07:33:54 UTC 2015
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:greg at endpoint.com]
Envoyé : lundi 5 octobre 2015 02:24
À : Djibril DIONE
Cc : bucardo-general at bucardo.org
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 greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
More information about the Bucardo-general
mailing list