Home > mailing lists

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

From	Sameer Kumar
Subject	Re: Cascade streaming replication + wal_files - Pgsql 9.2
Date	July 7, 2016 05:17:38
Msg-id	CADp-Sm4XQbacTxdVNAj3xpwp5Re-iRaze=F28Xj2pfinxdANpw@mail.gmail.com Whole thread Raw
In response to	Re: Cascade streaming replication + wal_files - Pgsql 9.2 (Patrick B <patrickbakerbr@gmail.com>)
Responses	Re: Cascade streaming replication + wal_files - Pgsql 9.2 (Patrick B <patrickbakerbr@gmail.com>)
List	pgsql-general

On Thu, 7 Jul 2016, 10:10 a.m. Patrick B, <patrickbakerbr@gmail.com> wrote:

ok...

I'll archive the wal_files locally on slave01,

How? I assume you are planning on doing this with scp/rsync in archive_command in upstream master.

and then send them to slave02 every 10 minutes, for example.

Sounds good. But why? Is it just to have redundunt archives?

On your upstream master you can also use a custom script which inturn would be scp'ing the wals to 2 or 3 servers for archiving purposes

This will be done by rsync or something else.

I'll have still the problem with timeline, and slave02 won't be able to become a master in the future.

No, you should not have a problem. Since rsync will also copy the timeline related files to slave02

Is that right?

Best Regards

Sameer Kumar | DB Solution Architect

ASHNIK PTE. LTD.

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069 533

From: John R Pierce
Date: 07 July 2016, 05:15:12
Subject: Re: Cascade streaming replication + wal_files - Pgsql 9.2

From: Patrick B
Date: 07 July 2016, 05:32:26
Subject: Re: Cascade streaming replication + wal_files - Pgsql 9.2