{"id":3350,"date":"2015-02-11T03:39:59","date_gmt":"2015-02-11T09:09:59","guid":{"rendered":"http:\/\/news.filepuma.com\/?p=3350"},"modified":"2024-06-29T06:26:28","modified_gmt":"2024-06-29T13:26:28","slug":"how-to-change-a-postgres-user-password","status":"publish","type":"post","link":"https:\/\/www.filepuma.com\/reviews\/how-to-change-a-postgres-user-password\/","title":{"rendered":"How to Change a Postgres User Password"},"content":{"rendered":"<p><strong><a href=\"http:\/\/www.filepuma.com\/search\/PostgreSQL\/#gsc.tab=0&amp;gsc.ie=UTF8&amp;gsc.sort=&amp;gsc.q=PostgreSQL\">PostgreSQL<\/a><\/strong> 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. Changing a PostgreSQL user password is accomplished using the &#8220;postgres&#8221; command prompt. Here is the instruction to tell you how to change a Postgres User Password.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3353\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2015\/02\/VedHE36954db1c56210ed040805307.jpg\" alt=\"3\" width=\"601\" height=\"220\" \/><\/p>\n<p>1. Click &#8220;Start&#8221; and enter &#8220;cmd&#8221; in the search bar, click &#8220;Enter&#8221; to open the command prompt window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3351\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2015\/02\/tcabm16554db1bd567427000931149.jpg\" alt=\"1\" width=\"491\" height=\"518\" \/><\/p>\n<p>2. Enter the command &#8220;psql -h &lt;server address&gt; -U &lt;username&gt;&#8221;. Replace &#8220;&lt;server address&gt;&#8221; with the network or IP address of the PostgreSQL server and &#8220;&lt;username&gt;&#8221; with the name of your Super User account.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-3352\" src=\"https:\/\/www.filepuma.com\/reviews\/wp-content\/uploads\/2015\/02\/VURfL354db1bdb192bd597664681.jpg\" alt=\"2\" width=\"677\" height=\"442\" \/><\/p>\n<p>3. Change the password of the PostgreSQL user. Type &#8220;ALTER USER &lt;username&gt; WITH PASSWORD &#8216;&lt;password&gt;&#8217; &#8220;. Now you&#8217;ve successfully change the 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. Changing a PostgreSQL user password is accomplished using the &#8220;postgres&#8221; command prompt. Here is the instruction to tell you how [&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-3350","post","type-post","status-publish","format-standard","hentry","category-developer-tools"],"_links":{"self":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/3350","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=3350"}],"version-history":[{"count":1,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/3350\/revisions"}],"predecessor-version":[{"id":5110,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/posts\/3350\/revisions\/5110"}],"wp:attachment":[{"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/media?parent=3350"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/categories?post=3350"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.filepuma.com\/reviews\/wp-json\/wp\/v2\/tags?post=3350"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}