PostgreSQL under Mac OSX Lion. Wrong userpass?
- by Matt
I'm completely helpless, maybe you guys can help me out.
I installed PostgreSQL under my new MacOSX Lion.
When I try to connect to my localhost with pgAdminIII.app it says:
Error connecting to the database: FATAL password authentication failed for user postgres
I just have no idea what to do? Non of my passwords work. Neither my adminpass nor "postgres" nor anyhting else.
I tried to install it again via the console where I found this helpful link: http://www.peerassembly.com/2011/08/...resql-on-lion/ However the problem is, that when I try to run createuser -a -d _postgres the same password problem appears again. I just can't seem to find a solution to this. Always wrong password.
Btw. I have a new User called "PostgreSQL" on my machine after I installed postgres.
Any ideas? I'm so stuck and I really need to make this work.