Starting from SqlBak app version 3 you can backup and restore your PostgreSQL databases. The SqlBak app creates the backups of PostgreSQL databases via pg_dump. Currently, only full database backups can be performed for PostgreSQL Server databases.
Here is a detailed tutorial on how to create a backup job to perform scheduled backups of your PostgreSQL Server databases.
Firstly, you have to set a connection to your PostgreSQL Server. To do it, open SqlBak App and click on the “Add” button. From the drop-down list choose “PostgreSQL Server (TCP/IP)” as your DBMS type.
At the opened window specify your “Server name”, “Username”, and your “Password”, then click on the “Test Connection” button, to make sure that the connection is established.
After the connection is tested, it’s time to create a backup job. To do it, open the “Dashboard” page and click on the “Add new job” button.
To set a schedule for your backup job, scroll down to the “Schedule backups” section, and add the settings you need.
These are all the basic settings, but you also can set encryption and compression for your backups, add custom scripts to your backup plan, backup local files and folders, and set a restore process. To apply all the settings and run your backup job, click on the “Save&Exit” button in the right upper corner.