PostgreSQL on Mac doesn't recognize users password

Question

I have tried numerous suggestions from other posts and SO questions but none seem to do the trick. I just installed PostgreSQL with brew install, then ran the initdb command. The output said the user would be used for the DB, however, the user is always displayed as the mac user. What might I be missing?

output from console:

createdb: could not connect to database template1: FATAL: password authentication failed for user "macuser" 
Users-MBP:~ macuser$

Jing Yu · Accepted Answer · 2019-11-09 01:24:34Z

1

Just delete installed postgresql by doing below.

Remove previous versions of PostgreSQL brew uninstall --force postgresql Delete all Files of Postgres rm -rf /usr/local/var/postgres

Download macOS packages from Postgresql and install it.

https://www.postgresql.org/download/macosx/

Default user will be postgres and password field will be required when install

answered Nov 9, 2019 at 1:24

Jing Yu

1,63113 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PostgreSQL on Mac doesn't recognize users password

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related