{"id":3382,"date":"2015-02-28T02:34:45","date_gmt":"2015-02-28T08:04:45","guid":{"rendered":"http:\/\/news.filepuma.com\/?p=3382"},"modified":"2024-06-29T06:25:37","modified_gmt":"2024-06-29T13:25:37","slug":"how-to-reset-a-postgresql-password","status":"publish","type":"post","link":"https:\/\/www.filepuma.com\/reviews\/how-to-reset-a-postgresql-password\/","title":{"rendered":"How to Reset a PostgreSQL Password"},"content":{"rendered":"<p><a href=\"http:\/\/www.filepuma.com\/search\/PostgreSQL\/#gsc.tab=0&amp;gsc.ie=UTF8&amp;gsc.sort=&amp;gsc.q=PostgreSQL\"><strong>PostgreSQL<\/strong><\/a> is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.\u00a0Here is an instruction to tell you how to reset PostgreSQL password to keep its security.<\/p>\n<p>&nbsp;<\/p>\n<p>1. Click &#8220;Start&#8221; and type &#8220;cmd.exe&#8221; in the Search bar to open a new command terminal on the server running PostgreSQL.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3383\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2015\/02\/XpnfC68854f1764697b3a330498386.jpg\" alt=\"1\" width=\"491\" height=\"518\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3384\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2015\/02\/xkhER37354f1765681411398978871.jpg\" alt=\"2\" width=\"677\" height=\"442\" \/><\/p>\n<p>2. Type &#8220;psql -h localhost&#8221; without quotes into the command window so that you could access the PostgreSQL database from the root account of the computer running the server.<\/p>\n<p>3. Run the command &#8220;ALTER USER &lt;name&gt; WITH PASSWORD &#8216;password&#8217;;.&#8221; Replace name and password with the new one you want. Now you&#8217;ve successfully reset the PostgreSQL password.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.\u00a0Here is an instruction to tell you how to reset PostgreSQL password to keep its security. &nbsp; 1. Click &#8220;Start&#8221; and [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-3382","post","type-post","status-publish","format-standard","hentry","category-developer-tools"],"_links":{"self":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/3382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/comments?post=3382"}],"version-history":[{"count":1,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/3382\/revisions"}],"predecessor-version":[{"id":5104,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/3382\/revisions\/5104"}],"wp:attachment":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/media?parent=3382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/categories?post=3382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/tags?post=3382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}