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 1pcmGN-0004RA-AC for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Mar 2023 11:59:19 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pcmGM-00020u-1z for pgsql-bugs@arkaria.postgresql.org; Thu, 16 Mar 2023 11:59:18 +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 1pclN2-0004yG-08 for pgsql-bugs@lists.postgresql.org; Thu, 16 Mar 2023 11:02:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pclMz-0000SB-OH for pgsql-bugs@lists.postgresql.org; Thu, 16 Mar 2023 11:02:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=oOKlp+A3royrb5rd8zXD8F7bg8j5RMyMpMyRVKnOe2M=; b=E7nNuQXQUVSt3RbapWGjgF7awc S8Rn3hZEEL4IrzAS1Jb/FF7A1C9+L74Mk7cbf0csCqmrNNK5EISvFQm+3OHSwhm6GDpXIlMVjFBsC e2qtXZ+lEfxkUl3pIKYqUWxyGbJBvzqNlBL/xgLbsAr9fjEF1Sk5SYxidezWpJUjyuIfBdF/2HCcE +Gf8M0fBo6o3YlLgHzwdAFfJqwAzC3DhMkAv7Jebxd32HF/PFrFhb7LKua9ymFIq/60UlHdaqUPb/ qud4/bNfpCdAb2Tibvy43fSBASHP/3E0nid6E9KlIFAULSQSHnCc96gC4qg79/76A4fp5nEfrkYE5 fjcsW0mw==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pclMz-0000YG-F1 for pgsql-bugs@lists.postgresql.org; Thu, 16 Mar 2023 11:02:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1pclMv-00DGay-JI for pgsql-bugs@lists.postgresql.org; Thu, 16 Mar 2023 11:02:02 +0000 Content-Type: multipart/mixed; boundary="===============8093939767180929375==" MIME-Version: 1.0 Subject: BUG #17846: pg_dump doesn't properly dump with paused WAL replay To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: francisco.reinolds@channable.com Reply-To: francisco.reinolds@channable.com, pgsql-bugs@lists.postgresql.org Date: Thu, 16 Mar 2023 11:01:42 +0000 Message-ID: <17846-1a0e5ce976f4c01a@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============8093939767180929375== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzg0NgpMb2dnZWQgYnk6ICAgICAgICAgIEZyYW5jaXNjbyBSZWlub2xk cwpFbWFpbCBhZGRyZXNzOiAgICAgIGZyYW5jaXNjby5yZWlub2xkc0BjaGFubmFibGUuY29tClBv c3RncmVTUUwgdmVyc2lvbjogMTMuOApPcGVyYXRpbmcgc3lzdGVtOiAgIFVidW50dSAyMi4wNC4y IExUUwpEZXNjcmlwdGlvbjogICAgICAgIAoKSW4gb3VyIHNldHVwLCB3ZSBoYXZlIHByaW1hcnkg YW5kIHNlY29uZGFyeSBkYXRhYmFzZXMsIHRha2luZyBhZHZhbnRhZ2Ugb2YKcGh5c2ljYWwgc3Ry ZWFtaW5nIHJlcGxpY2F0aW9uIHRvIGtlZXAgdGhlIHNlY29uZGFyeSB1cCB0byBkYXRlLCBzbyB0 aGF0IHdlCmNhbiBwZXJmb3JtIGJhY2t1cHMgZnJvbSBpdCwgbGVzc2VuaW5nIHRoZSBsb2FkIG9u IHRoZSBwcmltYXJ5Lg0KDQpGb3IgYmFja3Vwcywgd2UgdXNlIHBnX2R1bXAgdG8gcGVyZm9ybSBh IGZ1bGwgZGF0YWJhc2UgZHVtcC4gQmVmb3JlIHdlIHN0YXJ0CmEgYmFja3VwLCB3ZSBwYXVzZSB0 aGUgV0FMIHJlcGxheSBvbiB0aGUgc2Vjb25kYXJ5LCB1bnBhdXNpbmcgaXQgYWZ0ZXIgaXQgaXMK Y29uY2x1ZGVkLiBUaGlzIHdhcyBkb25lIHNpbmNlIHdlIHByZXZpb3VzbHkgZW5jb3VudGVyZWQg cHJvYmxlbXMgd2l0aApwZ19kdW1wIGZhaWxpbmcgd2hlbiBhbiBBY2Nlc3NFeGNsdXNpdmVMb2Nr IHdhcyBoZWxkIG9uIGEgdGFibGUgdGhhdCBwZ19kdW1wCndhcyBnb2luZyB0byBkdW1wLg0KDQpG b3Igc29tZSB0aW1lIHdlIGZhY2VkIG5vIHByb2JsZW1zIHdpdGggdGhpcyBzZXR1cCwgYnV0IHN0 YXJ0aW5nIHNvbWUgbW9udGhzCmFnbywgd2Ugc3RhcnRlZCB3aXRuZXNzaW5nIHNwb3JhZGljIGZh aWx1cmVzIHdoZW4gd2UgYXR0ZW1wdGVkIHRvIHJlc3RvcmUKdGhlIGR1bXBzIG9mIG9uZSBvZiBv dXIgZGF0YWJhc2VzLCB0byB2ZXJpZnkgdGhlIGR1bXAncyBpbnRlZ3JpdHkuIFRoZXNlCnJlc3Rv cmUgZmFpbHVyZXMgd291bGQgb2NjdXIgZHVlIHRvIGEga2V5IG5vdCBiZWluZyBwcmVzZW50IGlu IGEgdGFibGU6DQoNCg0KYGBgDQpwZ19yZXN0b3JlOiB3aGlsZSBQUk9DRVNTSU5HIFRPQzoNCnBn X3Jlc3RvcmU6IGZyb20gVE9DIGVudHJ5IDMyNzk7IDI2MDYgMjAzMzI2MjQzIEZLIENPTlNUUkFJ TlQgdGFibGVfMgp0YWJsZV8yX3RhYmxlXzFfaWRfZmtleSByZWFsdGltZV9hbGVtYmljDQpwZ19y ZXN0b3JlOiBlcnJvcjogY291bGQgbm90IGV4ZWN1dGUgcXVlcnk6IEVSUk9SOiAgaW5zZXJ0IG9y IHVwZGF0ZSBvbgp0YWJsZSAidGFibGVfMiIgdmlvbGF0ZXMgZm9yZWlnbiBrZXkgY29uc3RyYWlu dCAidGFibGVfMl90YWJsZV8xX2lkX2ZrZXkiDQpERVRBSUw6ICBLZXkgKHRhYmxlXzFfaWQpPSgz NDU1MzA2NikgaXMgbm90IHByZXNlbnQgaW4gdGFibGUgInRhYmxlXzEiLg0KQ29tbWFuZCB3YXM6 IEFMVEVSIFRBQkxFIE9OTFkgcHVibGljLnRhYmxlXzINCglBREQgQ09OU1RSQUlOVCB0YWJsZV8y X3RhYmxlXzFfaWRfZmtleSBGT1JFSUdOIEtFWSAodGFibGVfMV9pZCkgUkVGRVJFTkNFUwpwdWJs aWMudGFibGVfMShpZCk7DQpgYGANCg0KDQpUaGlzIGhhcyBiZWVuIHB1enpsaW5nIHVzIGZvciBz b21lIHRpbWUgc2luY2U6DQotIHRoaXMgaXMgdGhlIG9ubHkgZGF0YWJhc2Ugb2Ygb3VyIGluZnJh c3RydWN0dXJlIHdoZXJlIHRoaXMgb2NjdXJzLCBkZXNwaXRlCnRoaXMgc2V0dXAgYmVpbmcgcmVw bGljYXRlZCBhY3Jvc3MgaXQ7DQotIHRoZSBmYWlsdXJlcyBzdGFydGVkIG9jY3VycmluZyBzcG9y YWRpY2FsbHksIGJ1dCBoYXZlIGJlY29tZSBtb3JlCmNvbnNpc3RlbnQ7DQoNCldlIGhhdmUgbWFu YWdlZCwgd2l0aCBzb21lIGhlbHAgZnJvbSB0aGUgUG9zdGdyZXMgSVJDIGNoYW5uZWwgKHNwZWNp YWwKdGhhbmtzIHRvIHVzZXIgbmlja2IpLCB0byB3b3JrIGFyb3VuZCB0aGUgcHJvYmxlbS4gVGhl IHNvbHV0aW9uIHdhcyB0byBiZWdpbgphIHRyYW5zYWN0aW9uLCBhbmQgZXh0cmFjdCBhIHNuYXBz aG90IHRoYXQnZCBiZSBwYXNzZWQgYXMgYSBwZ19kdW1wCmFyZ3VtZW50LCBhbmQgb25seSB0aGVu IHBhdXNlIFdBTCByZXBsYXkuIEZyb20gb3VyIHVuZGVyc3RhbmRpbmcsIHBnX2R1bXAKc2hvdWxk IGFscmVhZHkgaW1wbGljaXRseSBwaWNrIGEgc3VpdGFibGUgcG9pbnQgdG8gc3RhcnQgdGhlIGR1 bXAgYnV0IGl0CmFwcGFyZW50bHkgaXMgbm90IHRoZSBjYXNlLCBoZW5jZSB0aGUgYnVnIHJlcG9y dC4NCg0KVGhhbmtzIGZvciB0aGUgYXR0ZW50aW9uLA0KDQpGcmFuY2lzY28KCg== --===============8093939767180929375==--