Re: Table Replication

You could also use Slony-I

On Tue, Jan 29, 2019 at 12:24 PM Thomas Endres <endres(dot)thomas(at)gmail(dot)com>
wrote:

>
> On Jan 29, 2019, at 8:22 AM, Fabrízio de Royes Mello <
> fabrizio(at)timbira(dot)com(dot)br> wrote:
>
>
>
> 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.
>
>
> I have had success with pgloader when migrating specific tables and/or
> schemas from one machine to another.
> <https://github.com/dimitri/pgloader>
>
>
> Best,
> Tom Endres
>

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