Automatically backup ALL DB's on a server?

The workflow and software we use here means users frequently create new databases (PostGreSQL 9.5). One of our two servers has nearly 100 DB’s.

I haven’t bought ‘SQL Backup and FTP’ yet, I’m considering it. Is there a way to set it up, or do some effective scripting, so it’d automatically backup all the DB’s? Without having to configure each DB, and especially when new DBs are created, without having to manually update the backup configuration.

Hi Drew_Lahat,

Yes, you can do it, just check off the “Backup all non-system databases” option during your backup jobs settings.


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

Thank you!