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

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Monday, April 24, 2017, czezz <czezz@xxxxx> 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?

Not without third-party software.  Or separating the databases into their own clusters.   You have more logical decoding options since 9.4 though I'm not personally familiar with their use.

David J.