Skip to content

Instantly share code, notes, and snippets.

View ravi-aratchige's full-sized avatar
🧑‍🍳
Cooking

Ravindu Aratchige ravi-aratchige

🧑‍🍳
Cooking
View GitHub Profile
@ravi-aratchige
ravi-aratchige / README.md
Last active March 25, 2024 20:34
Reset User Password in pgAdmin (PostgreSQL)

How to Reset Password of Database User in PostgreSQL (pgAdmin 4)

This guide is for Linux users, specifically Ubuntu 22.04 users. This guide cannot be guaranteed to work for developers working with other Linux distros or even other versions of Ubuntu.

Open the client authentication configuration file for PostgreSQL (pg_hba.conf):

gedit admin:///etc/postgresql/14/main/pg_hba.conf