> On Jan 26, 2026, at 11:24, [email protected] wrote:
>
> A full database backup is the requirement. A database restore is optional,
> but that's negotiable; the backup is not.
> 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.
