Search Postgresql Archives

Sv: Re: Logical decoding on standby

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

 



På tirsdag 13. mars 2018 kl. 01:08:03, skrev Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx>:
On 13 March 2018 00:58:27 CET, Andreas Kretschmer <andreas@xxxxxxxxxxxxxxx> wrote:
>On 12 March 2018 21:18:22 CET, Andreas Joseph Krogh
><andreas@xxxxxxxxxx> wrote:
>>Anybody knows if $subject will make it into v11?
>> 
>>--
>>Andreas Joseph Krogh
>
>Why do you think you needs this?
>
>Regards, Andreas

Let me explain my question. One of the key aspects of logical replication is, that you can define what to replicate. That wouldn't work in this way, that's why i'm asking.

Regards, Andreas
 
I have streaming-replication of a cluster containing many databases to a standby-server. I need a reporting-server which only needs a subset of some (large) tables of one database and am planning to use the built-in logical replication for that. It is my understanding that logical replication will cause more wal-traffic so I'm trying to offload wal-traffic from the primary. I thought using logical replication from the standby would help with that but realized it's not supported in v10. Im I wrong in planning this way?
 
--
Andreas Joseph Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
andreas@xxxxxxxxxx
www.visena.com
 

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux