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.