Mac sudo password incorrect when create database in postgreSQL

Question

I'm trying to set up a Postgresql database for the first time.

After installing postgresql91, i opened up terminal and did the following:

sudo su - postgres
createdb dbname
Password: 
Sorry try again.

I typed in my Mac admin password, why do i get this problem?

score 0 · Accepted Answer · answered Oct 30 '11 at 09:00

0

For sudo you type in your password, not root's.

answered Oct 30 '11 at 09:00

Michael Krelin - hacker

138,757
24
193
173

I typed in my password. Is there another password for postgresql? – Adnan Oct 30 '11 at 09:02
No, it's not about postgres password, the message comes from `sudo`, so it's not yet gone as far as `su` and `postgres`. What it says is that you've entered wrong password for the user that started `sudo`. – Michael Krelin - hacker Oct 30 '11 at 09:07
ok. Could it be because i used sudo su - postgres to start up postgresql? – Adnan Oct 30 '11 at 09:08
I'm actually not sure what exactly is it you're tying. I mean — `sudo su - postgres`, but where does the `createdb` line comes from? There's no prompt? – Michael Krelin - hacker Oct 30 '11 at 09:09
Can you just try `sudo -u postgres createdb`? – Michael Krelin - hacker Oct 30 '11 at 09:10
after i do sudo su - postgres, it changes the directory to postgres. Then i typed in createdb dbname and so on. – Adnan Oct 30 '11 at 09:11
`createdb: could not connect to database template1: could not connect to server: Permission denied Is the server running locally and accepting connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?` – Adnan Oct 30 '11 at 09:11
`sudo su - postgres` doesn't really start postgres, it starts postgres user's login shell. – Michael Krelin - hacker Oct 30 '11 at 09:12
let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/4596/discussion-between-adnan-and-michael-krelin-hacker) – Adnan Oct 30 '11 at 09:12
Yes, you have no postgres running. – Michael Krelin - hacker Oct 30 '11 at 09:12

Mac sudo password incorrect when create database in postgreSQL

1 Answers1