Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mdXOn-00084O-O6 for pgsql-admin@arkaria.postgresql.org; Thu, 21 Oct 2021 12:42:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mdXOm-000394-Jw for pgsql-admin@arkaria.postgresql.org; Thu, 21 Oct 2021 12:42:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mdXOm-00038v-7S for pgsql-admin@lists.postgresql.org; Thu, 21 Oct 2021 12:42:20 +0000 Received: from mail.pscs.co.uk ([178.159.9.185]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mdXOj-00045E-BW for pgsql-admin@lists.postgresql.org; Thu, 21 Oct 2021 12:42:19 +0000 Authentication-Results: mail.pscs.co.uk; spf=none; auth=pass (cram-md5) smtp.auth=pscs Received: from lmail.pscs.co.uk ([192.168.150.1]) by mail.pscs.co.uk ([192.168.150.185] running VPOP3) with ESMTPSA (TLSv1.3 TLS_AES_256_GCM_SHA384); Thu, 21 Oct 2021 13:42:14 +0100 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pscs.co.uk; q=dns/txt; s=lmail; h=From:To:Date:Message-ID:In-Reply-To:References:Subject:MIME-Version :Content-Type:Cc:Content-Transfer-Encoding:Reply-to:Sender; t=1634819785; x=1635424585; bh=qE4jl/mdlVEhbKuNMoSz8Ug5dcShlLKBogka0ZgyvrI=; b=JBAzMQ1lldTQMhJFsbAwk5p6nycACXBZIqZtLgA1f3jPusAH2dFb9sOcqgIl+SSvxD6XVPZp caAIMd1Qvb20Cb8oYQdXXL4po+LiLY3L/DsPERBn8i2Qeu4v0XtsSIBJTsAsmCZ0wJv7aZO1kn ELKfOGVWoHJHEhzkXdA1AMTyk= Authentication-Results: lmail.pscs.co.uk; spf=none; auth=pass (plain) smtp.auth=paul Received: from [10.149.83.48] ([82.132.233.55] (82-132-233-55.dab.02.net)) by lmail.pscs.co.uk ([192.168.150.70] running VPOP3) with ESMTPSA (TLSv1.2 ECDHE-RSA-AES256-GCM-SHA384); Thu, 21 Oct 2021 13:36:25 +0100 From: Paul Smith To: Firthouse banu , Date: Thu, 21 Oct 2021 13:36:24 +0100 Message-ID: <17ca2da3958.28d4.9bfe8bcc586ac955e423c0e3d5444448@pscs.co.uk> In-Reply-To: References: User-Agent: AquaMail/1.31.0-1857 (build: 103101002) Subject: Re: Replication if single database MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="17ca2da3d554bd328d47c7e63d" X-Authenticated-Sender: paul X-Server: VPOP3 Enterprise V8.2 - Registered X-Organisation: Paul Smith Computer Services X-VPOP3Tester: 12 345 X-Authenticated-Sender: pscs List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --17ca2da3d554bd328d47c7e63d Content-Type: text/plain; format=flowed; charset="us-ascii" Content-Transfer-Encoding: 8bit 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 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 Sign up for news & updates at http://www.pscs.co.uk/go/subscribe --17ca2da3d554bd328d47c7e63d Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable
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@gma= il.com> wrote:

Hello Team,

Is there a possib= ility to replicate only one database from a server to another server ?&nbs= p;
Whatever we do in master should be applied to sl= ave as well. But for only one database . 

=

Thanks 



=09 =09
--

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

=09 =09
--17ca2da3d554bd328d47c7e63d--