Re: Replicate only 1 out of 2 databases of Server A to Server B ?

On Mon, Apr 24, 2017 at 9:33 AM, czezz <czezz(at)o2(dot)pl> wrote:

> Hi all.
>
> PostgreSQL 9.2.18
> Running on replication mode Master-Slave (async).
> Server A (2 databases) is fully replicated to Server B.
> That works OK.
>
> Question:
> Is it possible to replicate only 1 out of 2 databases of Server A to
> Server B?
>

With 9.2, I think your only real solution is to use logical replication:
bucardo, slony, londiste. These tools require a more involved setup and
configuration than streaming replication (they're not built-in).

For 9.4+ you can use pg_logical. It's 'kind of' built in, you will still
need a separate download and separate configuration flow.

All of the above allow you to select to the object (table, sequence)
level. Just be careful, unlike streaming, there are a lot of caveats. For
example, new tables are not auto-replicated, you cannot ALTER TABLE.

--Scott

> Best regards,
> czezz
>

--
--
Scott Mead
Sr. Architect
*OpenSCG <http://openscg.com>*
http://openscg.com