On 3/22/17 08:12, Petr Jelinek wrote: > On 22/03/17 03:38, Peter Eisentraut wrote: >> On 3/20/17 15:10, Petr Jelinek wrote: >>> Hmm but REPLICATION role can do basebackup/consume wal, so how does >>> giving it limited publication access help? Wouldn't we need some >>> SUBSCRIPTION role/grant used instead for logical replication connections >>> instead of REPLICATION for this to make sense? >> >> Since we're splitting up the pg_hba.conf setup for logical and physical >> connections, it would probably not matter. > > Hmm yeah I know about that, I am not quite clear on how that change > affects this.
Well, the explanation for what I had in mind is too complicated to even put into words, so it's probably not a good idea. ;-) -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers