> On Jan 26, 2026, at 11:24, felix.quintgz@yahoo.com 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
usermust 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
thatcan 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
fileno matter what, but nothing to do about that.
