| From: | John Scalia <jayknowsunix(at)gmail(dot)com> |
|---|---|
| To: | czezz <czezz(at)o2(dot)pl> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Replicate only 1 out of 2 databases of Server A to Server B ? |
| Date: | 2017-04-24 13:45:22 |
| Message-ID: | CABzCKRDJwUT8-ovOZcaW6-G78kDgh14jr-3d7mm6o_sZvb3SLA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(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?
>
> Best regards,
> czezz
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David G. Johnston | 2017-04-24 13:46:30 | Re: Replicate only 1 out of 2 databases of Server A to Server B ? |
| Previous Message | czezz | 2017-04-24 13:33:04 | Replicate only 1 out of 2 databases of Server A to Server B ? |