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 <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1u3TYy-00GOdF-7B
	for pgsql-general@arkaria.postgresql.org; Sat, 12 Apr 2025 05:37:56 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1u3TYw-001gXM-5l
	for pgsql-general@arkaria.postgresql.org; Sat, 12 Apr 2025 05:37:54 +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 <xof@thebuild.com>)
	id 1u3TYv-001gWh-Oy
	for pgsql-general@lists.postgresql.org; Sat, 12 Apr 2025 05:37:54 +0000
Received: from smtp88.iad3b.emailsrvr.com ([146.20.161.88])
	by makus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <xof@thebuild.com>)
	id 1u3TYu-004QLJ-1B
	for pgsql-general@postgresql.org;
	Sat, 12 Apr 2025 05:37:53 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp12.relay.iad3b.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 07921C014D;
	Sat, 12 Apr 2025 01:37:50 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\))
Subject: Re: To take backup of Postgresql Database without large objects
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <312140824.825355.1744436092713@mail.yahoo.com>
Date: Fri, 11 Apr 2025 22:37:19 -0700
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
 Pgsql-general <pgsql-general@postgresql.org>,
 Adrian Klaver <adrian.klaver@aklaver.com>
Content-Transfer-Encoding: quoted-printable
Message-Id: <92A90844-8669-477C-90E9-41D619814D8C@thebuild.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>
 <CAKFQuwb+b3syAE=GSNT7hDySyCc=k98mn+EkeUs73O-dFcrcwA@mail.gmail.com>
 <312140824.825355.1744436092713@mail.yahoo.com>
To: "sivapostgres@yahoo.com" <sivapostgres@yahoo.com>
X-Mailer: Apple Mail (2.3776.700.51.11.1)
X-Classification-ID: 80b88151-e2c6-422d-97cc-c5463746b391-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/92A90844-8669-477C-90E9-41D619814D8C%40thebuild.com>
Precedence: bulk



> On Apr 11, 2025, at 22:34, sivapostgres@yahoo.com wrote:
> Then I've misunderstood large objects.  Is there document to explain =
large objects? =20

Large objects are a relatively old and now little-used feature of =
PostgreSQL that predates the bytea type:

	https://www.postgresql.org/docs/current/largeobjects.html

As was mentioned, you cannot exclude individual columns with pg_dump; =
you have to exclude the entire table.=