If you are self-hosted and want to download the backup you can do it via ssh/scp. Another option is to have backups stored on S3. Downloading them via the web browser is not a reliable way to automate the process.
If you want that level of being able to go back in time then you should configure postgres to allow rollbacks and/or have a live backup server.