Re: About backups

> On Jan 26, 2026, at 11:24, felix(dot)quintgz(at)yahoo(dot)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 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.