On Tue, Sep 6, 2016 at 7:28 PM, Patrick B <patrickbake...@gmail.com> wrote:
> > > 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 > > John, Yes, Rackspace supports slony. I used to work there and they use slony on their core system. Patrick, You cannot stream directly from 9.2 to 9.4. However, you can just create a separate 9.4 cluster (on a separate port). Then pg_dump from 9.2 in plain format and it will load on 9.4. -- *Melvin Davidson* I reserve the right to fantasize. Whether or not you wish to share my fantasy is entirely up to you.
