EDIT: Apologies or posting this here...i know it's not PHP related. I was just lazily hoping for a quick answer. the postgresql docs kinda suck.
i just installed postgresql and i'm confused by the docs. at this point, i'm having to do all my database work using the postgresql command line client. this page supposedly describes how to create a superuser:
http://www.postgresql.org/docs/7.4/interactive/user-attributes.html
however, the text there is really confusing:
superuser
A database superuser bypasses all permission checks. Also, only a superuser can create new users. To create a database superuser, use CREATE USER name CREATEUSER.
does that mean i type this:
CREATE USER my_superuser_name CREATEUSER
what about setting a password for that user?
And what about the postgres user that is apparently created at install time which apparently has no password? or if it does have a password i don't know it. how do i change that user's password?
