ALTER USER postgres PASSWORD null; now has locked me out of psql
1
vote
1
answer
5997
views
I have installed postgresql version 9.3.14 on High Sierra via HomeBrew. Upon trying to access the server via psql, I was being prompted for a password for the user
postgres
. Using postgres
as the password got me into the database, but I was confused, as I have never been prompted for a password for the default user before. I looked around online on how to circumvent this, and I tried the solution suggested by lalligood on https://dba.stackexchange.com/questions/83164/remove-password-requirement-for-user-postgres?newreg=aa34aebf18274762924df4fb035dedff which was to run alter user postgres password null;
and now I cannot access psql. Trying postgres
, null
or omitting a password does not get me in, and I do not know what to do.
Asked by K Pekosh
(111 rep)
Jan 22, 2018, 06:16 PM
Last activity: Jan 22, 2018, 07:07 PM
Last activity: Jan 22, 2018, 07:07 PM