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 1u3TBv-00GIts-RH for pgsql-general@arkaria.postgresql.org; Sat, 12 Apr 2025 05:14:07 +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 1u3TBu-001OhL-9Y for pgsql-general@arkaria.postgresql.org; Sat, 12 Apr 2025 05:14:06 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1u3TBt-001OhC-RN for pgsql-general@lists.postgresql.org; Sat, 12 Apr 2025 05:14:06 +0000 Received: from mail-oa1-x2a.google.com ([2001:4860:4864:20::2a]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u3TBr-004ruJ-2q for pgsql-general@postgresql.org; Sat, 12 Apr 2025 05:14:05 +0000 Received: by mail-oa1-x2a.google.com with SMTP id 586e51a60fabf-2b8e2606a58so1267218fac.0 for ; Fri, 11 Apr 2025 22:14:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1744434841; x=1745039641; darn=postgresql.org; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=He2IVMOw5SBmC+QlescxcS2fcoSkszq4aXUfSxo4dqc=; b=A8TuLQwVCquuQMZR3ShceTkSuuVqdqaiLIfFo1NXfivnrhS458m6nx4PQbVTzcezXO oNJKRJf20pzH/oSj24q1KrkWmFnpFDFWMgnlmlWNbeeLVb9pJCG8qg39NP/QPnSCc1L5 1UE7TKvfPJQlznE6gfGOF3yP9fvysGct+/rvsp3o0TqDQaLCIOSSpntxQps2NVrRy0h4 fDdGaiE8xs+h6a0AxaH42ex5wzfo4TCZ69Gp48jiahSk9bnm5zoK6p+8n+azvHjwggIX orP6nr7tDY+WLv6icfV9tTELSmzUjCtFEPBL5ZSuQVYPVKkyWCKYlw0JeS9NlLZ4rgBF /Lnw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1744434841; x=1745039641; h=cc:to:subject:message-id:date:from:references:in-reply-to :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=He2IVMOw5SBmC+QlescxcS2fcoSkszq4aXUfSxo4dqc=; b=aNatk88eyzjqpAiGS3kimJjME7XBKg9BkEc92Ex1+efi5j3M0NcYtGL8cRW9dZkUQw Rb+tIiEN4THk5OMCfec/XpZrype8IKQ3XMv5yqWxKT4kJNg0cmYDhUvZUHwJz+S4ddMZ s5bTZr3wKRSMxFcs12C3S6380nSwzReb8kfU4scTqI4/OHHPbcEw9dzJEwAcbwmqBzXs SJ2WD6mtR5wNeX+u86qY5t+da3Z1ixVcUxfis/AijjK0Z0kOJyRCky9wIymKbv+trulJ 6Gaa5MTtXs/buihO4cyOZAKw3m6ROeulw6t1Msxz+2BvH0IXORL8/1HvEzUcvgpFmUFv dEfw== X-Gm-Message-State: AOJu0Yzp3NWGU0nO71OsgFxjf1VIMC2QJdklkVRmCpSAVcerm/01dwko 3rtf2LBz/1LaLm6ztwqHwkNPqZHou3MzIHQYkMuYkdK5Bj8Asy73Q8heuwdTD4uWfv9YYu2EnT5 NhJqOdFYOBoii/H7jeoKVvIFfmHQ= X-Gm-Gg: ASbGncuYMHz/bqa/bTSOGZSWIQNFD36isjNzs9fB0hBFRLAa3Hs3WTBv5jiE860coGJ e519/sZ7jfE6oWp7q4WHtB/TPTWUynVO3vcg/pZiwEvG+GnYYYrpunxtEeKoxp2jNDywGuYVe2C bMlYx7pLOc/bu4kLrkATi6 X-Google-Smtp-Source: AGHT+IHBfHPeHJ1NCIspVyZawLg/eGsJdpLSSgGz1UwqGpYT8jTihXBNr7tBGPdp+VGY4WrOkAxRnmFBN14zznF0BCs= X-Received: by 2002:a05:6870:8301:b0:29e:1cd8:4a0f with SMTP id 586e51a60fabf-2d0d5d0dc8bmr2658712fac.17.1744434840919; Fri, 11 Apr 2025 22:14:00 -0700 (PDT) MIME-Version: 1.0 Received: by 2002:ac9:6a54:0:b0:589:13f9:e937 with HTTP; Fri, 11 Apr 2025 22:14:00 -0700 (PDT) In-Reply-To: <1494046583.828048.1744434369825@mail.yahoo.com> References: <1477036526.178965.1744376140698.ref@mail.yahoo.com> <1477036526.178965.1744376140698@mail.yahoo.com> <40a86c92-5fc9-447d-969e-2a61cc98629c@aklaver.com> <1494046583.828048.1744434369825@mail.yahoo.com> From: "David G. Johnston" Date: Fri, 11 Apr 2025 22:14:00 -0700 X-Gm-Features: ATxdqUGHsfZbGHt6OJp6N8-ZYfHj9rzGEo61SJRd8lJMTVcGde6H61Nt3s1063k Message-ID: Subject: Re: To take backup of Postgresql Database without large objects To: "sivapostgres@yahoo.com" Cc: Pgsql-general , Adrian Klaver Content-Type: multipart/alternative; boundary="00000000000006e72006328de34f" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000006e72006328de34f Content-Type: text/plain; charset="UTF-8" On Friday, April 11, 2025, sivapostgres@yahoo.com wrote: > > > bytea field also included in the backup. > Bytea typed columns are completely separate things than large objects. You cannot exclude individual columns using pg_dump. David J. --00000000000006e72006328de34f Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Friday, April 11, 2025, sivapo= stgres@yahoo.com <sivapost= gres@yahoo.com> wrote:

bytea field also included= in the backup.=C2=A0 =C2=A0

<= div>Bytea typed columns are completely separate things than large objects.= =C2=A0 You cannot exclude individual columns using pg_dump.

<= /div>
David J.

--00000000000006e72006328de34f--