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 1kiBAl-0002NB-P1 for pgsql-admin@arkaria.postgresql.org; Thu, 26 Nov 2020 06:54:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kiBAk-0005Fh-58 for pgsql-admin@arkaria.postgresql.org; Thu, 26 Nov 2020 06:54:30 +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 1kiBAj-0005FZ-Pc for pgsql-admin@lists.postgresql.org; Thu, 26 Nov 2020 06:54:29 +0000 Received: from forward100p.mail.yandex.net ([2a02:6b8:0:1472:2741:0:8b7:100]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kiBAf-0004kD-Sc for pgsql-admin@postgresql.org; Thu, 26 Nov 2020 06:54:28 +0000 Received: from mxback25g.mail.yandex.net (mxback25g.mail.yandex.net [IPv6:2a02:6b8:c03:7b3:0:640:8f7a:2657]) by forward100p.mail.yandex.net (Yandex) with ESMTP id A8F35598113F; Thu, 26 Nov 2020 09:54:20 +0300 (MSK) Received: from localhost (localhost [::1]) by mxback25g.mail.yandex.net (mxback/Yandex) with ESMTP id H4WTBS8hSI-sJ2S6cJl; Thu, 26 Nov 2020 09:54:19 +0300 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex.ru; s=mail; t=1606373659; bh=HwisZ8MTqA7CikyoHj3G3nsJVrDK5TfigU0XrICbu34=; h=Message-Id:Subject:In-Reply-To:Date:References:To:From; b=NkIWga0u5aMzm5jFqxCUIJkEb4E862PQkyTKUhUze3z4jxXLFD0pKdmREoVmZouXU CRicgbTMdFDxSyZWApA6nV5qory/HD7wUIRhjxUbpY6Et11N9u5l9WIr8DmK2khwkM UJYi02kcVHJARwrlkfCo4i0vEX/K/N6mZpS9TaiQ= Authentication-Results: mxback25g.mail.yandex.net; dkim=pass header.i=@yandex.ru Received: by sas1-5b393656f82a.qloud-c.yandex.net with HTTP; Thu, 26 Nov 2020 09:54:19 +0300 From: =?utf-8?B?0JjQs9C+0YDRjCDQktGL0YHQutC+0YDQutC+?= Envelope-From: vyskorko-igor@yandex.ru To: Laurenz Albe , "pgsql-admin@postgresql.org" In-Reply-To: <09ff8c81a3ecb764bbfec33baf432295a884c19e.camel@cybertec.at> References: <6184231606295846@mail.yandex.ru> <09ff8c81a3ecb764bbfec33baf432295a884c19e.camel@cybertec.at> Subject: Re: Hot standby with hot_standny_feedback enabled: cancelling statement issues MIME-Version: 1.0 X-Mailer: Yamail [ http://yandex.ru ] 5.0 Date: Thu, 26 Nov 2020 13:54:19 +0700 Message-Id: <3955671606369583@mail.yandex.ru> Content-Transfer-Encoding: base64 Content-Type: text/html; charset=utf-8 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk PGRpdj7CoDwvZGl2PjxkaXY+wqA8L2Rpdj48ZGl2PjI1LjExLjIwMjAsIDIxOjQ2LCAiTGF1cmVu eiBBbGJlIiAmbHQ7bGF1cmVuei5hbGJlQGN5YmVydGVjLmF0Jmd0Ozo8L2Rpdj48YmxvY2txdW90 ZT48cD5PbiBXZWQsIDIwMjAtMTEtMjUgYXQgMTY6NDYgKzA3MDAsINCY0LPQvtGA0Ywg0JLRi9GB 0LrQvtGA0LrQviB3cm90ZTo8L3A+PGJsb2NrcXVvdGU+wqBJJ20gdHJ5aW5nIHRvIGNvbmZpZ3Vy ZSBob3Qgc3RhbmRieSByZXBsaWNhIGZvciBhbmFseXRpY3MgYW5kIHNpbXBsZSBiYWNrdXAgcHVy cG9zZXMuIFNvLCBJIGhhdmUgbG9uZyBxdWVyaWVzIHdoaWNoIGNvbnN0YW50bHkgY2FuY2VsbGVk IHdpdGhvdXQgcHJvcGVyIGNvbmZpZ3VyaW5nLjxiciAvPsKgSSBkbyBub3Qgd2FudCBsYXJnZSBs YWcgb24gcmVwbGljYSAobW9yZSB0aGFuIDMwIG1pbnMpIHNvIHNldHRpbmcgbWF4X3N0YW5kYnlf c3RyZWFtaW5nX2RlbGF5IHRvIC0xIGlzIG5vdCBteSBjaG9pY2UuIEkgaGF2ZSB0byBhdm9pZCBs YXJnZSBsYWcgYmVjYXVzZSBvZiBhbmFseXRpYyBxdWVyaWVzIHdoaWNoIG11c3QgYmUgcnVuIG9u PGJyIC8+wqBhbG1vc3QgZnJlc2ggY29weSBvZiBkYXRhLjxiciAvPsKgSSBmb3VuZCB0aGUgcGFu YWNlYSAoSSB0aG91Z2h0IEkgZm91bmQgYWN0dWFsbHkpIGluIHNldHRpbmcgaG90X3N0YW5kYnlf ZmVlZGJhY2sgPSBvbiAoSSBrbm93IGFib3V0IHBvc3NpYmxlIG1hc3RlciBibG9hdGluZykgYnV0 IGl0IGFsc28gZG9lc24ndCBoZWxwLjxiciAvPsKgSnVzdCB0byBjbGFyaWZ5IGFib3V0ICJzaW1w bGUgYmFja3VwIHB1cnBvc2VzIjogaXQgbWVhbnMgcnVuIHBnX2R1bXAgaW4gZGFpbHkgYmFzaXMu IE91ciBkYXRhYmFzZSBpcyBhYm91dCAyNTBHYjxiciAvPsKgwqA8YnIgLz7CoDIgdGVzdCBydW4g b2YgcGdfZHVtcCBmYWlsZWQgd2l0aDo8YnIgLz7CoHBnX2R1bXA6IER1bXBpbmcgdGhlIGNvbnRl bnRzIG9mIHRhYmxlICJ0YWJsZSIgZmFpbGVkOiBQUWdldFJlc3VsdCgpIGZhaWxlZC48YnIgLz7C oHBnX2R1bXA6IEVycm9yIG1lc3NhZ2UgZnJvbSBzZXJ2ZXI6IEVSUk9SOiBjYW5jZWxpbmcgc3Rh dGVtZW50IGR1ZSB0byBjb25mbGljdCB3aXRoIHJlY292ZXJ5PGJyIC8+wqBERVRBSUw6IFVzZXIg d2FzIGhvbGRpbmcgYSByZWxhdGlvbiBsb2NrIGZvciB0b28gbG9uZy48YnIgLz7CoHBnX2R1bXA6 IFRoZSBjb21tYW5kIHdhczogQ09QWS4uLjxiciAvPsKgwqA8YnIgLz7CoHBvc3RncmVzPSMgc2Vs ZWN0ICogZnJvbSBwZ19zdGF0X2RhdGFiYXNlX2NvbmZsaWN0cyA7PGJyIC8+wqDCoMKgwqBkYXRp ZCB8IGRhdG5hbWUgfCBjb25mbF90YWJsZXNwYWNlIHwgY29uZmxfbG9jayB8IGNvbmZsX3NuYXBz aG90IHwgY29uZmxfYnVmZmVycGluIHwgY29uZmxfZGVhZGxvY2s8YnIgLz7CoC0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tKy0tLS0tLS0t LS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLTxiciAvPsKgwqDCoMKg wqDCoDEyNDQ1IHwgZGJuYW1lIHwgMCB8IDIgfCAwIHwgMCB8IDA8YnIgLz7CoDxiciAvPsKgTm90 IHN1cmUgYWJvdXQgd2hhdCBraW5kIG9mIGxvY2sgd2FzIGhvbGRpbmcgdG9vIGxvbmcuLi48YnIg Lz7CoDxiciAvPsKgU28sIG15IHF1ZXN0aW9ucyBhcmU6PGJyIC8+wqAxLiBXaHkgImhvdF9zdGFu ZGJ5X2ZlZWRiYWNrID0gb24iIGlzIG5vdCBoZWxwaW5nPzwvYmxvY2txdW90ZT48cD48YnIgLz5C ZWNhdXNlIGlzIHdhcyBub3QgYSBjb25mbGljdCB3aXRoIGEgdHVwbGUgZGVsZXRlZCBieSBWQUNV VU0gKCJzbmFwc2hvdCBjb25mbGljdCIpLDxiciAvPmJ1dCB3aXRoIGEgbG9jay48YnIgLz48YnIg Lz5BQ0NFU1MgRVhDTFVTSVZFIGxvY2tzIGFyZSByZXBsaWNhdGVkLCBiZWNhdXNlIHRoZXkgYXJl IG5lY2Vzc2FyeSBmb3Igc2FmZTxiciAvPnJlcGxpY2F0aW9uIG9mIGNvbW1hbmRzIGxpa2UgVFJV TkNBVEUgb3IgQUxURVIgVEFCTEUuPGJyIC8+PGJyIC8+SWYgeW91IHJhbiBub25lIG9mIHRoZXNl IGNvbW1hbmRzIG9uIHRoZSBwcmltYXJ5LCB5b3UgcHJvYmFibHkgaGF2ZSBmYWxsZW48YnIgLz5w cmV5IHRvICJ2YWN1dW0gdHJ1bmNhdGlvbiIsIHdoZXJlIGEgYnJpZWYgQUNDRVNTIEVYQ0xVU0lW RSBsb2NrIGlzIHRha2VuIG9uPGJyIC8+YSB0YWJsZSBzbyB0aGF0IFZBQ1VVTSBjYW4gdHJ1bmNh dGUgc29tZSBlbXB0eSBwYWdlcyBmcm9tIGEgdGFibGUuPGJyIC8+PGJyIC8+VGhlc2UgbG9ja3Mg ZG9uJ3QgZGlzcnVwdCBvcGVyYXRpb24gb24gdGhlIHByaW1hcnksIGJ1dCB0aGV5IGNhbiBjb25m bGljdDxiciAvPndpdGggcXVlcmllcyBvbiB0aGUgc3RhbmRieS48YnIgLz7CoDwvcD48YmxvY2tx dW90ZT7CoDIuIFdoYXQgaXMgcHJvcGVyIHdheSB0byB1c2UgcmVwbGljYSBmb3IgdGFza3MgYXMg bWluZT88L2Jsb2NrcXVvdGU+PHA+PGJyIC8+VGhlIGJlc3QgdGhpbmcgaXMgdG8gaGF2ZSB0d28g c3RhbmRieXM6IG9uZSBmb3IgaGlnaCBhdmFpbGFiaWxpdHkgdGhhdCBkb2VzPGJyIC8+bm90IGxh ZyAoaG90X3N0YW5kYnkgPSBvZmYpLCBhbmQgb25lIGZvciBwZ19kdW1wIGFuZCBxdWVyaWVzLjxi ciAvPjxiciAvPllvdSBtYXkgd2FudCB0byByZWFkIG15IGJsb2cgb24gdGhlIHRvcGljOjxiciAv PjxhIGhyZWY9Imh0dHBzOi8vd3d3LmN5YmVydGVjLXBvc3RncmVzcWwuY29tL2VuL3N0cmVhbWlu Zy1yZXBsaWNhdGlvbi1jb25mbGljdHMtaW4tcG9zdGdyZXNxbC8iIHJlbD0ibm9vcGVuZXIgbm9y ZWZlcnJlciI+aHR0cHM6Ly93d3cuY3liZXJ0ZWMtcG9zdGdyZXNxbC5jb20vZW4vc3RyZWFtaW5n LXJlcGxpY2F0aW9uLWNvbmZsaWN0cy1pbi1wb3N0Z3Jlc3FsLzwvYT48YnIgLz48YnIgLz5Zb3Vy cyw8YnIgLz5MYXVyZW56IEFsYmU8L3A+PC9ibG9ja3F1b3RlPjxkaXY+PGRpdj5UaGFua3MgZm9y IHJlcGx5IGFuZCBsaW5rIHRvIHRvcGljLiBJdCdzIG1ha2Ugc2Vuc2Ugbm93IHdoeSByZXBsaWNh dGlvbiBjb25mbGljdHMgYXJlIHJhaXNlZC48L2Rpdj48ZGl2PkkgZm91bmQgaG91cmx5IGV4ZWN1 dGVkIHRhc2sgd2hpY2ggdXNlcyB0cnVuY2F0ZSBvcGVyYXRpb24uLi48L2Rpdj48ZGl2PlNvLCBh cyB5b3Ugc3VnZ2VzdGVkIC0gdGhlIGJlc3Qgd2F5IEkgc2VlIGlzIHRvIHNldCBob3Rfc3RhbmRi eV9mZWVkYmFjayA9IG9mZiBhbmQgc2V0IG1heF9zdGFuZGJ5X3N0cmVhbWluZ19kZWxheSB0byBy YXRoZXIgaGlnaCB2YWx1ZS7CoDwvZGl2PjwvZGl2Pg==