Re: Support logical replication of global object commands

2023-03-28 Thread Zheng Li
> I think that there are some (possibly) tricky challenges that haven't > been discussed yet to support replicating global objects. > > First, as for publications having global objects (roles, databases, > and tablespaces), but storing them in database specific tables like > pg_publication doesn't

Re: Support logical replication of global object commands

2023-03-27 Thread Masahiko Sawada
Hi, On Tue, Aug 9, 2022 at 5:01 AM Zheng Li wrote: > > Hello, > > Logical replication of DDL commands support is being worked on in [1]. > However, global object commands are quite different from other > non-global object DDL commands and need to be handled differently. For > example, global obje

Re: Support logical replication of global object commands

2023-02-28 Thread Zheng Li
On Fri, Feb 17, 2023 at 4:48 AM Amit Kapila wrote: > > On Fri, Feb 17, 2023 at 10:58 AM Zheng Li wrote: > > > > > > > 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 rep

Re: Support logical replication of global object commands

2023-02-17 Thread Amit Kapila
On Fri, Feb 17, 2023 at 10:58 AM Zheng Li wrote: > > > > > 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. > >

Re: Support logical replication of global object commands

2023-02-16 Thread Zheng Li
> > > 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

Re: Support logical replication of global object commands

2023-02-16 Thread Amit Kapila
On Thu, Feb 16, 2023 at 12:02 PM Amit Kapila wrote: > > On Tue, Aug 30, 2022 at 8:09 AM Zheng Li 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 the

Re: Support logical replication of global object commands

2023-02-15 Thread Amit Kapila
On Tue, Aug 30, 2022 at 8:09 AM Zheng Li 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 so

Re: Support logical replication of global object commands

2022-08-29 Thread Zheng Li
> > 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 worryi

Re: Support logical replication of global object commands

2022-08-16 Thread Amit Kapila
On Tue, Aug 16, 2022 at 11:35 AM Zheng Li wrote: > > > Can we think of relying to send WAL of such DDLs just based on whether > > there is a corresponding publication (ex. publication of ALL OBJECTS)? > > I mean avoid database-specific filtering in decoding for such DDL > > commands but not sure h

Re: Support logical replication of global object commands

2022-08-15 Thread Zheng Li
> Can we think of relying to send WAL of such DDLs just based on whether > there is a corresponding publication (ex. publication of ALL OBJECTS)? > I mean avoid database-specific filtering in decoding for such DDL > commands but not sure how much better it is than the current proposal? I think a p

Re: Support logical replication of global object commands

2022-08-15 Thread Amit Kapila
On Fri, Aug 12, 2022 at 5:41 PM Amit Kapila wrote: > > On Tue, Aug 9, 2022 at 1:31 AM Zheng Li wrote: > > > > Hello, > > > > Logical replication of DDL commands support is being worked on in [1]. > > However, global object commands are quite different from other > > non-global object DDL commands

Re: Support logical replication of global object commands

2022-08-12 Thread Amit Kapila
On Tue, Aug 9, 2022 at 1:31 AM Zheng Li wrote: > > Hello, > > Logical replication of DDL commands support is being worked on in [1]. > However, global object commands are quite different from other > non-global object DDL commands and need to be handled differently. For > example, global object co