I installed postgresql on my Mac through homebrew. It said it didn't create a postgres account, but is using an account with my username instead. However, running the command psql fails because when I type in my password, it says it's wrong. I've retried it to make sure I'm not typing it wrong. So what's the password it gave me?
-
1See also this question: stackoverflow.com/questions/7695962/…DNA– DNA2014-05-20 20:49:24 +00:00Commented May 20, 2014 at 20:49
-
5It usually creates an account with your username but no password assigned.tadman– tadman2014-05-20 21:00:27 +00:00Commented May 20, 2014 at 21:00
-
What is the exact error message?jjanes– jjanes2014-05-20 21:57:29 +00:00Commented May 20, 2014 at 21:57
-
1@tadman I noticed my install did create an account with my user name however when it prompts for passwords and I just hit enter (assuming this would satisfy no password), it just repeats the prompt for a password. Are you aware of way to actually authenticate as the default user or is this not possible?Kevin Dark– Kevin Dark2020-05-17 04:33:32 +00:00Commented May 17, 2020 at 4:33
Add a comment
|
8 Answers
As per tadman's comment, Homebrew postgres currently creates an account with the same name as the installing user, but no password. E.g. after my initial install (username david):
$ psql postgres
psql (12.2)
Type "help" for help.
postgres=# \du
List of roles
Role name | Attributes | Member of
-----------+------------------------------------------------------------+-----------
david | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
4 Comments
Cheetaiean
Homebrew is constantly prompting for a password for any user (whether psql -U postgres or just psql postgres), fresh after installation. There does not seem to be a user without a password.
ricks
@Cheetaiean did you figure out a solution?
Sergei
@Cheetaiean is there any solution?
Pratik Parmar
Try using
psql -U postgres followed by postgres as the password.When installing on a mac via homebrew, the default user that is created is named the same as your mac's user account. There is no password, and running psql should get you in.
If not, you likely ALSO have the postgres application installed. If you uninstall the application it will no longer have issues with clashing users.
1 Comment
jester66
If you're getting the PG error:
database "<your_username>" does not exist - homebrew will install the DB user as <your_username> but keep the default DB name as 'postgres' - so logging in with psql -d postgres will work.There are two different "accounts" here:
The OS X user that owns the PostgreSQL files and processes. When you installed PostgreSQL, you used your own user account for that.
The PostgreSQL user that can log in to the PostgreSQL database. By default, that user is internal to your PostgreSQL instance and has nothing to do with any OS X user.
For psql, you need #2. Immediately after installation, there should be a user named "postgres" with no password that has full administrative privileges - try logging in with those credentials (and change the password to something secure ASAP).
2 Comments
hobs
psql -U postgres gives "fe_sendauth: no password supplied"Cheetaiean
After Homebrew installation it asks for the password for any user...
With PostgreSQL 16 with Homebrew on MacOS Ventura 13.5.1:
user: my logged user password: postgress
How to find out:
On terminal:
psql postgres
and then:
postgres=# \du
Your username should be listed. Let's validate it. Type "\q" to
postgres=# \q
And then:
psql -U usernameListedAbove postgres
2 Comments
Bersan
So...
user is usernameListedAbove, and password is postgres?
João Vieira
@Bersan correct
I met this issue again and just used psql postgres to solve this issue.
It displays like below:
➜ ~ psql postgres
psql (14.7 (Homebrew))
Type "help" for help.
postgres=#
but I can not use psql -U postgres, it display like below:
➜ ~ psql -U postgres
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: role "postgres" does not exist
Comments
I my self run in to the same problem, turned out I had Postgres already installed without Homebrew. After I deleted that install, the homebrew install worked and it didn't prompt me for a password anymore.
Comments
I ran into the same probelm and solved like this.
This could be due to the reason that you installed postgres previously from other sources and then tried uninstalling. It did leave postgres user account on your system. Go to user & accounts from system preferences. From there, remove the postgres user account. Now restart and then try installing with brew. This should work.
Comments
I've installed Postgres 14 using Homebrew. I tried using postgres as the password while logging in for the first time and it worked.
hackyroot@Root-MacBook-Air ~ % psql -U postgres
Password for user postgres:
psql (14.8 (Homebrew), server 15.3)
WARNING: psql major version 14, server major version 15.
Some psql features might not work.
Type "help" for help.
postgres=#