Re: Can't use passwords for users

"Stockho, Jonathan W " <jstockho@alionscience.com> writes:
> createuser: could not connect to database postgres: could not connect to
> server: No such file or directory
>             Is the server running locally and accepting connections on
> Unix domain socket "/tmp/.s.PGSQL.0"?

".0"?  That suggests that the program is trying to connect to port
number zero.  That's got nothing to do with passwords or any of the
other stuff you're going on about; it's trying to connect to the wrong
place.  You need to find out why.  Could you have "PGPORT=0" in your
environment for some reason?

BTW, you didn't really type "createuser test -pwprompt" did you?  Every
version of createuser as far back as 7.3 rejects that as invalid syntax.
If you've got a version that actually took it just like that, then
you've got a stone-age Postgres and your first move should be to
update to something that was released in this century.

            regards, tom lane