2016-09-07 11:25 GMT+12:00 John R Pierce <pie...@hogranch.com>: > 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. > <http://www.postgresql.org/mailpref/pgsql-general> >
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
