[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Manage slot in logical/pglogical replication
From:       Scott Marlowe <scott.marlowe () gmail ! com>
Date:       2017-07-31 21:55:14
Message-ID: CAOR=d=3LCg3vak4rmatDTKGjBNXfog6QUTJCzw-AOJo+TObuZQ () mail ! gmail ! com
[Download RAW message or body]

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.


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
[prev in list] [next in list] [prev in thread] [next in thread]