Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.8\))
Subject: Re: About backups
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <1244937982.4358855.1769455485523@mail.yahoo.com>
Date: Mon, 26 Jan 2026 12:11:22 -0800
Cc: pgsql-general@lists.postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <8C907CFF-EF9A-4BD8-A9B9-47DCC8D1A65E@thebuild.com>
References: <1730736265.4259921.1769443263077.ref@mail.yahoo.com>
 <1730736265.4259921.1769443263077@mail.yahoo.com>
 <f88a803f-2954-44c5-bd29-e7f1dc5f9d02@aklaver.com>
 <CANzqJaAygQG3F3fKe25YV765kUkO=UQqefACpo+2KQJXew7g-Q@mail.gmail.com>
 <868938296.4311067.1769449951678@mail.yahoo.com>
 <CANzqJaBnBBAWO7ot2V+oSNpR7VSnkAELMX0aqZcP=rHs2ddoig@mail.gmail.com>
 <2022327491.4341234.1769452625380@mail.yahoo.com>
 <32C440DF-84C3-48D3-AF25-C0D977359F56@thebuild.com>
 <1244937982.4358855.1769455485523@mail.yahoo.com>
To: felix.quintgz@yahoo.com
Archived-At: <https://www.postgresql.org/message-id/8C907CFF-EF9A-4BD8-A9B9-47DCC8D1A65E%40thebuild.com>
Precedence: bulk


> On Jan 26, 2026, at 11:24, felix.quintgz@yahoo.com wrote:
>=20
> A full database backup is the requirement. A database restore is =
optional, but that's negotiable; the backup is not.=20
> All of this must be done without access to the server or the database =
itself, solely through the application, and the user must have the =
necessary permissions within the application.

In that case, running pg_dump on the application server is probably the =
way to go.  pg_dump can produce a single file that can be used to do a =
full restore, and it's smaller than an equivalent bindary backup (since =
it includes index definitions, but not the contents of the index =
itself).  Of course, if it's a 100GB database, you'll end up with a huge =
file no matter what, but nothing to do about that.=