Standby Replication and Replication Delay - Mailing list pgsql-hackers

From Thomas Rosenstein
Subject Standby Replication and Replication Delay
Date
Msg-id 6D2980AB-E00E-451A-9E57-145E6CE47C8F@creamfinance.com
Whole thread Raw
Responses Re: Standby Replication and Replication Delay
List pgsql-hackers
Hi,

so I got two questions:

1) I have multiple Postgresql Standby servers replicating over WAN, and 
I would like to reduce that to a single connection.
Is there a utility that can be put in between and store the wal files 
from the primary and provide it to the standby server, even if they are 
delayed by > 1 day or more (provided there is storage?)

2) These standby servers sometimes run very long queries (2 - 3 hours) 
and at some point the replication stops, because I guess some row 
version which are used are removed on the master.
I do have hot_standby_feedback "on", why does this still happen, 
shouldn't this prevent the removal on the primary and allow replication 
to continue even if queries are active?

Thanks
Thomas



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Add "password_protocol" connection parameter to libpq
Next
From: Tomas Vondra
Date:
Subject: Re: WIP: BRIN multi-range indexes