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

[John Scalia <jayknowsunix@xxxxxxxxx>]

Yes, that is possible through PostgreSQL's logical replication system. It sounds like, however, you're using streaming replication and that cannot replicate just one database from the master cluster. So, you'll have to change your mechanism. Suggest you look at configuring logical replication.
--

Jay

On Mon, Apr 24, 2017 at 9:33 AM, 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?

Best regards,

czezz