Re: migration from 9.4 to 9.6

On 12/6/19 1:38 PM, 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

Choices:

1) Dump/restore.

2) Afore mentioned Slony.

3) The pglogical 
extension(https://www.2ndquadrant.com/en/resources/pglogical/pglogical-docs/). 
The forerunner to the built in logical replication in 10+.

> 
> 
> ------------------------------------------------------------------------
> *From:* Adrian Klaver <adrian.klaver@aklaver.com>
> *Sent:* Friday, December 6, 2019 1:32 PM
> *To:* Julie Nishimura <juliezain@hotmail.com>; 
> pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>; 
> pgsql-general <pgsql-general@postgresql.org>
> *Subject:* Re: migration from 9.4 to 9.6
> On 12/6/19 1:19 PM, Julie Nishimura wrote:
>> Hello there, what would be my best way to migrate 2 tb single database 
>> from cluster 9.4 to another machine on 9.6?
> 
> Not clear if you want to add database to an existing 9.6 cluster or
> create a new 9.6 cluster containing the 9.4 database?
> 
>> 
>> Thank you!
> 
> 
> -- 
> Adrian Klaver
> adrian.klaver@aklaver.com


-- 
Adrian Klaver
adrian.klaver@aklaver.com