"Stockho, Jonathan W " <jstockho@xxxxxxxxxxxxxxxx> 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