Re: Postgres UPGRADE from 9.2 to 9.4
On Tue, Sep 6, 2016 at 7:28 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
2016-09-07 11:25 GMT+12:00 John R Pierce <pierce@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.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 DMSPatrick
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.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.
В списке pgsql-general по дате отправления: