{"id":5576,"date":"2024-03-22T10:29:00","date_gmt":"2024-03-22T09:29:00","guid":{"rendered":"https:\/\/harmonweb.com\/blog\/?p=5576"},"modified":"2024-03-23T20:51:00","modified_gmt":"2024-03-23T19:51:00","slug":"how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel","status":"publish","type":"post","link":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/","title":{"rendered":"How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel"},"content":{"rendered":"\n<p>In this tutorial, I will show you how to manage PostgreSQL Databases and users using PostgreSQL Databases in cPanel.<\/p>\n\n\n\n<p>From the cPanel, you can configure and manage both the PostgreSQL Databases and users. You can perform actions like changing a password, renaming a database user, and deleting them.\u00a0<\/p>\n\n\n\n<p>Let\u2019s get started.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">How To Manage PostgreSQL Databases and Users Using L Databases in cPanel<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">How To Manage PostgreSQL Databases<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>How to Rename Your PostgreSQL Databases<\/strong><\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li><a href=\"https:\/\/harmonweb.com\/blog\/how-to-login-to-your-cpanel-account\/\" title=\"\">Log into your cPanel<\/a>.<\/li>\n\n\n\n<li>Go to <strong>Databases <\/strong>section and select <strong>PostgreSQL Databases<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"832\" height=\"300\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-33.png\" alt=\"\" class=\"wp-image-5583\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-33.png 832w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-33-300x108.png 300w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-33-768x277.png 768w\" sizes=\"auto, (max-width: 832px) 100vw, 832px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>In the next page, scroll down to <strong>Current Databases<\/strong> and go to the database that you want to rename. In the <strong>Actions <\/strong>row, click on <strong>Rename<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1065\" height=\"317\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-32.png\" alt=\"\" class=\"wp-image-5582\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-32.png 1065w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-32-300x89.png 300w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-32-1024x305.png 1024w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-32-768x229.png 768w\" sizes=\"auto, (max-width: 1065px) 100vw, 1065px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>A pop-up screen will appear showing the old name and field for you to enter the new name. Then click on <strong>Proceed<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"642\" height=\"412\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-34.png\" alt=\"\" class=\"wp-image-5584\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-34.png 642w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-34-300x193.png 300w\" sizes=\"auto, (max-width: 642px) 100vw, 642px\" \/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>How to Delete Your PostgreSQL Databases<\/strong><\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Following the steps as given above, go to <strong>PostgreSQL Databases<\/strong>.<\/li>\n\n\n\n<li>Scroll down to <strong>Current Databases<\/strong> and go to the database that you want to delete. In the <strong>Actions <\/strong>row, click on <strong>Delete<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1046\" height=\"333\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-38.png\" alt=\"\" class=\"wp-image-5588\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-38.png 1046w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-38-300x96.png 300w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-38-1024x326.png 1024w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-38-768x244.png 768w\" sizes=\"auto, (max-width: 1046px) 100vw, 1046px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>You will be taken to a new screen where you will be asked <em>&nbsp;Are you sure you wish to permanently remove the \u201cdemotuto_exampledatabase\u201d database?<\/em> Click on <strong>Delete Database <\/strong>to confirm.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"726\" height=\"198\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-35.png\" alt=\"\" class=\"wp-image-5585\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-35.png 726w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-35-300x82.png 300w\" sizes=\"auto, (max-width: 726px) 100vw, 726px\" \/><\/figure>\n\n\n\n<p>You will get a notification that you have successfully deleted the database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">How To Manage PostgreSQL Database Users<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>How to Rename Your PostgreSQL Database User<\/strong><\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li>On the PostgreSQL Databases page, scroll down to <strong>Current Users<\/strong>.<\/li>\n\n\n\n<li>Select the user you want to rename and on the <strong>Actions <\/strong>row, click on <strong>Rename<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"808\" height=\"267\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-36.png\" alt=\"\" class=\"wp-image-5586\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-36.png 808w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-36-300x99.png 300w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-36-768x254.png 768w\" sizes=\"auto, (max-width: 808px) 100vw, 808px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>On the popup screen that appears, enter the new name you want to set for the user. Then click on <strong>Proceed.<\/strong><\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"635\" height=\"446\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-40.png\" alt=\"\" class=\"wp-image-5589\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-40.png 635w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-40-300x211.png 300w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"4\">\n<li>When you change the username, you will be asked to set a new password. You just go ahead and do that.<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>How to Change Password for a PostgreSQL Database User<\/strong><\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In the <strong>Current Users <\/strong>section, select the user, and in the <strong>Actions <\/strong>row, click on <strong>Change Password<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"937\" height=\"281\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-42.png\" alt=\"\" class=\"wp-image-5592\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-42.png 937w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-42-300x90.png 300w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-42-768x230.png 768w\" sizes=\"auto, (max-width: 937px) 100vw, 937px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>On the next page, you can enter the new password you want to use, or you can click on the <strong>Password Generator<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"832\" height=\"461\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-41.png\" alt=\"\" class=\"wp-image-5591\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-41.png 832w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-41-300x166.png 300w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-41-768x426.png 768w\" sizes=\"auto, (max-width: 832px) 100vw, 832px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"3\">\n<li>Click on <strong>Change Password <\/strong>to confirm the password change.<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>How to Change Password for a PostgreSQL Database User<\/strong><\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li>In the <strong>Current Users <\/strong>section, select the user, and in the <strong>Actions <\/strong>row, click on <strong>Delete<\/strong>.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"838\" height=\"283\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-37.png\" alt=\"\" class=\"wp-image-5587\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-37.png 838w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-37-300x101.png 300w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-37-768x259.png 768w\" sizes=\"auto, (max-width: 838px) 100vw, 838px\" \/><\/figure>\n\n\n\n<ol class=\"wp-block-list\" start=\"2\">\n<li>You will be taken to a new screen, where you will be asked <em>\u00a0Are you sure you wish to permanently remove the user \u201cdemotuto_user\u201d?<\/em> Click on <strong>Remove User <\/strong>to confirm.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"679\" height=\"224\" src=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-39.png\" alt=\"\" class=\"wp-image-5590\" srcset=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-39.png 679w, https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/image-39-300x99.png 300w\" sizes=\"auto, (max-width: 679px) 100vw, 679px\" \/><\/figure>\n\n\n\n<p>Following the steps I have given above, you can easily perform configure and manage PostgreSQL Databases and users using PostgreSQL Databases in cPanel. If you have any questions, you can leave them in the comment section. I would love to hear from you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, I will show you how to manage PostgreSQL Databases and users using PostgreSQL Databases in&hellip;<\/p>\n","protected":false},"author":1,"featured_media":5580,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[158],"tags":[],"class_list":["post-5576","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-troubleshooting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel | HarmonWeb<\/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:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel | HarmonWeb\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, I will show you how to manage PostgreSQL Databases and users using PostgreSQL Databases in&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"HarmonWeb\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-22T09:29:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-23T19:51:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/manage-postgresql-in-cpanel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"John Adegoke\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"John Adegoke\" \/>\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:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/\"},\"author\":{\"name\":\"John Adegoke\",\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/#\\\/schema\\\/person\\\/e9bc75c3e7e30a261690c47ec872a8fc\"},\"headline\":\"How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel\",\"datePublished\":\"2024-03-22T09:29:00+00:00\",\"dateModified\":\"2024-03-23T19:51:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/\"},\"wordCount\":465,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/manage-postgresql-in-cpanel.png\",\"articleSection\":[\"Troubleshooting\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/\",\"url\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/\",\"name\":\"How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel | HarmonWeb\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/manage-postgresql-in-cpanel.png\",\"datePublished\":\"2024-03-22T09:29:00+00:00\",\"dateModified\":\"2024-03-23T19:51:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/manage-postgresql-in-cpanel.png\",\"contentUrl\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/wp-content\\\/uploads\\\/2024\\\/03\\\/manage-postgresql-in-cpanel.png\",\"width\":1920,\"height\":1080,\"caption\":\"manage postsql database\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/\",\"name\":\"HarmonWeb\",\"description\":\"Web Hosting In Nigeria\",\"publisher\":{\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/#organization\",\"name\":\"HarmonWeb\",\"url\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/cropped-HARMON-WEB-LOGO-2.png\",\"contentUrl\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/06\\\/cropped-HARMON-WEB-LOGO-2.png\",\"width\":831,\"height\":172,\"caption\":\"HarmonWeb\"},\"image\":{\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/#\\\/schema\\\/person\\\/e9bc75c3e7e30a261690c47ec872a8fc\",\"name\":\"John Adegoke\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/wp-content\\\/litespeed\\\/avatar\\\/0843e926db683e41ace2aee54210b841.jpg?ver=1777444558\",\"url\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/wp-content\\\/litespeed\\\/avatar\\\/0843e926db683e41ace2aee54210b841.jpg?ver=1777444558\",\"contentUrl\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/wp-content\\\/litespeed\\\/avatar\\\/0843e926db683e41ace2aee54210b841.jpg?ver=1777444558\",\"caption\":\"John Adegoke\"},\"sameAs\":[\"https:\\\/\\\/harmonweb.com\\\/blog\"],\"url\":\"https:\\\/\\\/harmonweb.com\\\/blog\\\/author\\\/harmonweb\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel | HarmonWeb","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:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/","og_locale":"en_US","og_type":"article","og_title":"How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel | HarmonWeb","og_description":"In this tutorial, I will show you how to manage PostgreSQL Databases and users using PostgreSQL Databases in&hellip;","og_url":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/","og_site_name":"HarmonWeb","article_published_time":"2024-03-22T09:29:00+00:00","article_modified_time":"2024-03-23T19:51:00+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/manage-postgresql-in-cpanel.png","type":"image\/png"}],"author":"John Adegoke","twitter_card":"summary_large_image","twitter_misc":{"Written by":"John Adegoke","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/#article","isPartOf":{"@id":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/"},"author":{"name":"John Adegoke","@id":"https:\/\/harmonweb.com\/blog\/#\/schema\/person\/e9bc75c3e7e30a261690c47ec872a8fc"},"headline":"How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel","datePublished":"2024-03-22T09:29:00+00:00","dateModified":"2024-03-23T19:51:00+00:00","mainEntityOfPage":{"@id":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/"},"wordCount":465,"commentCount":1,"publisher":{"@id":"https:\/\/harmonweb.com\/blog\/#organization"},"image":{"@id":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/manage-postgresql-in-cpanel.png","articleSection":["Troubleshooting"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/","url":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/","name":"How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel | HarmonWeb","isPartOf":{"@id":"https:\/\/harmonweb.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/manage-postgresql-in-cpanel.png","datePublished":"2024-03-22T09:29:00+00:00","dateModified":"2024-03-23T19:51:00+00:00","breadcrumb":{"@id":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/#primaryimage","url":"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/manage-postgresql-in-cpanel.png","contentUrl":"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2024\/03\/manage-postgresql-in-cpanel.png","width":1920,"height":1080,"caption":"manage postsql database"},{"@type":"BreadcrumbList","@id":"https:\/\/harmonweb.com\/blog\/how-to-manage-postgresql-databases-and-users-using-postgresql-databases-in-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/harmonweb.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Manage PostgreSQL Databases and Users Using PostgreSQL Databases in cPanel"}]},{"@type":"WebSite","@id":"https:\/\/harmonweb.com\/blog\/#website","url":"https:\/\/harmonweb.com\/blog\/","name":"HarmonWeb","description":"Web Hosting In Nigeria","publisher":{"@id":"https:\/\/harmonweb.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/harmonweb.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/harmonweb.com\/blog\/#organization","name":"HarmonWeb","url":"https:\/\/harmonweb.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/harmonweb.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2020\/06\/cropped-HARMON-WEB-LOGO-2.png","contentUrl":"https:\/\/harmonweb.com\/blog\/wp-content\/uploads\/2020\/06\/cropped-HARMON-WEB-LOGO-2.png","width":831,"height":172,"caption":"HarmonWeb"},"image":{"@id":"https:\/\/harmonweb.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/harmonweb.com\/blog\/#\/schema\/person\/e9bc75c3e7e30a261690c47ec872a8fc","name":"John Adegoke","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/harmonweb.com\/blog\/wp-content\/litespeed\/avatar\/0843e926db683e41ace2aee54210b841.jpg?ver=1777444558","url":"https:\/\/harmonweb.com\/blog\/wp-content\/litespeed\/avatar\/0843e926db683e41ace2aee54210b841.jpg?ver=1777444558","contentUrl":"https:\/\/harmonweb.com\/blog\/wp-content\/litespeed\/avatar\/0843e926db683e41ace2aee54210b841.jpg?ver=1777444558","caption":"John Adegoke"},"sameAs":["https:\/\/harmonweb.com\/blog"],"url":"https:\/\/harmonweb.com\/blog\/author\/harmonweb\/"}]}},"_links":{"self":[{"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/posts\/5576","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/comments?post=5576"}],"version-history":[{"count":2,"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/posts\/5576\/revisions"}],"predecessor-version":[{"id":5593,"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/posts\/5576\/revisions\/5593"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/media\/5580"}],"wp:attachment":[{"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/media?parent=5576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/categories?post=5576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/harmonweb.com\/blog\/wp-json\/wp\/v2\/tags?post=5576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}