From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Julie Nishimura <juliezain(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: migration from 9.4 to 9.6 |
Date: | 2019-12-06 22:02:26 |
Message-ID: | ef6827d6-a93f-c1b5-a092-eeda66306ec7@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com>
> *Sent:* Friday, December 6, 2019 1:32 PM
> *To:* Julie Nishimura <juliezain(at)hotmail(dot)com>;
> pgsql-general(at)lists(dot)postgresql(dot)org <pgsql-general(at)lists(dot)postgresql(dot)org>;
> pgsql-general <pgsql-general(at)postgresql(dot)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(dot)klaver(at)aklaver(dot)com
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Alan Hodgson | 2019-12-06 22:07:01 | Re: migration from 9.4 to 9.6 |
Previous Message | Julie Nishimura | 2019-12-06 21:38:05 | Re: migration from 9.4 to 9.6 |