Re: data consolidation: logical replication design considerations

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 16/07/22, Rory Campbell-Lange (rory@xxxxxxxxxxxxxxxxxx) wrote:
> I'd be grateful for some comments on the advisability of using a large
> number of concurrent logical replication publications/subscriptions.
> Below I've set out the current environment and a suggested design.
> Apologies for the length of this email.
...
> * to avoid overloading the existing primary host with many replication
>   slots, it would be wise to implement aggregation on another host 

Looking into this further it appears that a streaming replication secondary can
not act as a logical replication publisher. Is that correct?

Rory





[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux