Hi All,
Apologies if this is obvious as I am new to postgres. I recently installed postgres on my Mac. I'm trying to log into psql in the terminal with command 'psql -u postgres'. It asks that I authenticate my password. I've tried all kinds of passwords associated with my computer and none of them work.
I tried running ALTER ROLE postgres WITH PASSWORD 'password' in the psql SQL shell, and the command worked, but I'm still unable to log into psql using the method I described above. I also tried setting the master password in pgAdmin, but that didn't work either.
I've also tried logging in running just the command 'psql' where it asks to authenticate using my computer user credentials, and that doesn't seem to work either.
Does anyone have any suggestions for me? I'm running out of stackoverflow rabbit holes to go down.
submitted by
/u/i_am_baldilocks [link] [comments] 
