{"id":17569,"date":"2025-09-05T13:07:25","date_gmt":"2025-09-05T10:07:25","guid":{"rendered":"https:\/\/unihost.com\/help\/?p=17569"},"modified":"2025-09-05T13:07:25","modified_gmt":"2025-09-05T10:07:25","slug":"installing-postgresql-database-server-via-portainer-template","status":"publish","type":"post","link":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/","title":{"rendered":"Installing PostgreSQL database server via Portainer template"},"content":{"rendered":"<p><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">PostgreSQL is a powerful, open source object-relational database system that is easy to deploy in containers. In this article, we will look at how to quickly install a PostgreSQL server in Portainer using a ready-made template.<!--more--><\/span><\/p>\n<p><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">Requirements:<\/span><\/p>\n<ul>\n<li><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">VPS with Portainer installed using the <a href=\"https:\/\/unihost.com\/help\/what-is-portainer\/#installing-portainer-with-the-unihost-script\" target=\"_blank\" rel=\"noopener\">script from Unihost<\/a>;<\/span><\/li>\n<\/ul>\n<p><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">1. Log in to your Portainer instance and select the &#8220;PostgreSQL with Adminer&#8221; template:<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17570\" src=\"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png\" alt=\"Installing PostgreSQL database server via Portainer template - Image 1\" width=\"1069\" height=\"573\" \/ title=\"Installing PostgreSQL database server via Portainer template - Image 1\"><\/span><\/p>\n<p><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">2. Fill in or change the required fields:<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17574\" src=\"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-22-31.png\" alt=\"Installing PostgreSQL database server via Portainer template - Image 2\" width=\"994\" height=\"750\" \/ title=\"Installing PostgreSQL database server via Portainer template - Image 2\"><\/span><\/p>\n<p><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">Where:<\/span><\/p>\n<ol>\n<li><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">Name &#8211; stack name (anything you understand);<\/span><\/li>\n<li><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">PostgreSQL Password &#8211; password for the privileged user;<\/span><\/li>\n<li><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">PostgreSQL User &#8211; name of the privileged user;<\/span><\/li>\n<li><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">PostgreSQL Database &#8211; name of the database to be created;<\/span><\/li>\n<li><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">PostgreSQL version &#8211; PostgreSQL server version tag (you can find the actual tags on <a href=\"https:\/\/hub.docker.com\/_\/postgres\/tags\" target=\"_blank\" rel=\"noopener nofollow noopener noreferrer\">Dockerhub<\/a>).<\/span><\/li>\n<\/ol>\n<p><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">Click <strong>&#8220;Deploy the stack&#8221;<\/strong> and wait for the message about successful installation.<\/span><\/p>\n<p><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">3. If your PostgreSQL server use case requires external access, select your stack, follow the instructions in the screenshot, and uncomment the ports.<\/span><\/p>\n<p style=\"text-align: center;\"><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17578\" src=\"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-43-30.png\" alt=\"Installing PostgreSQL database server via Portainer template - Image 3\" width=\"1104\" height=\"745\" \/ title=\"Installing PostgreSQL database server via Portainer template - Image 3\"><\/span><\/p>\n<p><span style=\"font-family: Ubuntu, sans-serif; font-size: 12pt;\">4. To access Adminer for your PostgreSQL server, you need to expose it through <a href=\"https:\/\/unihost.com\/help\/nginx-proxy-manager\/#how-to-install-npm-via-portainer\" target=\"_blank\" rel=\"noopener\">Nginx Proxy Manager<\/a>. Simply create a new Proxy Host, point it to the container\u2019s internal Adminer port (usually 8080), assign your desired domain name, and enable SSL if required. After that, you\u2019ll be able to reach Adminer via your chosen domain in a browser.<\/span><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-17586\" src=\"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-56-56.png\" alt=\"Installing PostgreSQL database server via Portainer template - Image 4\" width=\"495\" height=\"544\" \/ title=\"Installing PostgreSQL database server via Portainer template - Image 4\"><\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is a powerful, open source object-relational database system that is easy to deploy in containers. In this article, we will look at how to quickly install a PostgreSQL server in Portainer using a ready-made template.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[158,6],"tags":[274,993,1003],"class_list":["post-17569","post","type-post","status-publish","format-standard","hentry","category-dedicated-servers","category-vps","tag-database","tag-portainer","tag-postgresql-2"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Installing PostgreSQL database server via Portainer template - Unihost.FAQ<\/title>\n<meta name=\"description\" content=\"PostgreSQL is a powerful, open source object-relational database system that is easy to deploy in containers.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Installing PostgreSQL database server via Portainer template - Unihost.FAQ\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL is a powerful, open source object-relational database system that is easy to deploy in containers.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/\" \/>\n<meta property=\"og:site_name\" content=\"Unihost.FAQ\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/unihost\/\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-05T10:07:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1069\" \/>\n\t<meta property=\"og:image:height\" content=\"573\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@unihost\" \/>\n<meta name=\"twitter:site\" content=\"@unihost\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/unihost.com\/help\/#\/schema\/person\/f29c72b4636c2860e1e9f87af6d41e57\"},\"headline\":\"Installing PostgreSQL database server via Portainer template\",\"datePublished\":\"2025-09-05T10:07:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/\"},\"wordCount\":214,\"publisher\":{\"@id\":\"https:\/\/unihost.com\/help\/#organization\"},\"image\":{\"@id\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png\",\"keywords\":[\"Database\",\"Portainer\",\"PostgreSQL\"],\"articleSection\":[\"02. Dedicated servers\",\"Virtual Private Server (VPS)\"],\"inLanguage\":\"en\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/\",\"url\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/\",\"name\":\"Installing PostgreSQL database server via Portainer template - Unihost.FAQ\",\"isPartOf\":{\"@id\":\"https:\/\/unihost.com\/help\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png\",\"datePublished\":\"2025-09-05T10:07:25+00:00\",\"description\":\"PostgreSQL is a powerful, open source object-relational database system that is easy to deploy in containers.\",\"breadcrumb\":{\"@id\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#primaryimage\",\"url\":\"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png\",\"contentUrl\":\"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Unihost\",\"item\":\"https:\/\/unihost.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Help\",\"item\":\"https:\/\/unihost.com\/help\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Installing PostgreSQL database server via Portainer template\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/unihost.com\/help\/#website\",\"url\":\"https:\/\/unihost.com\/help\/\",\"name\":\"Unihost.FAQ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/unihost.com\/help\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/unihost.com\/help\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/unihost.com\/help\/#organization\",\"name\":\"Unihost\",\"alternateName\":\"Unihost\",\"url\":\"https:\/\/unihost.com\/help\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/unihost.com\/help\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/unihost.com\/help\/minio.php?2026\/01\/minio.png\",\"contentUrl\":\"https:\/\/unihost.com\/help\/minio.php?2026\/01\/minio.png\",\"width\":300,\"height\":300,\"caption\":\"Unihost\"},\"image\":{\"@id\":\"https:\/\/unihost.com\/help\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/unihost\/\",\"https:\/\/x.com\/unihost\",\"https:\/\/www.instagram.com\/unihost\/?hl=en\",\"https:\/\/www.linkedin.com\/company\/unihost-com\",\"https:\/\/www.youtube.com\/channel\/UCITKsxMDnslQY8brN3advgw\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/unihost.com\/help\/#\/schema\/person\/f29c72b4636c2860e1e9f87af6d41e57\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/unihost.com\/help\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/222e250840cecf83ec31ff5e97aaa7d1e32d3226ed39a8bb534ac1d69039fc2a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/222e250840cecf83ec31ff5e97aaa7d1e32d3226ed39a8bb534ac1d69039fc2a?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"url\":\"https:\/\/unihost.com\/help\/author\/admin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Installing PostgreSQL database server via Portainer template - Unihost.FAQ","description":"PostgreSQL is a powerful, open source object-relational database system that is easy to deploy in containers.","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:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/","og_locale":"en_US","og_type":"article","og_title":"Installing PostgreSQL database server via Portainer template - Unihost.FAQ","og_description":"PostgreSQL is a powerful, open source object-relational database system that is easy to deploy in containers.","og_url":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/","og_site_name":"Unihost.FAQ","article_publisher":"https:\/\/www.facebook.com\/unihost\/","article_published_time":"2025-09-05T10:07:25+00:00","og_image":[{"width":1069,"height":573,"url":"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png","type":"image\/png"}],"author":"admin","twitter_card":"summary_large_image","twitter_creator":"@unihost","twitter_site":"@unihost","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#article","isPartOf":{"@id":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/"},"author":{"name":"admin","@id":"https:\/\/unihost.com\/help\/#\/schema\/person\/f29c72b4636c2860e1e9f87af6d41e57"},"headline":"Installing PostgreSQL database server via Portainer template","datePublished":"2025-09-05T10:07:25+00:00","mainEntityOfPage":{"@id":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/"},"wordCount":214,"publisher":{"@id":"https:\/\/unihost.com\/help\/#organization"},"image":{"@id":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#primaryimage"},"thumbnailUrl":"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png","keywords":["Database","Portainer","PostgreSQL"],"articleSection":["02. Dedicated servers","Virtual Private Server (VPS)"],"inLanguage":"en"},{"@type":"WebPage","@id":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/","url":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/","name":"Installing PostgreSQL database server via Portainer template - Unihost.FAQ","isPartOf":{"@id":"https:\/\/unihost.com\/help\/#website"},"primaryImageOfPage":{"@id":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#primaryimage"},"image":{"@id":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#primaryimage"},"thumbnailUrl":"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png","datePublished":"2025-09-05T10:07:25+00:00","description":"PostgreSQL is a powerful, open source object-relational database system that is easy to deploy in containers.","breadcrumb":{"@id":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#primaryimage","url":"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png","contentUrl":"https:\/\/unihost.com\/help\/minio.php?2025\/08\/Screenshot-at-14-15-25.png"},{"@type":"BreadcrumbList","@id":"https:\/\/unihost.com\/help\/installing-postgresql-database-server-via-portainer-template\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Unihost","item":"https:\/\/unihost.com\/"},{"@type":"ListItem","position":2,"name":"Help","item":"https:\/\/unihost.com\/help\/"},{"@type":"ListItem","position":3,"name":"Installing PostgreSQL database server via Portainer template"}]},{"@type":"WebSite","@id":"https:\/\/unihost.com\/help\/#website","url":"https:\/\/unihost.com\/help\/","name":"Unihost.FAQ","description":"","publisher":{"@id":"https:\/\/unihost.com\/help\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/unihost.com\/help\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/unihost.com\/help\/#organization","name":"Unihost","alternateName":"Unihost","url":"https:\/\/unihost.com\/help\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/unihost.com\/help\/#\/schema\/logo\/image\/","url":"https:\/\/unihost.com\/help\/minio.php?2026\/01\/minio.png","contentUrl":"https:\/\/unihost.com\/help\/minio.php?2026\/01\/minio.png","width":300,"height":300,"caption":"Unihost"},"image":{"@id":"https:\/\/unihost.com\/help\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/unihost\/","https:\/\/x.com\/unihost","https:\/\/www.instagram.com\/unihost\/?hl=en","https:\/\/www.linkedin.com\/company\/unihost-com","https:\/\/www.youtube.com\/channel\/UCITKsxMDnslQY8brN3advgw"]},{"@type":"Person","@id":"https:\/\/unihost.com\/help\/#\/schema\/person\/f29c72b4636c2860e1e9f87af6d41e57","name":"admin","image":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/unihost.com\/help\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/222e250840cecf83ec31ff5e97aaa7d1e32d3226ed39a8bb534ac1d69039fc2a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/222e250840cecf83ec31ff5e97aaa7d1e32d3226ed39a8bb534ac1d69039fc2a?s=96&d=mm&r=g","caption":"admin"},"url":"https:\/\/unihost.com\/help\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/posts\/17569","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/comments?post=17569"}],"version-history":[{"count":6,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/posts\/17569\/revisions"}],"predecessor-version":[{"id":17785,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/posts\/17569\/revisions\/17785"}],"wp:attachment":[{"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/media?parent=17569"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/categories?post=17569"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/unihost.com\/help\/wp-json\/wp\/v2\/tags?post=17569"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}