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 1rBIr2-00AKPK-UC for pgsql-admin@arkaria.postgresql.org; Thu, 07 Dec 2023 18:12:08 +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 1rBIr1-001ThO-8M for pgsql-admin@arkaria.postgresql.org; Thu, 07 Dec 2023 18:12:07 +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 1rBIr0-001ThF-T9 for pgsql-admin@lists.postgresql.org; Thu, 07 Dec 2023 18:12:06 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rBIqy-009Hnp-Jr for pgsql-admin@lists.postgresql.org; Thu, 07 Dec 2023 18:12:05 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-1f03d9ad89fso734935fac.1 for ; Thu, 07 Dec 2023 10:12:04 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1701972723; x=1702577523; darn=lists.postgresql.org; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=7hQbwXp/G6tFYGCMbQF3wUnxw5GM9Z9HexQ5frtO9TE=; b=UubtvC4dPVq38QwOcfk2aVcVMbugSJJ/b/WQt1MHYtBQ0aAwq1SyfIlssWBRUucMXA uVTLr4NNX21nA1BgGUtQlz2hDUUP0ewoTdKaL3Je4eGqrisQvtum0Q9/ERqjEHThLUsL 0WVZX1nglMTPDl04giuVQap11RIrb70mRaf31+9Hv0BBnargGsa+Qs35/IxMGmMOVyXq 1/Ouwvx89iULQaL+0jPcjQ/9enPQa88a0H+a/mO36a0n9GWg4YzqUg0Z9sUcdPsS3sZU fi1CbkVDr6Uq1fUuU9epYJtTykssNVgAWP4ONeOA1gsSfzkVEzzmSt6Jj2ao69+EZOKT sRBg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1701972723; x=1702577523; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=7hQbwXp/G6tFYGCMbQF3wUnxw5GM9Z9HexQ5frtO9TE=; b=E/USDfNODQZUhCksX2EGzLmoXf2Z6MzLmrYed2sQiXcXiAtNk47B2Z/kHcmH/tSPHz h8vNSyBX2/UeRdKVu9Ke8tHt1ZcNY29JcG4eSDiR4ERkK3Uln9zkhZv1LLZwbG+5gUhr lVyIYmaN+5AJGhEeU3j1FWhOkNLYsi7QK+rs+3+jDdwX2bP/mjzzpawn8DLnyIR8/OpA hAI10P0b3pnDDQXcKeqQipzLgQzg5yqsxPqifRvpWd/7eCJ+K5rdboAHsS1zum/HpzN3 ej6NigmBZUUlFO9TJ1p9Li//SmyWEsauxN1fZ33cVtHDUAOy1kFezME8nQqCxfCzWk01 a7Ag== X-Gm-Message-State: AOJu0YzvSjSghUX5tclhSnJvbMRDUtYPBgpV1Sz4wtVEQj7qSv1IUgRE 6Z2p0OU1+V3oqdbHHo1ajmOmf7+02W6aZu3UmwGy9h4UjwA= X-Google-Smtp-Source: AGHT+IHFUCdDoFX/dYCfGr3M/1rljhNHpvk77XL+WR32Ei68rXM+DohSMd51A+mx0PYlMgcsHAt4D5JjqEOngBH1xoc= X-Received: by 2002:a05:6870:7188:b0:1fb:75a:6d35 with SMTP id d8-20020a056870718800b001fb075a6d35mr3578328oah.92.1701972722621; Thu, 07 Dec 2023 10:12:02 -0800 (PST) MIME-Version: 1.0 From: Rajesh Kumar Date: Thu, 7 Dec 2023 23:41:50 +0530 Message-ID: Subject: Pg_dump To: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000008ca266060bef6727" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000008ca266060bef6727 Content-Type: text/plain; charset="UTF-8" Hi Will pg_dump cause blocking queries? If so how to take dump without blocking? --0000000000008ca266060bef6727 Content-Type: text/html; charset="UTF-8"
Hi

Will pg_dump cause blocking queries? If so how to take dump without blocking?
--0000000000008ca266060bef6727--