From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Move rows from one database to other |
Date: | 2017-02-21 17:52:28 |
Message-ID: | 087effc5-2f30-d98d-dc2a-99f369af4e62@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 02/21/2017 08:06 AM, Thomas Güttler wrote:
>
>
> Am 21.02.2017 um 15:27 schrieb William Ivanski:
>> You can try OmniDB: http://www.omnidb.com.br/en_index.aspx
>>
>> OmniDB has a Convert feature, where you can set a data transfer, even
>> if the target table exists.
>
> I am unsure if omnidb is the right tool here.
>
> I don't need a GUI. The movement of the rows should happen in background.
Given the versions of Postgres you are using there is logical replication:
https://www.postgresql.org/docs/9.5/static/protocol-replication.html
https://2ndquadrant.com/en/resources/pglogical/
"AGGREGATE - Accumulate changes from sharded database servers into a
Data Warehouse"
I have not used this capability yet, so others would have to comment on
its applicability.
>
> Regards,
> Thomas Güttler
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2017-02-21 18:34:49 | Re: Feature request - psql --quote-variable |
Previous Message | Adrian Klaver | 2017-02-21 17:45:49 | Re: Move rows from one database to other |