Re: [HELP] Issue with standby server using WAL archive

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Praveen Kumar K S <praveenssit(at)gmail(dot)com>
Cc: Stephen Frost <sfrost(at)snowman(dot)net>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: [HELP] Issue with standby server using WAL archive
Date: 2020-07-02 15:56:36
Message-ID: CAMkU=1yrnu7OoCshf2oA+vi2UK_iJ0zX_aUYSOZgTAso_po77Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Jul 2, 2020 at 11:44 AM Praveen Kumar K S <praveenssit(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Praveen Kumar K S 2020-07-02 16:02:15 Re: [HELP] Issue with standby server using WAL archive
Previous Message Stephen Frost 2020-07-02 15:54:33 Re: [HELP] Issue with standby server using WAL archive