Re: Postgres UPGRADE from 9.2 to 9.4

[Melvin Davidson <melvin6925@xxxxxxxxx>]

On Tue, Sep 6, 2016 at 7:28 PM, Patrick B <patrickbakerbr@xxxxxxxxx> wrote:

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 

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.