On Thu, 7 Jul 2016, 10:32 a.m. Patrick B, <patrickbakerbr@xxxxxxxxx> wrote:
The slave02 server will be a copy of the DB into Amazon. There will be a migration to Amazon in the future, and the company's managers want a copy of the current DB there to test and do all the stuffs they need (migrating to 9.5, too).
Have you checked out Amazon's DMS?
slave01 is already working as a streaming replication server.The master server sends the wal_files to slave01 by archive_command.The plan below isn't my idea, I would do different but isn't my call:
Been there :)
Current scenario:master stores wal_files into slave01slave02 does not existsThe plan is:1. setup slave02 at amazon EC2 (just for testing and future master server for devs)
Is it EC2 Classic? Or is it EC2 Virtual Pvt Cloud (VPC)?
2. setup postgres on slave02 (9.2)3. pg_basebackup will be run from slave01. This will split the base in files of 50GB each (example)4. Send the splitted files from slave01 to slave025. restore/join the files6. start postgres on the slave02 slave7. restore the DB using the wal_files from slave01
Given that slave02 is a standby, how do you plan on doing your regression testing? It will be just a read only database.
You can restore the wal_file by specifying resotre_command to copy from the archive generated by the master (rsync or scp to pull from your in-premise setup to EC2). This would be fairly simple if you are using VPC
Question:
Is possible to make slave01 archive the wal_files?
If you really can not just live with archive generated on master itself, you need to try the options discussed up thread.
1. Copy the archives generated on master to a shared location or may be copy it to S3 bucket
2. Archive generated on master is rsync (schedule basis) to EC2
3. pg_receivexlog running on EC2 to copy WAL from slave01
can just be a archive_command and archive_mode = on?
Setting these parameters on slave02 will have not any effect.
--
--
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
