Re: Postgres UPGRADE from 9.2 to 9.4

On Tue, Sep 6, 2016 at 7:28 PM, Patrick B <patrickbakerbr(at)gmail(dot)com> wrote:

>
>
> 2016-09-07 11:25 GMT+12:00 John R Pierce <pierce(at)hogranch(dot)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.