Re: Table Replication

From: Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Table Replication
Date: 2019-01-29 14:22:42
Message-ID: CAPfkCSByNJ+X6M9609hH0sSejW_Lp+Lts6Bsx++nutaSAYksfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em ter, 29 de jan de 2019 às 10:24, Sathish Kumar <satcse88(at)gmail(dot)com>
escreveu:
>
> Hi,
>
> We are trying to replicate few tables from one postgresql server to
another server. We are currently using Postgresql 9.5.x, is there any way
to achieve it without Postgresql upgrade.

Yeap... use pglogical [1] extension.

Regards,

[1] https://www.2ndquadrant.com/en/resources/pglogical/

--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josef Machytka 2019-01-29 14:34:23 Re: error when creating logical replication slot
Previous Message Tony Shelver 2019-01-29 13:38:34 Re: Help : Update and insert record based on several value in the parameter