I'm following these instructions to get postgres working with rails on Windows 7:


  Run "Start Command Prompt with Ruby" then...
  
  
  createuser -U postgres -P NewUserName
  When it prompts for a password for new role, assign it a new password.
  No, the new role should not be a superuser.
  Yes, the new role should be allowed to create databases.
  No, the new role should not be allowed to create more new roles.
  Enter the postgresPWD you made when we installed PostgreSQL.
  


But this isn't happening. After I run #1, it asks me for a password, then skips straight to 5. This is completely screwing me over! Where did 2 through 4 go?

So then I tried doing it manually with createuser -s -U postgres -d -r (I have to do -U postgres because otherwise it asks for a password for a user that seems to be based on my Windows account, and no password I give it is successful...I tried fixing this by changing pg_hba.conf and then NOTHING worked)....so anyway I tried doing it manually and it was successful, but then I tried createdb newdb_name and it said createdb: could not connect to database template1: FATAL: password authentication failed for user "{my windows account}".

So I guess I could createdb as postgres, but then my rails commands to rake db:create would still fail. I need the active account to have full rights so that I can keep doing rails work.

I'm becoming really miserable about this. Please help...

Yes, listen_addresses can be set to a list of addresses on the local host to bind to for listening.

In your example:


  listen_addresses = '192.168.0.191, localhost'


If the local machine has IP 192.168.0.192, you should specify that IP, not the remote host 192.168.0.191 IP. PostgreSQL cannot bind to the IP address of a remote host.

You're not saying "who is allowed to connect", you're saying "which interfaces should PostgreSQL accept connections on". The "who's allowed to connect" bit is next, and is configured in pg_hba.conf.

So: Try '192.168.0.192, localhost'. Or just *, since you probably actually want to listen on all network interfaces.
