CC
On Mon, Nov 11, 2024 at 09:28 Greg Sabino Mullane
wrote:
> Some of those requirements are vague, but yes, Patroni should probably be
> the first approach you look at. If the second datacenter is just for
> redundancy, then a simple setup would be:
>
> DCA (data center A):
> Postgres server 1
me is that why does logical apply being so slower
than physical apply (and also apparently physical streaming never
times out!)
On Tue, Feb 7, 2023 at 9:13 PM sunyuc...@gmail.com wrote:
>
> ccing the mailist again in case someone else would have a idea how to debug:
>
> Here is what I see
e: 0.000 ms
avg read rate: 0.000 MB/s, avg write rate: 0.000 MB/s
buffer usage: 164212 hits, 0 misses, 0 dirtied
WAL usage: 0 records, 0 full page images, 0 bytes
system usage: CPU: user: 0.27 s, system: 0.00 s, elapsed: 0.27 s
Thanks
On Tue, Feb 7, 2023 at 6:10 PM sunyuc...@gmail.com wrote:
>
Hi Justin, thanks for the response!
> REPLICA IDENTITY DEFAULT will only use primary keys, if the publisher
> includes those tables, the subscriber when replaying the WAL will stop
> throwing an error not knowing how to replay the UPDATE/DELETE.
But I don't see any errors being thrown out
x27;m
abit confused since the doc mentioned that that means it is using PK,
does that mean it is using FULL?
Cheers.
On Tue, Feb 7, 2023 at 4:20 PM Justin wrote:
>
>
> On Tue, Feb 7, 2023 at 6:38 PM sunyuc...@gmail.com
> wrote:
>>
>> Hi there,
>>
>> I am usin
