With the help of \\"Gettting Started with Postgres on Redhat7.0\\",now,i can build database manually,and start the postgresql sevices when pc start,but how to add passwd for all users?how to control them without the utility of phpPgAdmin!
When logged in as user postgres you can use the command CREATE USER <username> -p '<password>'
This will allow you to create a user with a password. Note that <username> and <password> are to be replaced with whatever you prefer....but be sure the password is contained in single quotes.
Hope this helps, Kevin
bash-2.04$ createuser dang -p 'dang' Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y psql: connectDBStart() -- connect() failed: No such file or directory Is the postmaster running at 'localhost' and accepting connections on Unix socket 'dang'? createuser: creation of user "dang" failed
