Add / change default user password in PostgreSQL
In most Unix distributions, the default Postgres user neither requires nor uses a password for authentication. But if you like to set a password for the user, you can follow the below steps.
Login to CLI as the default user
sudo -u postgres psql
Change password
ALTER USER postgres PASSWORD 'myPassword';
Looking for a skilled developer? I'm currently available for freelance, contract, or full-time remote opportunities! Let's create something amazing together. Send me a quick message, and I'll respond within 24 hours!
Recent Posts
- SQL From Basics to Mastery — A Complete, Hands-On Guide
- WordPress Beginner Interview Questions
- Mastering Traits in PHP - The Complete Guide for Code Reuse and Modularity
- Understanding the Singleton Pattern and Using Traits to Achieve Singleton in WordPress Plugin Development
- REST API Methods Explained with Best Practices for Building Clean and Secure APIs
Your Questions / Comments
If you found this article interesting, found errors, or just want to discuss about it, please get in touch.