| From: | Simon Riggs <simon(dot)riggs(at)enterprisedb(dot)com> |
|---|---|
| To: | Firthouse banu <penguinsfairy(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Replication if single database |
| Date: | 2021-10-21 13:13:54 |
| Message-ID: | CANbhV-EjRHqfRS6RrtzpFsNbqcXa0YaH5zzCwAobbTCNs-2bOg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Thu, 21 Oct 2021 at 13:13, Firthouse banu <penguinsfairy(at)gmail(dot)com> wrote:
> Is there a possibility to replicate only one database from a server to another server ?
> Whatever we do in master should be applied to slave as well. But for only one database .
Logical replication, using one of these flavours, works well for this case:
* Built-in Publication/Subscription
* pglogical
* BDR
--
Simon Riggs http://www.EnterpriseDB.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2021-10-21 13:18:29 | Re: Can I make logical replication behave like synchronous streaming? |
| Previous Message | Paul Smith | 2021-10-21 12:36:24 | Re: Replication if single database |