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 1qzHqU-00FHrE-EL for pgsql-admin@arkaria.postgresql.org; Sat, 04 Nov 2023 14:41:55 +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 1qzHqS-006H6l-Sg for pgsql-admin@arkaria.postgresql.org; Sat, 04 Nov 2023 14:41:52 +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 1qzHqS-006H6W-AH for pgsql-admin@lists.postgresql.org; Sat, 04 Nov 2023 14:41:52 +0000 Received: from forward500c.mail.yandex.net ([178.154.239.208]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzHqN-003w5I-La for pgsql-admin@lists.postgresql.org; Sat, 04 Nov 2023 14:41:51 +0000 Received: from mail-nwsmtp-mxback-production-main-43.myt.yp-c.yandex.net (mail-nwsmtp-mxback-production-main-43.myt.yp-c.yandex.net [IPv6:2a02:6b8:c12:141d:0:640:671f:0]) by forward500c.mail.yandex.net (Yandex) with ESMTP id 97F9760EBC; Sat, 4 Nov 2023 17:41:43 +0300 (MSK) Received: from mail.yandex.com.tr (2a02:6b8:c12:40ac:0:640:ae04:0 [2a02:6b8:c12:40ac:0:640:ae04:0]) by mail-nwsmtp-mxback-production-main-43.myt.yp-c.yandex.net (mxback/Yandex) with HTTP id WfaY3m2W4eA0-oo9DCLrT; Sat, 04 Nov 2023 17:41:43 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=primeit.com.tr; s=mail; t=1699108903; bh=FkR7QfGiuWoQEMAdaZYdA9mElnmbtz7zGaQNnahiZWo=; h=Message-Id:References:Date:Subject:To:In-Reply-To:From; b=CRrHVbAHxd2HbKQBGmCI4D2bf1ztIKDm4uTdw7noQw9185lQpQ+g029Ajzsx3es+n L1beDxSGvfO5CrRU7X08IVyBii1ChbUda2Ull4yy9CMqXQv9NtjIN9OOd6MoQIu66/ 6v6BUqcEGFhuLMInrwqFmcvM0OJO/1Ex9qZOZWs4= Authentication-Results: mail-nwsmtp-mxback-production-main-43.myt.yp-c.yandex.net; dkim=pass header.i=@primeit.com.tr Received: by c6cdvt45gvthiay5.myt.yp-c.yandex.net with HTTP; Sat, 04 Nov 2023 17:41:42 +0300 From: =?utf-8?B?RWJ1YmVraXIgQsO8ecO8a3Rvc3Vu?= To: Ron , "pgsql-admin@lists.postgresql.org" In-Reply-To: <8357c11f-388f-436a-bd51-4c4dcbc0ea7a@gmail.com> References: <27541699100382@mail.yandex.com.tr> <117cf700fc5db3085f9e294e76f545e3d9ee72f0.camel@cybertec.at> <8357c11f-388f-436a-bd51-4c4dcbc0ea7a@gmail.com> Subject: Re: Recovering standby from primary archived WAL segments MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Sat, 04 Nov 2023 17:41:42 +0300 Message-Id: <387721699108418@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 PGRpdj5IaSBSb24sPC9kaXY+PGRpdj7CoDwvZGl2PjxkaXY+SSB0ZXN0IGl0IHVzaW5nIHJlcG1n ci4gU28sIHdoZW4gaSBjbG9zZSB0aGUgcG9zdGdyZXMgYW5kIHJlcG1nciBzZXJ2aWNlcyBhdCB0 aGUgc3RhbmRieSBzaXRlLCBhcyBpIHVuZGVyc3RhbmQsIHJlcG1nciBkcm9wcyBpdCdzIHJlcGxp Y2F0aW9uIHNsb3Qgc28gdGhlcmUgaXMgbm8gd2FsIGFjY3VtdWxhdGlvbiBpbiBwZ193YWwgYXQg cHJpbWFyeSBzaXRlIGJ1dCBhcmNoaXZpbmcgaXMgd29ya2luZyB3ZWxsIGJlY2F1c2UgaXQgaXMg ZW5hYmxlZC48L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj5UaGFua3MgZm9yIHJlc3BvbnNlLDwvZGl2 PjxkaXY+wqA8L2Rpdj48ZGl2PjA0LjExLjIwMjMsIDE3OjE2LCAiUm9uIiAmbHQ7cm9ubGpvaG5z b25qckBnbWFpbC5jb20mZ3Q7OjwvZGl2PjxibG9ja3F1b3RlPjxwPk9uIDExLzQvMjMgMDg6NDIs IExhdXJlbnogQWxiZSB3cm90ZTo8L3A+PGJsb2NrcXVvdGU+wqBPbiBTYXQsIDIwMjMtMTEtMDQg YXQgMTU6NDYgKzAzMDAsIEVidWJla2lyIELDvHnDvGt0b3N1biB3cm90ZTo8YmxvY2txdW90ZT7C oEkgd2FudCB0byBhc2sgaG93IHdlIHNob3VsZCBjb25maWd1cmUgcHJpbWFyeSBhbmQvb3Igc3Rh bmRieSBzZXJ2ZXJzIGluIGNhc2Ugb2YgbmVlZDxiciAvPsKgdG8gcmVjb3ZlciB0aGUgc3RhbmRi eSBzZXJ2ZXIgZnJvbSBwcmltYXJ5IGFyY2hpdmVkIFdBTCBzZWdtZW50cy48YnIgLz7CoMKgwqA8 YnIgLz7CoElmIGl0IGlzIHBvc3NpYmxlLCBob3cgcHJpbWFyeSBhbmQvb3Igc3RhbmRieSBzZXJ2 ZXJzIG11c3QgYmUgY29uZmlndXJlZD88L2Jsb2NrcXVvdGU+wqBTZXQgInJlc3RvcmVfY29tbWFu ZCIgb24gdGhlIHN0YW5kYnkuPC9ibG9ja3F1b3RlPjxwPjxiciAvPldoZW4gdXNpbmcgcGh5c2lj YWwgcmVwbGljYXRpb24gYW5kIGEgcmVwbGljYXRpb24gc2xvdCBzdGlsbCBleGlzdHMgaW48YnIg Lz5wZ19yZXBsaWNhdGlvbl9zbG90cywgd29uJ3QgdGhlIFdBTCBmaWxlcyAianVzdCIgYWNjdW11 bGF0ZSBpbiBwZ193YWwvIHVudGlsPGJyIC8+UGcgb24gdGhlIHJlcGxpY2EgaXMgcmVzdGFydGVk P8KgIChJIGp1c3QgdGVzdGVkIHRoYXQsIGFuZCBpdCBzZWVtcyB0byB3b3JrLik8YnIgLz7CoDwv cD4tLTxiciAvPkJvcm4gaW4gQXJpem9uYSwgbW92ZWQgdG8gQmFieWxvbmlhLjxiciAvPjxiciAv PsKgPC9ibG9ja3F1b3RlPjxkaXY+wqA8L2Rpdj48ZGl2PsKgPC9kaXY+PGRpdj7CoDwvZGl2Pjxk aXY+PHNwYW4gc3R5bGU9ImNvbG9yOiMwMDAwMDA7Zm9udC1zaXplOjE0cHg7bGluZS1oZWlnaHQ6 bm9ybWFsIj48c3Ryb25nPjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTonY291cmllciBuZXcnICwg bW9ub3NwYWNlIj48c3BhbiBzdHlsZT0iYmFja2dyb3VuZC1jb2xvcjojZmZmZmZmIj7EsHlpIMOn YWzEscWfbWFsYXIgPC9zcGFuPjwvc3Bhbj48L3N0cm9uZz48L3NwYW4+PC9kaXY+PGRpdj48c3Bh biBzdHlsZT0iY29sb3I6IzAwMDAwMDtmb250LXNpemU6MTRweDtsaW5lLWhlaWdodDpub3JtYWwi PjxzdHJvbmc+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5Oidjb3VyaWVyIG5ldycgLCBtb25vc3Bh Y2UiPjxzcGFuIHN0eWxlPSJiYWNrZ3JvdW5kLWNvbG9yOiNmZmZmZmYiPkJlc3QgUmVnYXJkczwv c3Bhbj48L3NwYW4+PC9zdHJvbmc+PC9zcGFuPjwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PjxpbWcg c3JjPSJodHRwczovL2F2YXRhcnMubWRzLnlhbmRleC5uZXQvZ2V0LW1haWwtc2lnbmF0dXJlLzIw MDM2OS9iNWNmYmM2OWZlYzdiYTQwN2FkNDM5YzkxNjgxOWI1MS9vcmlnIiAvPjwvZGl2PjxkaXY+ wqA8L2Rpdj4=