On Tue, Aug 30, 2022 at 8:09 AM Zheng Li <zhengl...@gmail.com> wrote: > > > > I think a publication of ALL OBJECTS sounds intuitive. Does it mean we'll > > > publish all DDL commands, all commit and abort operations in every > > > database if there is such publication of ALL OBJECTS? > > > > > > > Actually, I intend something for global objects. But the main thing > > that is worrying me about this is that we don't have a clean way to > > untie global object replication from database-specific object > > replication. > > I think ultimately we need a clean and efficient way to publish (and > subscribe to) any changes in all databases, preferably in one logical > replication slot. >
Agreed. I was thinking currently for logical replication both walsender and slot are database-specific. So we need a way to distinguish the WAL for global objects and then avoid filtering based on the slot's database during decoding. I also thought about whether we want to have a WALSender that is not connected to a database for the replication of global objects but I couldn't come up with a reason for doing so. Do you have any thoughts on this matter? -- With Regards, Amit Kapila.
