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 1nU81i-0007rJ-Fn for pgsql-docs@arkaria.postgresql.org; Tue, 15 Mar 2022 14:19:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nU81h-0007VB-Bd for pgsql-docs@arkaria.postgresql.org; Tue, 15 Mar 2022 14:19:53 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nU81h-0007V2-2g for pgsql-docs@lists.postgresql.org; Tue, 15 Mar 2022 14:19:53 +0000 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1nU81e-00068v-VK for pgsql-docs@lists.postgresql.org; Tue, 15 Mar 2022 14:19:52 +0000 Received: by mail-ej1-x629.google.com with SMTP id r13so41700260ejd.5 for ; Tue, 15 Mar 2022 07:19:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=message-id:date:mime-version:user-agent:to:from:subject; bh=70Dcce1EAYSjQKV72rKvOEgBxN6/HyuXMvcMHtVT8mo=; b=A2qCPCSPr2xuO5qBm6ttB0P+/7vgSw2VNTr/gY1YFEyJc+GUbdEaU4KMTU+ZZZubaq slXgm97pf3YzhnFX2jMvBo6JNJOc6IIyaLAYLzPvcpWxxX27a+pjTePIp9aQp0orhzdw qqM1jL4DKZ867Q1w757i3xoFadf1Y18DOox8pJ0d7y8kmWRr4IaLGVma7PVvOChuQSO5 PxYzqzh8DqapDCshlg9QSmVLSbJvqDA2gsgkp7zhKVr8VlEyg10HW+kJ7n0JLiotly+6 VkdRy5n3oX85qe2kTaAGuZyWxdSliTgpZ4hDY8kUGrho22qarLMFCB0iOuNzPVBByDOI amcQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:date:mime-version:user-agent:to:from :subject; bh=70Dcce1EAYSjQKV72rKvOEgBxN6/HyuXMvcMHtVT8mo=; b=mnrD7JlWgnXu9rQScxC+YHpSH0vvDNUo4sCP+RrykNfrg1BaFmS5UoqAZMH0i7ILiz 5vruHFnuhYhF/5kSun3kc08EX+QDKh2ordm+JXAdKNPbcADH+wrgXYof7TI//IaLgCru 1taLzI0K2LL63K+r3PkpP9rvg5zAKsWCaZs8SCz/wLpz2Ol4SH68YxbC2HNjkehgr5FP almTUovULRN047L6mgXORjiw6j5fnTQreoC+gw2ABXdDghyFEVzbeNazpujs4MMGU8du 3ZK73/Lq4dNLhaTpdHV5M5z1kyAuMA2Y18/4wQuuS7FfyLcjoZPVM+J2HeQFUE1jTtXb yA2A== X-Gm-Message-State: AOAM532nFb0uqAp9+1uwk4ZZAJaYDPIa63JR0osIuBew0I3kRnXeTR4s cJHo8V/nLK0QtlrLs3h7YE2ocm/ni0gz2Q== X-Google-Smtp-Source: ABdhPJxUr8AbXm0j3YRF1MWXzVmOb8vjtzTuxfU5x1F23F+dU6d94gaWr0TJ6JAQPPYctCxsCigWGA== X-Received: by 2002:a17:906:b1d0:b0:6cd:fa02:b427 with SMTP id bv16-20020a170906b1d000b006cdfa02b427mr23102763ejb.99.1647353989633; Tue, 15 Mar 2022 07:19:49 -0700 (PDT) Received: from [192.168.5.23] (net-93-145-27-202.cust.vodafonedsl.it. [93.145.27.202]) by smtp.gmail.com with ESMTPSA id t14-20020a170906608e00b006d1455acc62sm8111253ejj.74.2022.03.15.07.19.48 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 15 Mar 2022 07:19:49 -0700 (PDT) Content-Type: multipart/mixed; boundary="------------7DfAo7dsT00VzpEqbaGtt8ad" Message-ID: Date: Tue, 15 Mar 2022 15:19:47 +0100 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0) Gecko/20100101 Thunderbird/91.6.1 To: pgsql-docs@lists.postgresql.org From: Florin Irion Subject: pg_dump shared locks documentation List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------7DfAo7dsT00VzpEqbaGtt8ad Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi, In the `pg_dump` documentation we talk about "shared locks", but IIUC, we actually take `AccessShareLock`s. This might be misunderstood with the `ShareLock`. There are 5 occurrences. 4 in `--jobs=njobs` and 1 in `--lock-wait-timeout=timeout` sections. Cheers, Florin Irion --------------7DfAo7dsT00VzpEqbaGtt8ad Content-Type: text/plain; charset=UTF-8; name="0001-doc-Specify-correctly-the-locks-pg_dump-takes.patch" Content-Disposition: attachment; filename="0001-doc-Specify-correctly-the-locks-pg_dump-takes.patch" Content-Transfer-Encoding: base64 RnJvbSA2M2FkYjFkM2EyNTJkNzhhMTE1YTBiYWUzZTljNmJjMDhiN2FlODNmIE1vbiBTZXAg MTcgMDA6MDA6MDAgMjAwMQpGcm9tOiBGbG9yaW4gSXJpb24gPGZsb3Jpbi5pcmlvbkBlbnRl cnByaXNlZGIuY29tPgpEYXRlOiBUdWUsIDE1IE1hciAyMDIyIDE1OjA5OjExICswMTAwClN1 YmplY3Q6IFtQQVRDSF0gZG9jOiBTcGVjaWZ5IGNvcnJlY3RseSB0aGUgbG9ja3MgcGdfZHVt cCB0YWtlcwoKVGhlIHBnX2R1bXAgbGVhZGVyIGFuZCB3b3JrZXIgcHJvY2Vzc2VzIHRha2Ug YEFjY2Vzc1NoYXJlTG9ja2BzLApjbGFyaWZ5IGl0IGluIHRoZSBkb2NzIHNvIHRoYXQgaXQg Y2FuIG5vdCBiZSBtaXN1bmRlcnN0b29kIHdpdGgKYFNoYXJlTG9ja2BzLgotLS0KIGRvYy9z cmMvc2dtbC9yZWYvcGdfZHVtcC5zZ21sIHwgMTAgKysrKystLS0tLQogMSBmaWxlIGNoYW5n ZWQsIDUgaW5zZXJ0aW9ucygrKSwgNSBkZWxldGlvbnMoLSkKCmRpZmYgLS1naXQgYS9kb2Mv c3JjL3NnbWwvcmVmL3BnX2R1bXAuc2dtbCBiL2RvYy9zcmMvc2dtbC9yZWYvcGdfZHVtcC5z Z21sCmluZGV4IDJmMDA0MmZkOTYuLjVmOTViMTZlOTggMTAwNjQ0Ci0tLSBhL2RvYy9zcmMv c2dtbC9yZWYvcGdfZHVtcC5zZ21sCisrKyBiL2RvYy9zcmMvc2dtbC9yZWYvcGdfZHVtcC5z Z21sCkBAIC0zNzIsMTcgKzM3MiwxNyBAQCBQb3N0Z3JlU1FMIGRvY3VtZW50YXRpb24KICAg ICAgICA8cGFyYT4KICAgICAgICAgUmVxdWVzdGluZyBleGNsdXNpdmUgbG9ja3Mgb24gZGF0 YWJhc2Ugb2JqZWN0cyB3aGlsZSBydW5uaW5nIGEgcGFyYWxsZWwgZHVtcCBjb3VsZAogICAg ICAgICBjYXVzZSB0aGUgZHVtcCB0byBmYWlsLiBUaGUgcmVhc29uIGlzIHRoYXQgdGhlIDxh cHBsaWNhdGlvbj5wZ19kdW1wPC9hcHBsaWNhdGlvbj4gbGVhZGVyIHByb2Nlc3MKLSAgICAg ICAgcmVxdWVzdHMgc2hhcmVkIGxvY2tzIG9uIHRoZSBvYmplY3RzIHRoYXQgdGhlIHdvcmtl ciBwcm9jZXNzZXMgYXJlIGdvaW5nIHRvIGR1bXAgbGF0ZXIKKyAgICAgICAgcmVxdWVzdHMg YWNjZXNzIHNoYXJlIGxvY2tzIG9uIHRoZSBvYmplY3RzIHRoYXQgdGhlIHdvcmtlciBwcm9j ZXNzZXMgYXJlIGdvaW5nIHRvIGR1bXAgbGF0ZXIKICAgICAgICAgaW4gb3JkZXIgdG8KICAg ICAgICAgbWFrZSBzdXJlIHRoYXQgbm9ib2R5IGRlbGV0ZXMgdGhlbSBhbmQgbWFrZXMgdGhl bSBnbyBhd2F5IHdoaWxlIHRoZSBkdW1wIGlzIHJ1bm5pbmcuCiAgICAgICAgIElmIGFub3Ro ZXIgY2xpZW50IHRoZW4gcmVxdWVzdHMgYW4gZXhjbHVzaXZlIGxvY2sgb24gYSB0YWJsZSwg dGhhdCBsb2NrIHdpbGwgbm90IGJlCi0gICAgICAgIGdyYW50ZWQgYnV0IHdpbGwgYmUgcXVl dWVkIHdhaXRpbmcgZm9yIHRoZSBzaGFyZWQgbG9jayBvZiB0aGUgbGVhZGVyIHByb2Nlc3Mg dG8gYmUKKyAgICAgICAgZ3JhbnRlZCBidXQgd2lsbCBiZSBxdWV1ZWQgd2FpdGluZyBmb3Ig dGhlIGFjY2VzcyBzaGFyZSBsb2NrIG9mIHRoZSBsZWFkZXIgcHJvY2VzcyB0byBiZQogICAg ICAgICByZWxlYXNlZC4gQ29uc2VxdWVudGx5IGFueSBvdGhlciBhY2Nlc3MgdG8gdGhlIHRh YmxlIHdpbGwgbm90IGJlIGdyYW50ZWQgZWl0aGVyIGFuZAogICAgICAgICB3aWxsIHF1ZXVl IGFmdGVyIHRoZSBleGNsdXNpdmUgbG9jayByZXF1ZXN0LiBUaGlzIGluY2x1ZGVzIHRoZSB3 b3JrZXIgcHJvY2VzcyB0cnlpbmcKICAgICAgICAgdG8gZHVtcCB0aGUgdGFibGUuIFdpdGhv dXQgYW55IHByZWNhdXRpb25zIHRoaXMgd291bGQgYmUgYSBjbGFzc2ljIGRlYWRsb2NrIHNp dHVhdGlvbi4KICAgICAgICAgVG8gZGV0ZWN0IHRoaXMgY29uZmxpY3QsIHRoZSA8YXBwbGlj YXRpb24+cGdfZHVtcDwvYXBwbGljYXRpb24+IHdvcmtlciBwcm9jZXNzIHJlcXVlc3RzIGFu b3RoZXIKLSAgICAgICAgc2hhcmVkIGxvY2sgdXNpbmcgdGhlIDxsaXRlcmFsPk5PV0FJVDwv bGl0ZXJhbD4gb3B0aW9uLiBJZiB0aGUgd29ya2VyIHByb2Nlc3MgaXMgbm90IGdyYW50ZWQK LSAgICAgICAgdGhpcyBzaGFyZWQgbG9jaywgc29tZWJvZHkgZWxzZSBtdXN0IGhhdmUgcmVx dWVzdGVkIGFuIGV4Y2x1c2l2ZSBsb2NrIGluIHRoZSBtZWFudGltZQorICAgICAgICBhY2Nl c3Mgc2hhcmUgbG9jayB1c2luZyB0aGUgPGxpdGVyYWw+Tk9XQUlUPC9saXRlcmFsPiBvcHRp b24uIElmIHRoZSB3b3JrZXIgcHJvY2VzcyBpcyBub3QgZ3JhbnRlZAorICAgICAgICB0aGlz IGFjY2VzcyBzaGFyZSBsb2NrLCBzb21lYm9keSBlbHNlIG11c3QgaGF2ZSByZXF1ZXN0ZWQg YW4gZXhjbHVzaXZlIGxvY2sgaW4gdGhlIG1lYW50aW1lCiAgICAgICAgIGFuZCB0aGVyZSBp cyBubyB3YXkgdG8gY29udGludWUgd2l0aCB0aGUgZHVtcCwgc28gPGFwcGxpY2F0aW9uPnBn X2R1bXA8L2FwcGxpY2F0aW9uPiBoYXMgbm8gY2hvaWNlCiAgICAgICAgIGJ1dCB0byBhYm9y dCB0aGUgZHVtcC4KICAgICAgICA8L3BhcmE+CkBAIC04NzAsNyArODcwLDcgQEAgUG9zdGdy ZVNRTCBkb2N1bWVudGF0aW9uCiAgICAgICA8dGVybT48b3B0aW9uPi0tbG9jay13YWl0LXRp bWVvdXQ9PHJlcGxhY2VhYmxlIGNsYXNzPSJwYXJhbWV0ZXIiPnRpbWVvdXQ8L3JlcGxhY2Vh YmxlPjwvb3B0aW9uPjwvdGVybT4KICAgICAgIDxsaXN0aXRlbT4KICAgICAgICA8cGFyYT4K LSAgICAgICAgRG8gbm90IHdhaXQgZm9yZXZlciB0byBhY3F1aXJlIHNoYXJlZCB0YWJsZSBs b2NrcyBhdCB0aGUgYmVnaW5uaW5nIG9mCisgICAgICAgIERvIG5vdCB3YWl0IGZvcmV2ZXIg dG8gYWNxdWlyZSBhY2Nlc3Mgc2hhcmUgdGFibGUgbG9ja3MgYXQgdGhlIGJlZ2lubmluZyBv ZgogICAgICAgICB0aGUgZHVtcC4gSW5zdGVhZCBmYWlsIGlmIHVuYWJsZSB0byBsb2NrIGEg dGFibGUgd2l0aGluIHRoZSBzcGVjaWZpZWQKICAgICAgICAgPHJlcGxhY2VhYmxlIGNsYXNz PSJwYXJhbWV0ZXIiPnRpbWVvdXQ8L3JlcGxhY2VhYmxlPi4gVGhlIHRpbWVvdXQgbWF5IGJl CiAgICAgICAgIHNwZWNpZmllZCBpbiBhbnkgb2YgdGhlIGZvcm1hdHMgYWNjZXB0ZWQgYnkg PGNvbW1hbmQ+U0VUCi0tIAoyLjM0LjAKCg== --------------7DfAo7dsT00VzpEqbaGtt8ad--