2016-09-07 11:25 GMT+12:00 John R Pierce <pierce@xxxxxxxxxxxx>:
On 9/6/2016 4:20 PM, Melvin Davidson wrote:
If you use slony to replicate, you CAN have 9.2 on the master and 9.4 on the slave.
does rackspace support slony? how about amazon dms ?
slony requires configuring replication on each table. if the database has a large complex schema this could take considerable setup effort.
I'm not using slony.... I'm using the default streaming replication postgres 9.2 tool.
I'm setting up a postgres 9.2 master and a 9.4 streaming replication slave atm...
will dump the DB on the 9.2 and restore it into the 9.4 to see if that can be done.
I don't intend to upgrade both master and slaves on my current production scenario just to be able to use DMS
Patrick
