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.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
