how to login in to psql with your admin details

Question

349 views Asked by aarush_s At 01 March 2021 at 16:16

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

Sargis Kazaryan On 01 March 2021 at 16:26 BEST ANSWER

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