Making subscribers read only in Postgres 10 logical replication

From: rverghese <riyav(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Making subscribers read only in Postgres 10 logical replication
Date: 2017-10-11 18:18:38
Message-ID: 1507745918875-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2017-10-11 18:26:31 Re: Making subscribers read only in Postgres 10 logical replication
Previous Message Tom Lane 2017-10-11 14:30:21 Re: Why does increasing the precision of a numeric column rewrites the table?