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 1lt7oq-0006rQ-93 for pgsql-performance@arkaria.postgresql.org; Tue, 15 Jun 2021 12:05:24 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lt7op-0006eU-5O for pgsql-performance@arkaria.postgresql.org; Tue, 15 Jun 2021 12:05:23 +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 1lt7oo-0006eM-NW for pgsql-performance@lists.postgresql.org; Tue, 15 Jun 2021 12:05:22 +0000 Received: from campbell-lange.net ([178.79.140.51]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lt7ol-0002LY-Rp for pgsql-performance@lists.postgresql.org; Tue, 15 Jun 2021 12:05:22 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=campbell-lange.net; s=it; h=In-Reply-To:Content-Type:MIME-Version: References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To: Content-Transfer-Encoding:Content-ID:Content-Description:Resent-Date: Resent-From:Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id: List-Help:List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=dVOKnVMuPvOgz/n1nCX5bZoIRn5KwApq8qIOrKdi6E8=; b=k/RPKpjt9bIHs860ijaoJs3EY awXXFOH8G7RxYb4LlwXgt1Pd4IY175DRU1+wOuUhTQmxxhDPDpwi7ATXRGYssBpdNG/vk7i6EEBdv UurDwoW193rtaX/AN6M7YzA482u1MwofZ/BhEBLkplI053/kqaXPVzBi+kxExA8qENTs4=; Received: from [217.138.52.158] (helo=rory-t470s) by campbell-lange.net with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lt7ok-0007O0-Pc; Tue, 15 Jun 2021 12:05:18 +0000 Received: from rory by rory-t470s with local (Exim 4.92) (envelope-from ) id 1lt7ok-0001IN-IG; Tue, 15 Jun 2021 13:05:18 +0100 Date: Tue, 15 Jun 2021 13:05:18 +0100 From: Rory Campbell-Lange To: Haseeb Khan Cc: pgsql-performance@lists.postgresql.org Subject: Re: Master - Slave Replication Window Server Message-ID: <20210615120518.GA4813@campbell-lange.net> References: <20210614194157.GA27920@campbell-lange.net> <5869FA34-45DB-464E-B342-9822E1BEC40F@gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 15/06/21, Haseeb Khan (khanhaseeb92@gmail.com) wrote: > I have confusion below, Should we create an archive path on the standby > server and then set it to recovery.conf file ? > > restore_command = 'cp /path/to/archive/%f %p' Hi Hasseb Are you following this procedure? https://www.postgresql.org/docs/13/continuous-archiving.html If so please let us know what problem you are experiencing. Also, this is the postgres performance list. Please move this conversation to postgresql general. Cheers Rory