| From: | Thomas Endres <endres(dot)thomas(at)gmail(dot)com> |
|---|---|
| To: | Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Table Replication |
| Date: | 2019-01-29 18:24:41 |
| Message-ID: | 80F654A6-3CB0-4567-A2F8-170611C3FE76@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> 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 <mailto: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 <https://github.com/dimitri/pgloader>>
Best,
Tom Endres
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rene Romero Benavides | 2019-01-29 18:38:38 | Re: type int2vector |
| Previous Message | Stefan Keller | 2019-01-29 18:03:33 | Re: How to set parameters in 'options'? |