Re: [HELP] Issue with standby server using WAL archive - Mailing list pgsql-admin

From Jeff Janes
Subject Re: [HELP] Issue with standby server using WAL archive
Date
Msg-id CAMkU=1yrnu7OoCshf2oA+vi2UK_iJ0zX_aUYSOZgTAso_po77Q@mail.gmail.com
Whole thread Raw
In response to Re: [HELP] Issue with standby server using WAL archive  (Praveen Kumar K S <praveenssit@gmail.com>)
Responses Re: [HELP] Issue with standby server using WAL archive
List pgsql-admin
On Thu, Jul 2, 2020 at 11:44 AM Praveen Kumar K S <praveenssit@gmail.com> wrote:
Hello,

Thanks for your response. I agree with all your suggestions.

At this moment, I'm concerned about the WAL archiving.

I'm seeing below error on pg3 (DR server) in log. Is this expected ?
cp: cannot stat '/mnt/server/archivedir/00000001000000000000000D': No such file or directory

Yes, this is expected.  That file has not been archived yet because the master is not done writing data to it yet.  pg3 will keep retrying the command until the file shows up.
 
Cheers, 

Jeff

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [HELP] Issue with standby server using WAL archive
Next
From: Praveen Kumar K S
Date:
Subject: Re: [HELP] Issue with standby server using WAL archive