Re: [GENERAL] Move rows from one database to other

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: [GENERAL] Move rows from one database to other
Дата
Msg-id 087effc5-2f30-d98d-dc2a-99f369af4e62@aklaver.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Move rows from one database to other  (Thomas Güttler <guettliml@thomas-guettler.de>)
Список 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.klaver@aklaver.com


В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Move rows from one database to other
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: [GENERAL] Feature request - psql --quote-variable