Currently each dump/restore of PostgreSQL database takes two steps…
- Dump to the temp folder
- Copy file to the final destination
- Copy file to the temp folder
- Actual restore
It causes double time for the whole process.
Since we have Custom and TAR formats in addition to Plain text dump it would be good to add the bypass option for copying the file to the dump and restore process which will decrease twice the job duration.