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 1m5Qtp-0006zT-8Z for pgsql-admin@arkaria.postgresql.org; Mon, 19 Jul 2021 10:53:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m5Qtn-0003jB-RD for pgsql-admin@arkaria.postgresql.org; Mon, 19 Jul 2021 10:53:23 +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 1m5Qtn-0003gB-Ek for pgsql-admin@lists.postgresql.org; Mon, 19 Jul 2021 10:53:23 +0000 Received: from mail-wm1-x32d.google.com ([2a00:1450:4864:20::32d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m5Qtg-0000pM-B7 for pgsql-admin@lists.postgresql.org; Mon, 19 Jul 2021 10:53:22 +0000 Received: by mail-wm1-x32d.google.com with SMTP id a23-20020a05600c2257b0290236ec98bebaso7761982wmm.1 for ; Mon, 19 Jul 2021 03:53:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=gtWRF1qPegNNU92X2cW0uXcIBshs3hmO0rjlNTa6bdo=; b=SrO7IB8tn8HMWmPf0ER12w0WcHDlIAEPW5FZvhHSSICRwSqwqjaIN3yNF4r+oflc/X LKTQ7w83agoZroHPU4zh7kAxtGNbMIKqguT4BU2AbU1gyxJNKEqBV5X+HZWU3VXTBvh4 thGbZ3CKTnUKTgNfk6o5888oimCHBHiJih39LsOSBWIkmn3gMSFbVtYfM1cK8qbkAQIH ezF0EnVPWjeFclnthqk1JJaga22zXKbYnazohdAv4Df3Gg0tQpwkUxJox+HYWN2I04eS fy0Uov1AWyIal9CCHScdOS9NejicN/+d948PDKw+M03mDXY0jQBcuAezG7XzjtmmywdX 5NVg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=gtWRF1qPegNNU92X2cW0uXcIBshs3hmO0rjlNTa6bdo=; b=ZDwwLBXD6vVLs8GKBin4e/LiNLuMkmWo1nnXDi5xjpqgjWzy67JI5i8bo35iGDNRMd +3KxHDvja2ogwejf0ReBPDPHiq8beA0QdriARi73Sebl/zbe1C9tkOLtcQmprg1zE0Aq XSgwVNoQt0fHTvav8MnXvs9hRoHWpcsAryrt6g7mU+lC+j/pDFNXxnOI6po0BM7s0arr 3NlohDX5chIZuIspFW9iAXaw3wuKMcET+1zMZeNGycmiztiLhvBKG/QoQqzIhtFu1BGS rfXNeGAA9dbZiheb47ODhePYfDLMy7pOP8HgEte+lsz4LSC+kKcmDyjJTVLGmsCTZEJh +Q+w== X-Gm-Message-State: AOAM532DEIu22sv7hRthyhImbhY6vOJUm+q5LxOIJt4LshT58Gt485PY 8pHmlAzpRSMdSqnYEJuJpyerRw== X-Google-Smtp-Source: ABdhPJyt9ohDvXCeadaJ8tc7serQCDVGMST2d+W8ul7jJm8ZDY64ynqDvk7qZ27Vh5pEbxWdZdtrmQ== X-Received: by 2002:a05:600c:2142:: with SMTP id v2mr25440583wml.121.1626691993928; Mon, 19 Jul 2021 03:53:13 -0700 (PDT) Received: from localhost.localdomain (217-149-171-226.nat.highway.telekom.at. [217.149.171.226]) by smtp.gmail.com with ESMTPSA id k24sm20554721wrh.30.2021.07.19.03.53.13 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 19 Jul 2021 03:53:13 -0700 (PDT) Message-ID: Subject: Re: pg_dump and locks From: Laurenz Albe To: Yambu , Pgsql-admin Date: Mon, 19 Jul 2021 12:53:13 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 2021-07-19 at 12:37 +0200, Yambu wrote: > May i know if pg_dump locks tables , and prevents updates/deletions or inserts on tables being dumped? I locks tables, but these locks don't prevent concurrent data modification. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com