Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qzGve-00FAgf-3T
	for pgsql-admin@arkaria.postgresql.org; Sat, 04 Nov 2023 13:43:10 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1qzGvc-005thr-CN
	for pgsql-admin@arkaria.postgresql.org; Sat, 04 Nov 2023 13:43:08 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1qzGvb-005thj-NN
	for pgsql-admin@lists.postgresql.org; Sat, 04 Nov 2023 13:43:07 +0000
Received: from mail-qv1-xf36.google.com ([2607:f8b0:4864:20::f36])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1qzGvU-003vit-Jf
	for pgsql-admin@lists.postgresql.org; Sat, 04 Nov 2023 13:43:06 +0000
Received: by mail-qv1-xf36.google.com with SMTP id
 6a1803df08f44-66cfd35f595so17258086d6.2
        for <pgsql-admin@lists.postgresql.org>;
 Sat, 04 Nov 2023 06:43:00 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1699105379;
 x=1699710179; darn=lists.postgresql.org;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject
         :date:message-id:reply-to;
        bh=6nNeMeIHGgpLasJyn/VU2+Ms9joFdLG21ri4EQaFWc4=;
        b=WJ5E/F+K0iLPNL9m2K2HY7IbqWhsrMrp9ETcWhicg8C+sjR3xoDXP0whG/bAoOp+lj
         kX9kkIJB1horwJFR7qOomzr3dbxVqvf+VCuJYO6w0+0oJwD5Y8+kqgdYEZnM0gZiPVLu
         b7Aam6JHSaJbWoYedpNgIcOVDTNdwGFPimhy1vpbyFDRAo3yaOCG1c3CFDGX+Js3kX4q
         nBjc5Lj9eXtbwk3ltAT/Jpp4m+tCJ1uk+TLRJyLYjSE+ZNOdJBKZVZoXInkRfaVeXoto
         pxbJwtEF9UX7Rxv3xk3qmaHpjjhCQaw7yU0xK76ZiccIf6bXD3YhA3sUoQRybaqQmCPq
         5QfA==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1699105379; x=1699710179;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=6nNeMeIHGgpLasJyn/VU2+Ms9joFdLG21ri4EQaFWc4=;
        b=BiE3vvQGuI0Cm5XoGHs6OhKuZ3wJwqADIIxpp72mN+bZdIgiF3NrS1thR6bWRlKKTP
         ocJdqcAZmKpn03/EOVuZajeQ1Xvu1dTt7qgf60oXMwmoNW33rw7B7GClJiP5x/mR7t7Q
         vEFukH/9D/JzmuDEVXPKWa1UoTfGi6A8QEPWTCCJkHfLdGRcp5besta0PFynNvJZ6Sqt
         M37hjSeNqUl7GaxhR8tumRv0HW2+O8qo7RMO4qPBaFECpMwUs+DFXdxOMrmnzRwVVgi9
         ASK7DOvvg4QQO9ycsxI5vk6Veox72m/XWtvdSipJdYgRaNr/xrOOJkmqRuzfzN5kzNmB
         /s7g==
X-Gm-Message-State: AOJu0YxoQowRie685Qmzw6v2on0YgRbhiMpZty5ocoF9ZLHzltKHd0/V
	hVvAllV4KgKWrkCMuaCQRb2Tb+npMrFY2/y7qIg=
X-Google-Smtp-Source: 
 AGHT+IFJuRpzKHLOIH9KrPOXr9to3/fa9whpe1A+Br6lyji77/AtyYMkFi/hULdfF/5sxQDNlMBxcA==
X-Received: by 2002:a05:6214:2467:b0:66f:bc19:3e2f with SMTP id
 im7-20020a056214246700b0066fbc193e2fmr25816338qvb.28.1699105379169;
        Sat, 04 Nov 2023 06:42:59 -0700 (PDT)
Received: from localhost.localdomain ([2001:871:260:349a:57ab:e7ee:d613:d164])
        by smtp.gmail.com with ESMTPSA id
 fc14-20020ad44f2e000000b0066d1540f9ecsm1664139qvb.77.2023.11.04.06.42.57
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Sat, 04 Nov 2023 06:42:58 -0700 (PDT)
Message-ID: <117cf700fc5db3085f9e294e76f545e3d9ee72f0.camel@cybertec.at>
Subject: Re: Recovering standby from primary archived WAL segments
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Ebubekir =?ISO-8859-1?Q?B=FCy=FCktosun?=
	 <ebubekir.buyuktosun@primeit.com.tr>, "pgsql-admin@lists.postgresql.org"
	 <pgsql-admin@lists.postgresql.org>
Cc: pg <pg@primeit.com.tr>
Date: Sat, 04 Nov 2023 14:42:56 +0100
In-Reply-To: <27541699100382@mail.yandex.com.tr>
References: <27541699100382@mail.yandex.com.tr>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) 
MIME-Version: 1.0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/117cf700fc5db3085f9e294e76f545e3d9ee72f0.camel%40cybertec.at>
Precedence: bulk

On Sat, 2023-11-04 at 15:46 +0300, Ebubekir B=C3=BCy=C3=BCktosun wrote:
> I want to ask how we should configure primary and/or standby servers in c=
ase of need
> to recover the standby server from primary archived WAL segments.
> =C2=A0
> If it is possible, how primary and/or standby servers must be configured?

Set "restore_command" on the standby.

Yours,
Laurenz Albe