Standby Replication and Replication Delay

From: "Thomas Rosenstein" <thomas(dot)rosenstein(at)creamfinance(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Standby Replication and Replication Delay
Date: 2019-09-14 16:03:34
Message-ID: 6D2980AB-E00E-451A-9E57-145E6CE47C8F@creamfinance.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2019-09-14 17:30:49 Re: WIP: BRIN multi-range indexes
Previous Message Jeff Davis 2019-09-14 15:42:53 Re: Add "password_protocol" connection parameter to libpq