Re: Streaming replication failover process - Pgsql 9.2

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Patrick B <patrickbakerbr(at)gmail(dot)com>
Cc: John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Streaming replication failover process - Pgsql 9.2
Date: 2016-07-11 04:07:20
Message-ID: 5f189f6d-13ea-3b26-6474-e18f9e5e360d@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 07/10/2016 07:17 PM, Patrick B wrote:
> If the master server can't send the wal_files through the slaves,
> shouldn't the wal_files be in "background" waiting to be delivered?

Short version, yes, assuming you are talking about archiving the WAL
files somewhere and assuming there is sufficient space for the quantity
of WAL files stored on what ever 'device' you are storing them on.

Long version and, I would say, required reading:

https://www.postgresql.org/docs/9.2/static/high-availability.html

>
> Otherwise what's the purpose of them? If a network fails I'd loose those
> files?
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christian Castelli 2016-07-11 06:51:40 Re: RHEL 7
Previous Message John R Pierce 2016-07-11 03:58:55 Re: Streaming replication failover process - Pgsql 9.2