Search Postgresql Archives

Re: Table Replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



You could also use Slony-I 

On Tue, Jan 29, 2019 at 12:24 PM Thomas Endres <endres.thomas@xxxxxxxxx> wrote:

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



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux