Re: Table Replication - Mailing list pgsql-general

From Thomas Endres
Subject Re: Table Replication
Date
Msg-id 80F654A6-3CB0-4567-A2F8-170611C3FE76@gmail.com
Whole thread Raw
In response to Re: Table Replication  (Fabrízio de Royes Mello <fabrizio@timbira.com.br>)
Responses Re: Table Replication  (Rene Romero Benavides <rene.romero.b@gmail.com>)
List pgsql-general

On Jan 29, 2019, at 8:22 AM, Fabrízio de Royes Mello <fabrizio@timbira.com.br> wrote:



Em ter, 29 de jan de 2019 às 10:24, Sathish Kumar <satcse88@gmail.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.

I have had success with pgloader when migrating specific tables and/or schemas from one machine to another.


Best,
Tom Endres

pgsql-general by date:

Previous
From: Stefan Keller
Date:
Subject: Re: How to set parameters in 'options'?
Next
From: Rene Romero Benavides
Date:
Subject: Re: type int2vector