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

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

Hello,

Thanks for the clarification. Learned something new today. For now, I have
my DC and DR setup done. I will look into pgbackrest for backup options.
Thanks again!

On Thu, Jul 2, 2020 at 9:33 PM Stephen Frost <sfrost(at)snowman(dot)net> wrote:

> Greetings,
>
> * Praveen Kumar K S (praveenssit(at)gmail(dot)com) wrote:
> > But if you look at the output below, 00000001000000000000000D is already
> > 16MB and new WAL are created. As per my understanding,
> > 00000001000000000000000D should have been archived. Am I wrong here ?
>
> Yes, you're wrong- WAL files are re-used and will always be 16MB even if
> they aren't yet completed.
>
> Thanks,
>
> Stephen
>

--

*Regards,*

*K S Praveen KumarM: +91-9986855625 *

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message amit 2020-07-03 06:10:06 RE: [HELP] Issue with standby server using WAL archive
Previous Message Stephen Frost 2020-07-02 16:03:30 Re: [HELP] Issue with standby server using WAL archive