Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Making subscribers read only in Postgres 10 logicalreplication - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: [GENERAL] Making subscribers read only in Postgres 10 logicalreplication
Date
Msg-id 78a90d61-502b-20f8-6c5a-727b0a885289@commandprompt.com
Whole thread Raw
In response to [GENERAL] Making subscribers read only in Postgres 10 logical replication  (rverghese <riyav@hotmail.com>)
Responses Re: [GENERAL] Making subscribers read only in Postgres 10 logical replication  (rverghese <riyav@hotmail.com>)
List pgsql-general
Tree view 
On 10/11/2017 11:18 AM, rverghese wrote:
> 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.

GRANT?

JD



-- 
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc

PostgreSQL Centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://pgconf.us
*****     Unless otherwise stated, opinions are my own.   *****


-- 
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: rverghese
Date:
Subject: [GENERAL] Making subscribers read only in Postgres 10 logical replication
Next
From: rverghese
Date:
Subject: Re: [GENERAL] Making subscribers read only in Postgres 10 logical replication