Re: Table Replication

2019-01-29 Thread Rene Romero Benavides 
You could also use Slony-I

On Tue, Jan 29, 2019 at 12:24 PM Thomas Endres 
wrote:

>
> On Jan 29, 2019, at 8:22 AM, Fabrízio de Royes Mello <
> fabri...@timbira.com.br> wrote:
>
>
>
> Em ter, 29 de jan de 2019 às 10:24, Sathish Kumar 
> 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
>


-- 
El genio es 1% inspiración y 99% transpiración.
Thomas Alva Edison
http://pglearn.blogspot.mx/

Re: Table Replication

2019-01-29 Thread Thomas Endres 

> On Jan 29, 2019, at 8:22 AM, Fabrízio de Royes Mello 
>  wrote:
> 
> 
> 
> Em ter, 29 de jan de 2019 às 10:24, Sathish Kumar  > 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

Re: Table Replication

2019-01-29 Thread Fabrízio de Royes Mello 
Em ter, 29 de jan de 2019 às 10:24, Sathish Kumar 
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

Table Replication

2019-01-29 Thread Sathish Kumar 
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.