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 WordPress/WooCommerce 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
- 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
- My 28-Day Plan to Master Modern WordPress Development Using AI Tools
- Scaling WordPress - How Custom Database Tables Solve the Post Meta Bottleneck
- WordPress Transients Explained - A Developer's Guide to Site Performance
Your Questions / Comments
If you found this article interesting, found errors, or just want to discuss about it, please get in touch.