{"id":97074,"date":"2022-05-20T20:25:03","date_gmt":"2022-05-21T00:25:03","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/?p=97074"},"modified":"2024-06-03T14:22:40","modified_gmt":"2024-06-03T18:22:40","slug":"create-postgresql-database-cwp","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/","title":{"rendered":"Create PostgreSQL Databases in Control Web Panel (CWP)"},"content":{"rendered":"<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"538\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases-1024x538.jpg\" alt=\"PostgreSQL Databases in Control Web Panel\" class=\"wp-image-97073\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases-1024x538.jpg 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases-300x158.jpg 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases-768x403.jpg 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg 1200w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n\n<p>PostgreSQL is an open-source relational database management system (RDBMS) commonly used by developers strictly focused on free open-source software (FOSS). For example, the Mastodon social media and PeerTube video sharing Fediverse applications require you to create PostgreSQL databases. The Focalboard kanban app, created by the same developers responsible for the Mattermost chat software, is also compatible with PostgreSQL.<\/p>\n\n\n\n<p>Below we\u2019ll cover how to install PostgreSQL and manage PostgreSQL databases in Control Web Panel (CWP).<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"#install\">Install PostgreSQL in Control Web Panel<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"#database\">Create a PostgreSQL Database in CWP<\/a><\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><a href=\"#settings\">Manage PostgreSQL Server Access<\/a>\n<ul class=\"wp-block-list\">\n<li><a href=\"#user\">Create PostgreSQL Users in CWP<\/a><\/li>\n\n\n\n<li><a href=\"#remote\">Remote Database Management<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"install\">Install PostgreSQL in Control Web Panel<\/h2>\n\n\n\n<p>An administrator will need to install PostgreSQL before end users can manage databases.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/install-control-web-panel-cwp\/#login\">Log into CWP<\/a> as an administrator.<\/li>\n\n\n\n<li>On the left, search for and select <strong>PostgreSQL Manager<\/strong>.<\/li>\n\n\n\n<li>You\u2019ll see a mostly blank screen reading \u201cPostgreSQL not installed.\u201d Select <strong>Install now<\/strong> and select a version to install. Select <strong>Continue<\/strong> to confirm the installation process. The installation may take a minute.<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"246\" height=\"335\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-install-versions.png\" alt=\"Install PostgreSQL in CWP\" class=\"wp-image-97072\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-install-versions.png 246w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-install-versions-220x300.png 220w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure><\/li>\n<\/ol>\n\n\n\n<p>After the page refreshes, you\u2019ll see the PostgreSQL version installed and service status (should be \u201cRunning\u201d) on the right-hand side. Now you\u2019re ready to create PostgreSQL databases and users.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"179\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-1024x179.png\" alt=\"CWP PostgreSQL Manager\" class=\"wp-image-97067\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-1024x179.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-300x53.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-768x134.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager.png 1382w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"database\">Create a PostgreSQL Database in CWP<\/h3>\n\n\n\n<p>You\u2019ll see that a PostgreSQL database owned by the root user has been created.<\/p>\n\n\n\n<p class=\"alert alert-warning\">Regular users cannot create PostgreSQL databases.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Select <strong>Add new database<\/strong> in the upper-right corner.<\/li>\n\n\n\n<li>Assign the database to a CWP user. <a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/add-cwp-user\/\">Create a new user<\/a> first if needed.<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"303\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-database-new-1024x303.png\" alt=\"Create a PostgreSQL database in CWP\" class=\"wp-image-97071\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-database-new-1024x303.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-database-new-300x89.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-database-new-768x227.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-database-new.png 1196w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure><\/li>\n\n\n\n<li>Type a name for the database. The full database name will include the database user as a prefix (e.g. \u201cuser_dp305\u201d).<\/li>\n\n\n\n<li>Select <strong>Save<\/strong>. The main page will now show your new database with options to add users or delete the database.<\/li>\n\n\n\n<li>(Optional) If you want to allow regular users to manage PostgreSQL databases, select <strong>Configuration<\/strong> at the top. Then, check the box for \u201cPostgreSQL available in user panel.\u201d You can enable the panel for all accounts or specific ones. Once you\u2019ve made your decision, select <strong>Save configurations<\/strong>.<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"488\" height=\"317\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-enable-users.png\" alt=\"Enable PostgreSQL in User Panels\" class=\"wp-image-97070\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-enable-users.png 488w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-enable-users-300x195.png 300w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure><\/li>\n<\/ol>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"settings\">Manage PostgreSQL Server Access<\/h2>\n\n\n\n<p>Now that you know how to create PostgreSQL databases on your CWP server, there are some related tasks you should be familiar with.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"user\">Create PostgreSQL Users in CWP<\/h3>\n\n\n\n<p>CWP admin and regular users can create PostgreSQL users in CWP. Regular users can access this function by selecting <strong>Databases<\/strong> &gt; <strong>Postgres Manager<\/strong>.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>To the right of a database, select the first (user) icon from the \u201cActions\u201d column.<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"246\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-add-user-1024x246.png\" alt=\"Add users to a CWP PostgreSQL database\" class=\"wp-image-97068\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-add-user-1024x246.png 1024w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-add-user-300x72.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-add-user-768x184.png 768w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-add-user.png 1200w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure><\/li>\n\n\n\n<li>If the CWP user already has PostgreSQL users, you can select <strong>Add existing user<\/strong> to add them. Otherwise, type a username and a strong password to create one.<\/li>\n\n\n\n<li>Select <strong>Save<\/strong>. The main page will list the user in the \u201cUsers\u201d column with options to change the password or remove the user.<\/li>\n<\/ol>\n\n\n\n<p class=\"alert alert-info\">Admin and regular users can also update PostgreSQL user passwords from the \u201cUsers\u201d tab.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"remote\">Remote Database Management<\/h3>\n\n\n\n<p>If your team requires remote database access for desktop apps such as <a href=\"https:\/\/www.inmotionhosting.com\/support\/server\/databases\/create-an-er-diagram-in-dbeaver\/\">DBeaver<\/a>, admin users can change remote database connection settings from <strong>PostgreSQL Manager<\/strong> &gt; <strong>Settings<\/strong>.<\/p>\n\n\n\n<p>The default listening port is 5432.<\/p>\n\n\n\n<p>The default listening address is \u201clocalhost.\u201d\u00a0<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"775\" height=\"138\" src=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-port-listen.png\" alt=\"CWP PostgreSQL remote connection settings\" class=\"wp-image-97069\" srcset=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-port-listen.png 775w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-port-listen-300x53.png 300w, https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-manager-port-listen-768x137.png 768w\" sizes=\"auto, (min-width: 1360px) 876px, (min-width: 960px) calc(61.58vw + 51px), calc(100vw - 80px)\" \/><\/figure>\n\n\n\n<p>Don\u2019t forget to select <strong>Save settings<\/strong> after any changes.\u00a0<\/p>\n\n\n\n<p>Let us know if you have any questions about managing databases on your <a href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/\">CWP server<\/a>.<\/p>\n\n\n<div class=\"jumbotron\" style=\"text-align:center;\">\r\n<p style=\"font-size: 20px;\"><strong>Scalable VPS Infrastructure, Fully Managed<\/strong><\/p>\r\n<p>When shared hosting can't handle your traffic, VPS delivers dedicated resources that scale with demand. Our team manages the technical complexity while you manage your business.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>NVMe Storage &nbsp;&nbsp; <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>High-Availability &nbsp;&nbsp; <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>Ironclad Security &nbsp;&nbsp; <img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/design.inmotionhosting.com\/assets\/icons\/standard\/check-blue.svg\" alt=\"check mark\" width=\"24\" height=\"24\" \/>Premium Support<\/p>\r\n<p><a class=\"btn btn-primary btn-lg\" href=\"https:\/\/www.inmotionhosting.com\/vps-hosting?mktgp=t&irgwc=1&affiliates=5001860&utm_campaign=Jumbotron&utm_source=supportcenter&utm_medium=cta&utm_term=vps-cta2\">VPS Hosting<\/a><\/p>\r\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is an open-source relational database management system (RDBMS) commonly used by developers strictly focused on free open-source software (FOSS). For example, the Mastodon social media and PeerTube video sharing Fediverse applications require you to create PostgreSQL databases. The Focalboard kanban app, created by the same developers responsible for the Mattermost chat software, is also<a class=\"moretag\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/\"> Read More ><\/a><\/p>\n","protected":false},"author":57014,"featured_media":97073,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4591],"tags":[],"class_list":["post-97074","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cwp-database-management"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Create PostgreSQL Databases in Control Web Panel (CWP) | InMotion Hosting<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Create PostgreSQL Databases in Control Web Panel (CWP) | InMotion Hosting\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL is an open-source relational database management system (RDBMS) commonly used by developers strictly focused on free open-source software (FOSS). For example, the Mastodon social media and PeerTube video sharing Fediverse applications require you to create PostgreSQL databases. The Focalboard kanban app, created by the same developers responsible for the Mattermost chat software, is also Read More &gt;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/\" \/>\n<meta property=\"og:site_name\" content=\"InMotion Hosting Support Center\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/inmotionhosting\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-05-21T00:25:03+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-03T18:22:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"InMotion Hosting Contributor\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/InMotionHosting\" \/>\n<meta name=\"twitter:site\" content=\"@InMotionHosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"InMotion Hosting Contributor\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/\"},\"author\":{\"name\":\"InMotion Hosting Contributor\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\"},\"headline\":\"Create PostgreSQL Databases in Control Web Panel (CWP)\",\"datePublished\":\"2022-05-21T00:25:03+00:00\",\"dateModified\":\"2024-06-03T18:22:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/\"},\"wordCount\":549,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg\",\"articleSection\":[\"CWP Database Management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/\",\"name\":\"Create PostgreSQL Databases in Control Web Panel (CWP) | InMotion Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg\",\"datePublished\":\"2022-05-21T00:25:03+00:00\",\"dateModified\":\"2024-06-03T18:22:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#primaryimage\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg\",\"width\":1200,\"height\":630,\"caption\":\"PostgreSQL Databases in Control Web Panel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.inmotionhosting.com\/support\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Create PostgreSQL Databases in Control Web Panel (CWP)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#website\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"name\":\"InMotion Hosting Support Center\",\"description\":\"Web Hosting Support &amp; Tutorials\",\"publisher\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#organization\",\"name\":\"InMotion Hosting\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"contentUrl\":\"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg\",\"width\":696,\"height\":696,\"caption\":\"InMotion Hosting\"},\"image\":{\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/inmotionhosting\/\",\"https:\/\/x.com\/InMotionHosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644\",\"name\":\"InMotion Hosting Contributor\",\"description\":\"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!\",\"sameAs\":[\"https:\/\/www.linkedin.com\/company\/inmotion-hosting\/\",\"https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting\"],\"url\":\"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Create PostgreSQL Databases in Control Web Panel (CWP) | InMotion Hosting","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:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/","og_locale":"en_US","og_type":"article","og_title":"Create PostgreSQL Databases in Control Web Panel (CWP) | InMotion Hosting","og_description":"PostgreSQL is an open-source relational database management system (RDBMS) commonly used by developers strictly focused on free open-source software (FOSS). For example, the Mastodon social media and PeerTube video sharing Fediverse applications require you to create PostgreSQL databases. The Focalboard kanban app, created by the same developers responsible for the Mattermost chat software, is also Read More >","og_url":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/","og_site_name":"InMotion Hosting Support Center","article_publisher":"https:\/\/www.facebook.com\/inmotionhosting\/","article_published_time":"2022-05-21T00:25:03+00:00","article_modified_time":"2024-06-03T18:22:40+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg","type":"image\/jpeg"}],"author":"InMotion Hosting Contributor","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/InMotionHosting","twitter_site":"@InMotionHosting","twitter_misc":{"Written by":"InMotion Hosting Contributor","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#article","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/"},"author":{"name":"InMotion Hosting Contributor","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644"},"headline":"Create PostgreSQL Databases in Control Web Panel (CWP)","datePublished":"2022-05-21T00:25:03+00:00","dateModified":"2024-06-03T18:22:40+00:00","mainEntityOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/"},"wordCount":549,"commentCount":0,"publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg","articleSection":["CWP Database Management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/","url":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/","name":"Create PostgreSQL Databases in Control Web Panel (CWP) | InMotion Hosting","isPartOf":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#primaryimage"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#primaryimage"},"thumbnailUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg","datePublished":"2022-05-21T00:25:03+00:00","dateModified":"2024-06-03T18:22:40+00:00","breadcrumb":{"@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#primaryimage","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg","width":1200,"height":630,"caption":"PostgreSQL Databases in Control Web Panel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/create-postgresql-database-cwp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.inmotionhosting.com\/support\/"},{"@type":"ListItem","position":2,"name":"Create PostgreSQL Databases in Control Web Panel (CWP)"}]},{"@type":"WebSite","@id":"https:\/\/www.inmotionhosting.com\/support\/#website","url":"https:\/\/www.inmotionhosting.com\/support\/","name":"InMotion Hosting Support Center","description":"Web Hosting Support &amp; Tutorials","publisher":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.inmotionhosting.com\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.inmotionhosting.com\/support\/#organization","name":"InMotion Hosting","url":"https:\/\/www.inmotionhosting.com\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/","url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","contentUrl":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2023\/02\/inmotion-hosting-logo-yoast.jpg","width":696,"height":696,"caption":"InMotion Hosting"},"image":{"@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/inmotionhosting\/","https:\/\/x.com\/InMotionHosting"]},{"@type":"Person","@id":"https:\/\/www.inmotionhosting.com\/support\/#\/schema\/person\/f9a4fc454cd1df128ee8e898d30d4644","name":"InMotion Hosting Contributor","description":"InMotion Hosting contributors are highly knowledgeable individuals who create relevant content on new trends and troubleshooting techniques to help you achieve your online goals!","sameAs":["https:\/\/www.linkedin.com\/company\/inmotion-hosting\/","https:\/\/x.com\/https:\/\/twitter.com\/InMotionHosting"],"url":"https:\/\/www.inmotionhosting.com\/support\/author\/inmotion-hosting-contributor\/"}]}},"jetpack_featured_media_url":"https:\/\/www.inmotionhosting.com\/support\/wp-content\/uploads\/2022\/05\/cwp-postgresql-databases.jpg","jetpack_sharing_enabled":true,"primary_category":{"id":4591,"name":"CWP Database Management","slug":"cwp-database-management","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/control-web-panel\/cwp-database-management\/"},"_links":{"self":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/97074","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/users\/57014"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/comments?post=97074"}],"version-history":[{"count":11,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/97074\/revisions"}],"predecessor-version":[{"id":103097,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/posts\/97074\/revisions\/103097"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media\/97073"}],"wp:attachment":[{"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/media?parent=97074"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/categories?post=97074"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inmotionhosting.com\/support\/wp-json\/wp\/v2\/tags?post=97074"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}