Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Default password for my user in postgresql

Tags:

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?

like image 289
Hugo Avatar asked May 20 '14 20:05

Hugo


1 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 | {}  
like image 93
David Moles Avatar answered Sep 30 '22 11:09

David Moles