Re: pg_basebackup on slave running for a long time

So, the question here is while I apply update on Slave, how do I know
if if it will be able to catch up or I need Wal archive? Is there a
way I can determine this? In my case, while applying update on slave,
the db process will be stopped, so the query, even if it gives correct
value, won't help. Can anybody help in here?

On Mon, Nov 21, 2016 at 12:40 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
> On 11/20/2016 11:00 PM, Subhankar Chattopadhyay wrote:
>
> Yes so if the slave is behind I need to start over pgbasebackup. I saw
> according to the documentation this query gives us the replication state.
> Can somebody tell me if this would be sufficient to know if I need to start
> over the backup ?
>
>
>
>
> if the slave is behind but is catching up, no, restarting replication would
> be overkill. only if the slave gets so far behind that it can't catch up,
> and in that case, a wal archive would be a better choice than a new base
> backup.
>
> I've never run into these problems as I run on dedicated hardware servers,
> which don't have all these reliability and performance problems. a
> complete server failure requiring a full rebuild is something that would
> happen less than annually.
>
>
>
> --
> john r pierce, recycling bits in santa cruz

--

Subhankar Chattopadhyay
Bangalore, India