how to login in to psql with your admin details

Question

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?

You specified the password when you created the user `aarushsharma` so you are the only one who knows that password — , Mar 01 '21 at 16:20
i never created an account in postgresql with the name ```aaarushsharma``` but i do have it on my desktop thats why i assumed it had my desktop credentials and thats when it said the error — aarush_s, Mar 01 '21 at 16:25
then why do you try to connect with that user? To specify a different user use `psql -U ....` — , Mar 01 '21 at 16:26
@a_horse_with_no_name because that username has postgis installed i managed to install it through postgres app but i can't install postgis on the default postgres user so i want to try and login to the other user — aarush_s, Mar 01 '21 at 17:42

score 0 · Accepted Answer · answered Mar 01 '21 at 16:26

0

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

answered Mar 01 '21 at 16:26

Sargis Kazaryan

how do i access the pg_hba.conf file? – aarush_s Mar 01 '21 at 17:40
i have now managed to access the pg_hba.conf file but everything was already set to trust – aarush_s Mar 01 '21 at 19:01
what OS do you have? – Sargis Kazaryan Mar 01 '21 at 19:03
if everything is already set to trust, try connecting the database using postgres user, probably user aarushsharma doesn't exist. – Sargis Kazaryan Mar 01 '21 at 19:06
I can connect with Postgres but I just did this command when I got into the account ```\du``` and it showed aarushsharma there as a superuser – aarush_s Mar 01 '21 at 19:11
when I got into the Postgres account – aarush_s Mar 01 '21 at 19:12
hi my OS is MacOS – aarush_s Mar 02 '21 at 08:08
this is strange because trust parametr in pg_hba.cong allows anyone that can connect to the PostgreSQL database server to login as any PostgreSQL user they wish, without the need for a password https://www.postgresql.org/docs/9.1/auth-pg-hba-conf.html – Sargis Kazaryan Mar 03 '21 at 18:14

1 Answers1