How to set a password for a user in Postgresql

UpdatedMay 13, 2024

•1 min read

How to set a password for a user in Postgresql

Open a terminal

Connect to Postgresql

sudo -u postgres psql

postgres is the name of the user.

Change the password

ALTER USER postgres WITH PASSWORD 'postgres';

Output

'postgres' is the password.

Test the new password

psql -U postgres -h localhost

Output

Done

Celebrate

The It Crowd Birthday GIFs | Tenor

Reach me out

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!

#postgresql #alexandrecalaca #terminal

More from this blog

Introduction to React Props

Components Introduction In order to truly understand props in React, we first need to be clear on what components are. A component is a reusable piece of the user interface that encapsulates structure, styling, and behavior. Instead of repeating the ...

Oct 4, 20254 min read

From Github Codespaces to Repository: Step-by-Step Setup

Introduction Context By default, Codespace is using the GITHUB_TOKEN env var (the “Codespaces token”), which can’t create repos. It’s necessary to authenticate gh with a token/account that has the right scopes, or create the repo on the web first. Ob...

Sep 28, 20252 min read

From Github Codespaces to Repository: Step-by-Step Setup

How to create a Git commit without a message?

Solution Here it is: git commit --allow-empty-message -m "" Explanation To create a Git commit without a message, or with an empty message, you can use the --allow-empty-message flag with the git commit command. git commit --allow-empty-message -m "...

Sep 25, 20251 min read

How to create a Git commit without a message?

Step-by-Step Guide to Forcefully Remove and Recreate Docker Containers

Steps Cleanup phase This phase’s goal is to removes existing containers, volumes, networks and images Stop and remove volumes docker compose down --volumes --remove-orphans The previous command stops and removes containers, networks, and default volu...

Sep 12, 20252 min read

Step-by-Step Guide to Forcefully Remove and Recreate Docker Containers

A Complete Guide to Uninstalling Docker completely on Pop!_OS and Ubuntu-based Systems

Steps Stop the service It’s not mandatory, but before uninstalling, it's a good practice to stop any running Docker services. sudo systemctl stop docker Remove docker packages It’s used to completely and forcefully remove a list of specified packag...