[Bucardo-general] Bucardo Master and loking slave config

[Greg Sabino Mullane]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20151004/4f58a7e1/attachment.sig>