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 ) id 1qzG3d-00F35d-Oh for pgsql-admin@arkaria.postgresql.org; Sat, 04 Nov 2023 12:47:23 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qzG2c-005lst-If for pgsql-admin@arkaria.postgresql.org; Sat, 04 Nov 2023 12:46:18 +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 ) id 1qzG2b-005lsl-WA for pgsql-admin@lists.postgresql.org; Sat, 04 Nov 2023 12:46:18 +0000 Received: from forward102b.mail.yandex.net ([178.154.239.149]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzG2V-003vPK-H4 for pgsql-admin@lists.postgresql.org; Sat, 04 Nov 2023 12:46:16 +0000 Received: from mail-nwsmtp-mxback-production-main-68.myt.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-68.myt.yp-c.yandex.net [IPv6:2a02:6b8:c12:292b:0:640:3449:0]) by forward102b.mail.yandex.net (Yandex) with ESMTP id 72C0660961 for ; Sat, 4 Nov 2023 15:46:06 +0300 (MSK) Received: from mail.yandex.com.tr (2a02:6b8:c12:4522:0:640:3ce:0 [2a02:6b8:c12:4522:0:640:3ce:0]) by mail-nwsmtp-mxback-production-main-68.myt.yp-c.yandex.net (mxback/Yandex) with HTTP id njYs1l2W3Gk0-GBv1vbvP; Sat, 04 Nov 2023 15:46:05 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=primeit.com.tr; s=mail; t=1699101965; bh=xBniedvc8NdMBABneLKeiPruSM/SNX+j2uFlVEB9GSU=; h=Message-Id:Date:Subject:To:From:Cc; b=A8yfEEbPGcV+weAwuu14vK3KxGjCuTmMxBpmqjQ2LU7l8taFPWw2nlWZUmqGyNQEw JcI5nQMruiJNbYW+k1lyLKeV/7e5sFElDqLQeBRrBp1BN+m72Znyj0JwdWd3f7gjuF ONQV7PobloYWkUxyRrkBZ0aU12frh8RwPNlOFBpo= Authentication-Results: mail-nwsmtp-mxback-production-main-68.myt.yp-c.yandex.net; dkim=pass header.i=@primeit.com.tr Received: by lduixalyeduyxu6q.myt.yp-c.yandex.net with HTTP; Sat, 04 Nov 2023 15:46:05 +0300 From: =?utf-8?B?RWJ1YmVraXIgQsO8ecO8a3Rvc3Vu?= To: "pgsql-admin@lists.postgresql.org" Cc: pg Subject: Recovering standby from primary archived WAL segments MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Sat, 04 Nov 2023 15:46:05 +0300 Message-Id: <27541699100382@mail.yandex.com.tr> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PGRpdj5IZWxsbyBjb21tdW5pdHksPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+SSB3YW50IHRvIGFz ayBob3cgd2Ugc2hvdWxkIGNvbmZpZ3VyZSBwcmltYXJ5IGFuZC9vciBzdGFuZGJ5IHNlcnZlcnMg aW4gY2FzZSBvZiBuZWVkIHRvIHJlY292ZXIgdGhlIHN0YW5kYnkgc2VydmVyIGZyb20gcHJpbWFy eSBhcmNoaXZlZCBXQUwgc2VnbWVudHMuPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+SW4gdGhlIHNj ZW5hcmlvPHNwYW4gc3R5bGU9ImJhY2tncm91bmQtY29sb3I6dHJhbnNwYXJlbnQiPiwgc3RhbmRi eSBzZXJ2ZXIgaGFzIGRvd24gYmVjYXVzZSBvZiBzb21lIHNlcnZlciBpc3N1ZXMgZm9yIDMgZGF5 cyB3aGlsZSBwcmltYXJ5IHNlcnZlciBoYXMgYmVlbiB3b3JraW5nIHdlbGwgYW5kIGdlbmVyYXRp bmcgV0FMIHNlZ21lbnRzIGFuZCBhcmNoaXZpbmcgdGhlbSBhcyBjb25maWd1cmVkLiAoWW91IGNh biBjb25zaWRlciBwcmltYXJ5IHNlcnZlciBpcyBjb25maWd1cmVkIHRvIGFyY2hpdmUgV0FMIHNl Z21lbnRzIHNldHRpbmcgdGhlIHBhcmFtZXRlcnMgYXJjaGl2ZV9tb2RlLCBhcmNoaXZlX2NvbW1h bmQgYW5kIGV2ZW4gcmVzdG9yZV9jb21tYW5kLikgwqBBZnRlciAzIGRheXMgaW4gdGhpcyA8L3Nw YW4+c2NlbmFyaW8sIHRoZSBwcm9ibGVtIGluIHRoZSA8c3BhbiBzdHlsZT0iYmFja2dyb3VuZC1j b2xvcjp0cmFuc3BhcmVudCI+c3RhbmRieSBzZXJ2ZXIgaGFzIGJlZW4gc29sdmVkIGFuZCB3ZSB3 YW50IHRvIHJlY292ZXIgdGhlIHN0YW5kYnkgZnJvbSBwcmltYXJ5IGFyY2hpdmVkIHdhbCBzZWdt ZW50cyBhbmQgY29udGludWUgdGhlIHN0cmVhbWluZyByZXBsaWNhdGlvbiBhcyB3ZWxsIDxzdHJv bmc+aW5zdGVhZCBvZiByZWluaXRpYWxpemluZyB0aGUgc3RhbmRieTwvc3Ryb25nPi4gTXkgZXhw ZWN0YXRpb24gaW4gdGhpcyBjYXNlLCBwb3N0Z3JlcyBtdXN0IG1hbmFnZSBpdHNlbGYgdG8gcmVz dG9yZSBhbmQgc2VuZCB0aGUgYXJjaGl2ZWQgV0FMIHNlZ21lbnRzIGluIHRoZSBwcmltYXJ5IHNp dGUgd2hpY2ggaXMgcmVxdWlyZWQgZnJvbSBzdGFuZGJ5IHNlcnZlciBmb3IgcmVjb3ZlcnkgaXRz ZWxmIHdpdGhvdXQgYW55IG1hbnVlbCBpbnRlcnZlbnRpb24gYnkgREJBLiBJZiBpdCBpcyBwb3Nz aWJsZSwgaG93IHByaW1hcnkgYW5kL29yIHN0YW5kYnkgc2VydmVycyBtdXN0IGJlIGNvbmZpZ3Vy ZWQ/PC9zcGFuPjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PlRoYW5rcyBmb3IgeW91ciBraW5kIGlu dmVzdGlnYXRpb25zLjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJjb2xvcjoj MDAwMDAwO2ZvbnQtc2l6ZToxNHB4O2xpbmUtaGVpZ2h0Om5vcm1hbCI+PHN0cm9uZz48c3BhbiBz dHlsZT0iZm9udC1mYW1pbHk6J2NvdXJpZXIgbmV3JyAsIG1vbm9zcGFjZSI+PHNwYW4gc3R5bGU9 ImJhY2tncm91bmQtY29sb3I6I2ZmZmZmZiI+xLB5aSDDp2FsxLHFn21hbGFyIDwvc3Bhbj48L3Nw YW4+PC9zdHJvbmc+PC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4gc3R5bGU9ImNvbG9yOiMwMDAwMDA7 Zm9udC1zaXplOjE0cHg7bGluZS1oZWlnaHQ6bm9ybWFsIj48c3Ryb25nPjxzcGFuIHN0eWxlPSJm b250LWZhbWlseTonY291cmllciBuZXcnICwgbW9ub3NwYWNlIj48c3BhbiBzdHlsZT0iYmFja2dy b3VuZC1jb2xvcjojZmZmZmZmIj5CZXN0IFJlZ2FyZHM8L3NwYW4+PC9zcGFuPjwvc3Ryb25nPjwv c3Bhbj48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj48aW1nIHNyYz0iaHR0cHM6Ly9hdmF0YXJzLm1k cy55YW5kZXgubmV0L2dldC1tYWlsLXNpZ25hdHVyZS8yMDAzNjkvYjVjZmJjNjlmZWM3YmE0MDdh ZDQzOWM5MTY4MTliNTEvb3JpZyIgLz48L2Rpdj48ZGl2PsKgPC9kaXY+