Search Postgresql Archives

Re: migration from 9.4 to 9.6

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, 2019-12-06 at 21:38 +0000, Julie Nishimura wrote:
I'd like to copy one single database from 9.4 cluster to a new 9.6 cluster (migration with the upgrade), to the different host


Put 9.4 on the new server. Replicate the db to it. When you're ready to switch, shut down the master, promote the new db, and then shut it down and pg_upgrade -k it to 9.6.

That does require the binaries from both versions to be on the new server for a while, but it'll give you the least downtime and it's a very simple replication setup.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux