Postgres Pro
Downloads
Home   >   mailing lists

Thread: Replication if single database

Replication if single database

From
Firthouse banu
Date:
Hello Team,

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 . 


Thanks 

Re: Replication if single database

From
Paul Smith
Date:
You may be able to use something like Bucardo to do that as long as you only need to replicate data changes and not schema changes as well. 

On 21 October 2021 13:13:48 Firthouse banu <penguinsfairy@gmail.com> wrote:

Hello Team,

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 . 


Thanks 



--

Paul Smith Computer Services
Tel: 01484 855800
Vat No: GB 685 6987 53

Re: Replication if single database

From
Simon Riggs
Date:
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/