Time between backup and FTP upload keeps database in backup mode?

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?

Hi Jeroen_Guldemond,

SQLBackupAndFTP performers a backup without blocking a database. Also, after the dump is completed, the application does not connect to the database. Perhaps you face the issue due to heavy usage of your disk while uploading a backup file to a destination.

If you have any other questions, please let us know.

Thank you and sorry for the inconvenience.