We make a backup of a large Postgress DB (250Gb) this takes about 1 to 1.5 hours.
Then we use FTP to transfer it to a Strato HiDrive. This takes between 1 to 2 hours depending on the transferspeed.
During the FTP transfer the database is still in somekind of backup mode and transactions are held somewhere else according to Postgress logic. Then after the FTP job is finished this is committed to the actual database. This however results in a unavailable database during a short time. But this time increases if the FTP transfer takes longer.
Is it possible to ‘clear’ or release the database connection before starting any backup transfers (in our case (S)FTP) to keep transaction buffering minimal?