Re: Can't use passwords for users

"Stockho, Jonathan W " <jstockho(at)alionscience(dot)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