Check out Abot! You can optionally use the --jobs flag to parallelise the dump operation, although this requires changing the output format to "directory" by using the -F d argument instead of -F c. Point in time restore would even have the same problem, although less pronounced. This article explains how to take manual and scheduled logical backups, show existing backups, restore backups, and transfer data directly between two databases. For these databases, you can retrieve your Postgres connection string to run the script outside of Heroku.
nest...