{"id":71,"date":"2024-03-27T05:03:51","date_gmt":"2024-03-27T05:03:51","guid":{"rendered":"https:\/\/docs.sqlbackupandftp.com\/docs\/how-it-works\/backup-job\/connection-settings\/postgresql\/"},"modified":"2024-07-08T18:39:24","modified_gmt":"2024-07-08T18:39:24","slug":"postgresql","status":"publish","type":"docs","link":"http:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/","title":{"rendered":"PostgreSQL"},"content":{"rendered":"

To configure the connection to your PostgreSQL Server databases, select PostgreSQL Server (TCP\/IP)<\/strong> as your server type.<\/p>\n

\"\"<\/p>\n

Required minimum settings<\/h3>\n

In the opened window, specify:<\/p>\n

    \n
  1. Your server’s name<\/li>\n
  2. Port, if it differs from the default port 5432<\/li>\n
  3. User name and password<\/li>\n<\/ol>\n

    These are the basic minimum settings. Once they are ready, you can test the connection and save the settings.<\/p>\n

    Advanced connection settings<\/h3>\n

    For more specific settings go to Advanced settings,<\/strong> where you can set:<\/p>\n

      \n
    1. Default database name<\/li>\n
    2. SSL Mode<\/li>\n
    3. Path to PostgreSQL bin folder. Specify the path to the PostgreSQL bin folders in case you encounter version compatibility issues for example, “C:\\Program Files\\PostgreSQL\\16\\bin.”<\/li>\n
    4. The way the password will be passed can be either via environment variables<\/a> or via a password file<\/a>.\"\"<\/li>\n<\/ol>\n

      Connect using SSH tunnel<\/h3>\n

      If an SSH tunnel is required for the connection enable the Connect using SSH tunnel<\/strong> option in the advanced settings and specify:<\/p>\n

        \n
      1. Your hostname<\/li>\n
      2. SSH port<\/li>\n
      3. Local mapped port<\/li>\n
      4. User name<\/li>\n
      5. Choose the authentication method which can be either a password or a key file<\/li>\n
      6. Enter the password or specify the path to where the key file is located\"\"<\/li>\n<\/ol>\n

        After configuring the settings, you can test the connection and save the settings.<\/p>\n

        Info button<\/h3>\n

        If you click the “info” button in the connection settings, you will see the command used to connect to the database. If you encounter connection issues, you can manually execute this command via the command line to diagnose the problem.<\/p>\n

        \"\"<\/p>\n","protected":false},"featured_media":0,"parent":68,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","doc_tag":[],"class_list":["post-71","docs","type-docs","status-publish","hentry"],"yoast_head":"\nPostgreSQL - SQLBackupAndFTP Documentation<\/title>\n<meta name=\"description\" content=\"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL - SQLBackupAndFTP Documentation\" \/>\n<meta property=\"og:description\" content=\"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/\" \/>\n<meta property=\"og:site_name\" content=\"SQLBackupAndFTP Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-08T18:39:24+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-PostgreSQL-Server.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/\",\"url\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/\",\"name\":\"PostgreSQL - SQLBackupAndFTP Documentation\",\"isPartOf\":{\"@id\":\"http:\/\/docs.sqlbackupandftp.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-PostgreSQL-Server.png\",\"datePublished\":\"2024-03-27T05:03:51+00:00\",\"dateModified\":\"2024-07-08T18:39:24+00:00\",\"description\":\"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/#primaryimage\",\"url\":\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-PostgreSQL-Server.png\",\"contentUrl\":\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-PostgreSQL-Server.png\",\"width\":626,\"height\":580},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/docs.sqlbackupandftp.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Job Settings\",\"item\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Backup Job\",\"item\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Connection Settings\",\"item\":\"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/docs.sqlbackupandftp.com\/#website\",\"url\":\"http:\/\/docs.sqlbackupandftp.com\/\",\"name\":\"SQLBackupAndFTP Documentation\",\"description\":\"\",\"publisher\":{\"@id\":\"http:\/\/docs.sqlbackupandftp.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/docs.sqlbackupandftp.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/docs.sqlbackupandftp.com\/#organization\",\"name\":\"pranas.net\",\"url\":\"http:\/\/docs.sqlbackupandftp.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/docs.sqlbackupandftp.com\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/04\/SbfLogo80.png\",\"contentUrl\":\"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/04\/SbfLogo80.png\",\"width\":80,\"height\":80,\"caption\":\"pranas.net\"},\"image\":{\"@id\":\"http:\/\/docs.sqlbackupandftp.com\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL - SQLBackupAndFTP Documentation","description":"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL - SQLBackupAndFTP Documentation","og_description":"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.","og_url":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/","og_site_name":"SQLBackupAndFTP Documentation","article_modified_time":"2024-07-08T18:39:24+00:00","og_image":[{"url":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-PostgreSQL-Server.png"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/","url":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/","name":"PostgreSQL - SQLBackupAndFTP Documentation","isPartOf":{"@id":"http:\/\/docs.sqlbackupandftp.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/#primaryimage"},"image":{"@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/#primaryimage"},"thumbnailUrl":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-PostgreSQL-Server.png","datePublished":"2024-03-27T05:03:51+00:00","dateModified":"2024-07-08T18:39:24+00:00","description":"Comprehensive documentation for SQLBackupAndFTP, the ultimate tool for SQL Server backups. Learn how to install, configure, and use all features.","breadcrumb":{"@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/#primaryimage","url":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-PostgreSQL-Server.png","contentUrl":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/03\/SQLBackupAndFTP-PostgreSQL-Server.png","width":626,"height":580},{"@type":"BreadcrumbList","@id":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/postgresql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/docs.sqlbackupandftp.com\/"},{"@type":"ListItem","position":2,"name":"Job Settings","item":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/"},{"@type":"ListItem","position":3,"name":"Backup Job","item":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/"},{"@type":"ListItem","position":4,"name":"Connection Settings","item":"https:\/\/docs.sqlbackupandftp.com\/docs\/job-settings\/backup-job\/connection-settings\/"},{"@type":"ListItem","position":5,"name":"PostgreSQL"}]},{"@type":"WebSite","@id":"http:\/\/docs.sqlbackupandftp.com\/#website","url":"http:\/\/docs.sqlbackupandftp.com\/","name":"SQLBackupAndFTP Documentation","description":"","publisher":{"@id":"http:\/\/docs.sqlbackupandftp.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/docs.sqlbackupandftp.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/docs.sqlbackupandftp.com\/#organization","name":"pranas.net","url":"http:\/\/docs.sqlbackupandftp.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/docs.sqlbackupandftp.com\/#\/schema\/logo\/image\/","url":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/04\/SbfLogo80.png","contentUrl":"http:\/\/docs.sqlbackupandftp.com\/wp-content\/uploads\/2024\/04\/SbfLogo80.png","width":80,"height":80,"caption":"pranas.net"},"image":{"@id":"http:\/\/docs.sqlbackupandftp.com\/#\/schema\/logo\/image\/"}}]}},"comment_count":0,"_links":{"self":[{"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs\/71","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/types\/docs"}],"replies":[{"embeddable":true,"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/comments?post=71"}],"version-history":[{"count":5,"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs\/71\/revisions"}],"predecessor-version":[{"id":1241,"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs\/71\/revisions\/1241"}],"up":[{"embeddable":true,"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/docs\/68"}],"wp:attachment":[{"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/media?parent=71"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"http:\/\/docs.sqlbackupandftp.com\/wp-json\/wp\/v2\/doc_tag?post=71"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}