<hr />
<h2 id="heading-open-a-terminal">Open a terminal</h2>
<hr />
<h2 id="heading-connect-to-postgresql">Connect to Postgresql</h2>
<pre><code class="lang-ruby">sudo -u postgres psql
</code></pre>
<p><code>postgres</code> is the name of the user.</p>
<p><img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1709692587506/09647aa3-be24-40c7-9794-fb375e33b92c.png?auto=compress,format&amp;format=webp" alt /></p>
<hr />
<h2 id="heading-change-the-password">Change the password</h2>
<pre><code class="lang-ruby">ALTER USER postgres WITH PASSWORD <span class="hljs-string">'postgres'</span>;
</code></pre>
<p>Output</p>
<p><img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1709695057074/b5274427-c14b-4635-8e83-668b46cabe8f.png" alt class="image--center mx-auto" /></p>
<p><code>'postgres'</code> is the password.</p>
<hr />
<h2 id="heading-test-the-new-password">Test the new password</h2>
<pre><code class="lang-ruby">psql -U postgres -h localhost
</code></pre>
<p>Output</p>
<p><img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1709695192423/7359ef4e-87ec-445b-9111-f2f93dcf4c7b.png" alt class="image--center mx-auto" /></p>
<hr />
<h2 id="heading-done"><strong>Done</strong></h2>
<hr />
<h3 id="heading-celebrate"><strong>Celebrate</strong></h3>
<p><img src="https://media.tenor.com/kDyYq4PQuIgAAAAC/clapping-it-crowd.gif" alt="The It Crowd Birthday GIFs | Tenor" /></p>
<hr />
<h3 id="heading-reach-me-out">Reach me out</h3>
<ul>
<li><p><a target="_blank" href="https://github.com/alexcalaca"><strong>Github</strong></a></p>
</li>
<li><p><a target="_blank" href="https://linkedin.com/in/alexandrecalacaofficial"><strong>Linke</strong></a><a target="_blank" href="https://github.com/alexcalaca"><strong>dIn</strong></a></p>
</li>
<li><p><a target="_blank" href="https://hashnode.com/onboard?next=/@alexandrecalaca"><strong>H</strong></a><a target="_blank" href="https://linkedin.com/in/alexandrecalacaofficial"><strong>ashnode</strong></a></p>
</li>
<li><p><a target="_blank" href="https://github.com/alexcalaca"><strong>You</strong></a><a target="_blank" href="https://hashnode.com/onboard?next=/@alexandrecalaca"><strong>t</strong></a><a target="_blank" href="https://www.youtube.com/@alexandrecalacaofficial"><strong>u</strong></a><a target="_blank" href="https://linkedin.com/in/alexandrecalacaofficial"><strong>be</strong></a></p>
</li>
</ul>
<hr />
<h3 id="heading-final-thoughts">Final thoughts</h3>
<p>Thank you for reading this article.</p>
<p>If you have any questions, thoughts, suggestions, or corrections, please share them with us.</p>
<p>We appreciate your feedback and look forward to hearing from you.</p>
<p>Feel free to suggest topics for future blog articles. Until next time!</p>


---

## Open a terminal

---

## Connect to Postgresql

```ruby
sudo -u postgres psql
```

`postgres` is the name of the user.

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1709692587506/09647aa3-be24-40c7-9794-fb375e33b92c.png?auto=compress,format&format=webp align="left")

---

## Change the password

```ruby
ALTER USER postgres WITH PASSWORD 'postgres';
```

Output

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1709695057074/b5274427-c14b-4635-8e83-668b46cabe8f.png align="center")

`'postgres'` is the password.

---

## Test the new password

```ruby
psql -U postgres -h localhost
```

Output

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1709695192423/7359ef4e-87ec-445b-9111-f2f93dcf4c7b.png align="center")

---

## **Done**

---

### **Celebrate**

![The It Crowd Birthday GIFs | Tenor](https://media.tenor.com/kDyYq4PQuIgAAAAC/clapping-it-crowd.gif align="left")

---

### Reach me out

* [**Github**](https://github.com/alexcalaca)
    
* [**Linke**](https://linkedin.com/in/alexandrecalacaofficial)[**dIn**](https://github.com/alexcalaca)
    
* [**H**](https://hashnode.com/onboard?next=/@alexandrecalaca)[**ashnode**](https://linkedin.com/in/alexandrecalacaofficial)
    
* [**You**](https://github.com/alexcalaca)[**t**](https://hashnode.com/onboard?next=/@alexandrecalaca)[**u**](https://www.youtube.com/@alexandrecalacaofficial)[**be**](https://linkedin.com/in/alexandrecalacaofficial)
    

---

### Final thoughts

Thank you for reading this article.

If you have any questions, thoughts, suggestions, or corrections, please share them with us.

We appreciate your feedback and look forward to hearing from you.

Feel free to suggest topics for future blog articles. Until next time!

How to set a password for a user in Postgresql

Open a terminal

Connect to Postgresql

Change the password

Test the new password

Done

Celebrate

Reach me out

Final thoughts

I'm a passionate software engineer with a deep love for turning complex problems into elegant solutions through code.


Alexandre Calaça's Blog