Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
in SQL by (6.1k points)
How do I change the password for the PostgreSQL user?

1 Answer

0 votes
by (12.7k points)

In order to login without a password:

sudo -u user_name psql db_name

To reset the password if you don't remember:

ALTER USER user_name WITH PASSWORD 'new_password';

Want to acquire SQL Expertise? Register now to this SQL Course and get certified.

Related questions

0 votes
1 answer
asked Oct 29, 2019 in Java by Anvi (10.2k points)
0 votes
1 answer
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94.1k users

Browse Categories

...