Обсуждение: Replication if single database
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
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
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/