Re: Important lag in replication streaming between master and standby

soumitra bhandary <[email protected]>
Newsgroups gmane.comp.db.postgresql.admin
Message-ID <BMXPR01MB36396E8CF476E66D72D84F9CE0A10@BMXPR01MB3639.INDPRD01.PROD.OUTLOOK.COM> 
Hi Mai,

It seems that the wal log requested by slave is not available in master’s wal directory. 
In that case if the DB is archival mode the same wal can be found there and configure slave accordingly so that it can read wal from archive location.


Sent from my iPhone

> On 26-Aug-2019, at 8:51 PM, Mai Peng <[email protected]> wrote:
> 
> Hello,
> 
> I’ve got several times this error : "requested WAL segment 000000020000A01A0000004F has already been remove". I think it’s due to the lag between our master in EU zone and our standby in US zone.
> How could we configure Postgres to handle this issue?
> Thx a lot
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.