Re: [ADMIN] Replicate only 1 out of 2 databases of Server A to ServerB ? - Mailing list pgsql-admin

From John Scalia
Subject Re: [ADMIN] Replicate only 1 out of 2 databases of Server A to ServerB ?
Date
Msg-id CABzCKRDJwUT8-ovOZcaW6-G78kDgh14jr-3d7mm6o_sZvb3SLA@mail.gmail.com
Whole thread Raw
In response to [ADMIN] Replicate only 1 out of 2 databases of Server A to Server B ?  (czezz <czezz@o2.pl>)
List pgsql-admin
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@o2.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?

Best regards,
czezz

pgsql-admin by date:

Previous
From: czezz
Date:
Subject: [ADMIN] Replicate only 1 out of 2 databases of Server A to Server B ?
Next
From: "David G. Johnston"
Date:
Subject: Re: [ADMIN] Replicate only 1 out of 2 databases of Server A to ServerB ?