Postgres Pro
Downloads
Home   >   mailing lists

Re: Replication if single database - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Replication if single database
Date
Msg-id CANbhV-EjRHqfRS6RrtzpFsNbqcXa0YaH5zzCwAobbTCNs-2bOg@mail.gmail.com
Whole thread Raw
In response to Replication if single database  (Firthouse banu <penguinsfairy@gmail.com>)
List pgsql-admin
Tree view 
On Thu, 21 Oct 2021 at 13:13, Firthouse banu <penguinsfairy@gmail.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/

pgsql-admin by date:

Previous
From: Paul Smith
Date:
Subject: Re: Replication if single database
Next
From: Simon Riggs
Date:
Subject: Re: Can I make logical replication behave like synchronous streaming?