I backed up my database as a zip file about a month ago (10.0) - and now when I try to restore it, I can't seem to log in? I have the correct username and password, but it denies me. Is there a way to reset these?
I have a lot of data in there (inventory) that I really don't want to lose.
Hey Harrison Hoffert,
From terminal (Shell) / Pgadmin Window You can reset it.
:- From Terminal,
1) psql your_database_name
2) Now run this query ,
update res_user set password='***' where id=1;
> Above query is for admin,if you want to change other user's password,simple go with Select SQL query and update it accordingly !
for ex.) select id,login from res_users;
Thanks.