I just purchased the standard license today and was setting up backup jobs. However, I can’t create multiple PostgreSQL Server (Physical backup) jobs because when I edit the second (or third) Job’s source server it updates the Server Name across all jobs.
Job 1
I create the job with the server name “127.0.0.1”
Then I created Job 2 with server name in the connection to “pg.stephensdev.com”
when I go back to Job 1 it now reads as “pg.stephensdev.com”…
Hi Michael,
Thank you for your message.
1) PostgreSQL Physical backup works only if SQLBackupAndFTP is installed on the same machine where the PostgreSQL server is running. If pg.stephensdev.com is a remote PostgreSQL server, then physical backup is not supported in that scenario. In that case, you can use PostgreSQL Server (SQL dump) connection instead.
2) If you need multiple jobs that connect to the same host but use different credentials/ports/settings, please use block comments while specifying the server’s name:
127.0.0.1 /* any discription 1 */
127.0.0.1 /* any discription 2 */
127.0.0.1 /* any discription 3 */
This allows you to keep separate connection entries and configure each independently. Please see: Connection Settings.