Why postgresql on mac asks me for password after fresh install?

So your username probably does not exist, as the default username that ships with the db is postgres.

Further, I was prevented from the submission of an empty password, which is blank by default for the postgres user.

You might try

cd ~/
sudo -u postgres psql -c "ALTER USER postgres PASSWORD 'postgres';"
Password: YOUR_LOGIN_PWD_HERE (required for sudo)

and then to use

psql -U postgres
password: postgres

I'm not 100% sure of which SO answer I got this from, perhaps here. Hope this helps.

The above did not work for me. The below steps worked for me:

Step 1: Uninstall Postgres using the following steps:

sudo /Library/PostgreSQL/10/uninstall-postgresql.app/Contents/MacOS/uninstall-postgresql

PS: my postgres version is 10

Step 2: Remove Postgresql user

System Preference > userse & Groups > Unlock > remove postgresql user by clicking "-"

Step 3: Remove existing databases

rm -rf /usr/local/var/postgres/*

Step 4: Install and Start Postgres using brew

brew update
brew install postgresql
brew services start postgresql

Step 5: Create database

initdb /usr/local/var/postgres -E utf8

You can start accessing postgres

psql -h localhost -d postgres

Related