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
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 |