Re: Cascade streaming replication + wal_files - Pgsql 9.2 - Mailing list pgsql-general

From John R Pierce
Subject Re: Cascade streaming replication + wal_files - Pgsql 9.2
Date
Msg-id 7c6f29b5-2e0d-c4fe-dd05-c4cec1e8d3b5@hogranch.com
Whole thread Raw
In response to Re: Cascade streaming replication + wal_files - Pgsql 9.2  (Sameer Kumar <sameer.kumar@ashnik.com>)
Responses Re: Cascade streaming replication + wal_files - Pgsql 9.2
Re: Cascade streaming replication + wal_files - Pgsql 9.2
List pgsql-general
On 7/6/2016 6:52 PM, Sameer Kumar wrote:

the only way to archive the wal_files from a slave into another slave on PostgreSQL 9.2, is by using pg_reveivexlog?

Yes. Though I have never tried this myself but going by the theory, it should work.

a slave doesn't generate wal_files at all.

if your master is keeping a wal_archive, slaves, including cascaded streaming slaves, can all use that same archive as their wal source, these are only used for catchup when streaming is interrupted.   





-- 
john r pierce, recycling bits in santa cruz

pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: Re: Cascade streaming replication + wal_files - Pgsql 9.2
Next
From: Patrick B
Date:
Subject: Re: Cascade streaming replication + wal_files - Pgsql 9.2