how to login in to psql with your admin details

Question

354 views Asked by aarush_s At 11 September 2024 at 05:10

hi am following the following tutorial

and when i add psql into my path and then type it into the terminal it asks for my administrator datails of which i give then it shows this

psql: error: FATAL:  password authentication failed for user "aarushsharma"

how do i find out the password for aarushsharma?

There are 1 answers

**Sargis Kazaryan** · Accepted Answer · 2021-03-01 16:26:33

try to change METHOD in pg_hba.conf file from md5 to trust, restart postgresql server and change your user password

ALTER USER aarushsharma WITH PASSWORD 'your_password';

and set METHOD to md5 again