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.kla...@aklaver.com>
*Sent:* Friday, December 6, 2019 1:32 PM
*To:* Julie Nishimura <juliez...@hotmail.com>;
pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>;
pgsql-general <pgsql-gene...@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.kla...@aklaver.com
--
Adrian Klaver
adrian.kla...@aklaver.com
