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 1lt8CR-0007Tu-JW for pgsql-performance@arkaria.postgresql.org; Tue, 15 Jun 2021 12:29:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lt8CP-0005oT-6k for pgsql-performance@arkaria.postgresql.org; Tue, 15 Jun 2021 12:29:45 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lt8CO-0005oK-T6 for pgsql-performance@lists.postgresql.org; Tue, 15 Jun 2021 12:29:44 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lt8CM-000392-BD for pgsql-performance@lists.postgresql.org; Tue, 15 Jun 2021 12:29:43 +0000 Received: by mail-ej1-x62e.google.com with SMTP id gt18so3788719ejc.11 for ; Tue, 15 Jun 2021 05:29:42 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=sKiOsEHNWeHkv0XgNP9EHM+59TVcE0O01/XZEO7wKTI=; b=kR++6IUQ6ALjXvXhF2GxcZD+wJ6QDi+3EfPgAFTf/+LzKh0dvQ1Lzde4VVYUo92610 HSo4/oCS+LVmIQtwZJVxv0BLBfXTMsJq78w0etjJuJQX4QgkGD4tUhNyvNJMmi57vW1n IW4V/8O+p8VluJ2Pd2fgTLguVxkRXIJY/tcSQC8jma8Exvu+D0axvjDuM84GPMKpaNUE HZ7Zk6SihQcC56MaKo7EMVhYLhMcBfKq7rNCV2dP1amfCIrQnS4D/K9IdxGuH1/ghydr 9Z1JypcGlYeivMwUy3zwBcymu5OTM4dV96PQpunecw22dFRT2AziawDdcpwjF2p2oCyN fLZQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=sKiOsEHNWeHkv0XgNP9EHM+59TVcE0O01/XZEO7wKTI=; b=GNqz6LGI/ke/NTtQvDqnunFbASP/6OHaJMkPZr1bp+be7kRalxjCJO9tpqUrtdM1Cx 00ETofJwhz9LlO914Y3Mop4sjK6zJHeAZnqq+4eXJmRuE5DKFKN+BYqRJd0uk43JwS1z o1W5t0Hcu1byJc8jvI2ErsENQp+fhBBgyRCXhS/Qw9sRfYVH8XH/Zxmis6AeRYfKOJD4 z5WAgA2k51DY2l13toYtku+E4e+tbUiLs5+PrH2nHtuaqHfcr96jDMrlswa7rzW1f9CP wnb6thwPvSVrPFv4t3lVARUU3iaI9GaCC/4bFwNZ/WMsqXLzPuaONRAPVIndruVMQK/k mP0Q== X-Gm-Message-State: AOAM532hZkpJ79PeHCBMgWa+PCEoVXYaX7pGRmRIz1jW1VRK3213B6iI J9mHECStPAYt1RmBqeEpKW8N3skFFBc= X-Google-Smtp-Source: ABdhPJyXx20uRNkhHQpEui2cScMQVlu0aBK/x/dqIUPXArWskLa0dMwN5uJIzHOVL2FcXyqr7cO9Uw== X-Received: by 2002:a17:906:4308:: with SMTP id j8mr20762710ejm.315.1623760180992; Tue, 15 Jun 2021 05:29:40 -0700 (PDT) Received: from smtpclient.apple ([61.5.153.49]) by smtp.gmail.com with ESMTPSA id z19sm10121314edc.90.2021.06.15.05.29.39 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 15 Jun 2021 05:29:39 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-2E0119A1-F350-45CF-86D2-C2DC4ADCCCF7 Content-Transfer-Encoding: 7bit From: Haseeb Khan Mime-Version: 1.0 (1.0) Subject: Re: Master - Slave Replication Window Server Date: Tue, 15 Jun 2021 17:29:37 +0500 Message-Id: <81F39405-2DD5-43CE-84FD-F8FD27E927EA@gmail.com> References: <20210615120518.GA4813@campbell-lange.net> Cc: pgsql-performance@lists.postgresql.org In-Reply-To: <20210615120518.GA4813@campbell-lange.net> To: Rory Campbell-Lange X-Mailer: iPhone Mail (18F72) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-2E0119A1-F350-45CF-86D2-C2DC4ADCCCF7 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello Rory, Yes , I have followed the document and configured each and everything. But I= can=E2=80=99t see archive_Wal_segments is copying to the folder which I hav= e created. So the issue I am facing is that where should I create the archiv= e folder should I create on master or slave server ? Might be I am missing s= omething or doing some mistake. Would appreciated, if you could help in this regard=20 Kindly send me the Postgres general email, so I can raise this issue over th= ere as well Thanks in advance=20 Br,=20 Haseeb Ahmad > On 15-Jun-2021, at 5:05 PM, Rory Campbell-Lange w= rote: >=20 > =EF=BB=BFOn 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 ? >>=20 >> restore_command =3D 'cp /path/to/archive/%f %p' >=20 > Hi Hasseb >=20 > Are you following this procedure? > https://www.postgresql.org/docs/13/continuous-archiving.html >=20 > If so please let us know what problem you are experiencing. >=20 > Also, this is the postgres performance list. Please move this conversation= to postgresql general. >=20 > Cheers > Rory >=20 >=20 --Apple-Mail-2E0119A1-F350-45CF-86D2-C2DC4ADCCCF7 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hello Rory,

Yes , I have= followed the document and configured each and everything. But I can=E2=80=99= t see archive_Wal_segments is copying to the folder which I have created. So= the issue I am facing is that where should I create the archive folder shou= ld I create on master or slave server ? Might be I am missing something or d= oing some mistake.

Wou= ld appreciated, if you could help in this regard 

Kindly send me the Postgres general email, so I c= an raise this issue over there as well

Thanks in advance 

Br, 
Haseeb Ahmad

On 15-Jun-2021, at 5:05 PM, Rory Campbell-= Lange <rory@campbell-lange.net> wrote:

=EF=BB=BFOn 15/06/21, Haseeb Kha= n (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 =3D= 'cp /path/to/archive/%f %p'

H= i Hasseb

Are you following this procedure?<= /span>
https://www.postgresql.org/docs/13/continuous-archiving.html=

If so please let us know what problem you a= re experiencing.

Also, this is the postgres= performance list. Please move this conversation to postgresql general.

Cheers
Rory


= --Apple-Mail-2E0119A1-F350-45CF-86D2-C2DC4ADCCCF7--