-
Check which port PostgreSQL db is listening on
netstart -ano | findstr 432
-
Login to db using eware account
psql -U eware -h 127.0.0.1 -p 6432
Note: For some installations, it could be port
5432
. Refer to step 1 output.
Note: Use 127.0.0.1 as the host instead of localhost because there are times where localhost might try to resolve to ipv6 address and the db might not be listening on that interface.
-
List all the usernames on the application db
select username from users;
-
Set null password for the user you want to reset password
update users set password=null where username='admin';
Note: In this example, we are resetting password for user
admin