Re: [GENERAL] Manage slot in logical/pglogical replication - Mailing list pgsql-general

From Scott Marlowe
Subject Re: [GENERAL] Manage slot in logical/pglogical replication
Date
Msg-id CAOR=d=3LCg3vak4rmatDTKGjBNXfog6QUTJCzw-AOJo+TObuZQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Manage slot in logical/pglogical replication  (dpat <denni.pat@gmail.com>)
List pgsql-general
On Mon, Jul 17, 2017 at 7:08 AM, dpat <denni.pat@gmail.com> wrote:
> yes i have estimated pg_xlog but server, some time, writes a lot of WAL file.
> there are some robust alternative to replicate partial database in
> Postgresql over WAN?
> or, what's the best way to realign pglogical replica? pg_dump/restore?.
> i have to find the best way to replicate only some table over internet to
> remote database.

That's been a job for slony in the past. Now pg_logical seems to be
getting ready / is ready to replace it.


pgsql-general by date:

Previous
From: armand pirvu
Date:
Subject: Re: [GENERAL] upsert and update filtering
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Partitioned TEMP tables