Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Making subscribers read only in Postgres 10 logical replication - Mailing list pgsql-general

From rverghese
Subject [GENERAL] Making subscribers read only in Postgres 10 logical replication
Date
Msg-id 1507745918875-0.post@n3.nabble.com
Whole thread Raw
Responses Re: [GENERAL] Making subscribers read only in Postgres 10 logicalreplication  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: [GENERAL] Making subscribers read only in Postgres 10 logicalreplication  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-general
Tree view 
Hi
I'm testing out logical replication on PostgreSQL 10. Is there a setting to
make subscribers read-only slaves like with Slony. Currently I can insert
into the Publisher and the Subscriber. If there is a conflict, i.e. same
record exists in both, then all replication gets backed up (even to other
tables) till that one record is resolved.

Thanks
RV



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Why does increasing the precision of a numeric column rewrites the table?
Next
From: "Joshua D. Drake"
Date:
Subject: Re: [GENERAL] Making subscribers read only in Postgres 10 logicalreplication