I have postgres running in 2 locations
One is local for developing and testing purposes
The other is used as a web server.
I get the above error on the web server even though I have a postgres user set up. I will check the environmental variables but I am pretty sure they are set. Since I can use createuser what do I need to do to specify a password to connect with (using a shell not a script)?

Hope my question makes sense.
D.