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';

Recent Posts

1. Disabling Payment Methods in WooCommerce Based on Conditions
2. How to Update Product Quantity in WooCommerce Using Custom Code
3. Dynamically Generating a Table of Contents in WordPress
4. Direct Checkout in WooCommerce - Add Product to Cart from Checkout Page & Skip Shop, Product, and Cart Pages
5. Understanding the Impact of git reset --hard Command

This article was published on February 11, 2020

Your Questions / Comments

If you found this article interesting, found errors, or just want to discuss about it, please get in touch.