On Thu, 7 Jul 2016, 10:10 a.m. Patrick B, <patrickbakerbr@xxxxxxxxx> 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
T: +65 6438 3504 | M: +65 8110 0350 | www.ashnik.com
