How to set/reset password for PostgreSQL on Mac?

Question

I'm trying to set up PostgreSQL on Mac, and having some difficulty figuring out my password. I used homebrew to install with brew install postgresql, which appears to have executed correctly. When I try to start postgreSQL with psql postgres I am prompted to enter the password for my user account. I never actually set up a password, and my general user account password fails the password authentication. Same with sudo psql postgres.

I checked to see if I could change the pg_hba.conf file, but the file either doesn't exist or is not located at /var/lib/postgres/data/pg_hba.conf. Any thoughts on how to reset my password?

Does this answer your question? How to change PostgreSQL user password? — Crepi
– Crepi, Commented Oct 30, 2019 at 19:37
You may be connecting to your macs pre-installed version of postgresql, which you'll need to sudo/su to in order to connect to. — Joe Love
– Joe Love, Commented Oct 30, 2019 at 21:44

Winnerineast Lee · Accepted Answer · 2020-10-29 14:37:13Z

2

In Homebrew 2.5.7 the installation of postgresql is at /usr/local/Cellar/postgresql and the configuration file is at /usr/local/var/postgres/pg_hba.conf.

answered Oct 29, 2020 at 14:37

Winnerineast Lee

716 bronze badges

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

Comments

Martin M · Accepted Answer · 2023-08-17 15:27:28Z

1

In Homebrew 4.1.5 the config file is in

/opt/homebrew/var/postgresql@<version>

answered Aug 17, 2023 at 15:27

Martin M

8,6883 gold badges40 silver badges57 bronze badges

Collectives™ on Stack Overflow

How to set/reset password for PostgreSQL on Mac?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related