Re: Standby Mechanics: WAL vs Streaming

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Don Seiler <don(at)seiler(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org, MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
Subject: Re: Standby Mechanics: WAL vs Streaming
Date: 2017-08-28 05:16:49
Message-ID: CAECtzeUbYCjM1KuCuo641fXLO9nE0ems9wu6jdM0RfPF_Yn=oA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Le 28 août 2017 6:52 AM, "Don Seiler" <don(at)seiler(dot)us> a écrit :

So, that's kind of simple:
* first replaying archived WAL
* when no more archived WAL, streaming
* when error, back to WAL replay

After this last scenario, will the standby periodically retry to connect to
the primary to resume streaming replication? It will it at least try it it
runs out of WAL files?

It will resume streaming when it runs out of WAL files to replay.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Don Seiler 2017-08-28 13:40:27 Re: Standby Mechanics: WAL vs Streaming
Previous Message Don Seiler 2017-08-28 04:52:28 Re: Standby Mechanics: WAL vs Streaming