Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: [ADMIN] Replicate only 1 out of 2 databases of Server A to ServerB ?
Date
Msg-id CAKFQuwYHaVKDiqf9G4uB=sxKg7nJ7TMgQeQoac8HSguhahSCpg@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
Tree view
On Monday, April 24, 2017, 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?


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.

pgsql-admin by date:

Previous
From: John Scalia
Date:
Subject: Re: [ADMIN] Replicate only 1 out of 2 databases of Server A to ServerB ?
Next
From: Scott Mead
Date:
Subject: Re: [ADMIN] Replicate only 1 out of 2 databases of Server A to ServerB ?