Re: [GENERAL] Can't use passwords for users

2007-01-19 Thread Tom Lane
"Stockho, Jonathan W " <[EMAIL PROTECTED]> 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 th

Re: [GENERAL] Can't use passwords for users

2007-01-19 Thread Richard Huxton
Stockho, Jonathan W wrote: I'm new to postgres, so bare with me. I installed version 8.2 from rpms on Suse 10. I then changed to the postgres user and ran initdb. After that I create a database called movies using the command "createdb movies" Then I used the pg_ctl command to start the postm

Re: [GENERAL] Can't use passwords for users

2007-01-18 Thread Neal Clark
Have you tried the CREATE USER command from psql/a client application? I.e. to create a user that is not a super user and can't create databases or roles: CREATE USER [name] WITH NOCREATEDB NOCREATEUSER PASSWORD '[password]'; as for your 'createuser' problem... i've got nothin On Ja