specifying a username for a DB
specifying a username for a DB
(OP)
Hi,
I'm very new to postgreSQL and i need to know how to specify the username and passwd for a database that i've already created. any help is greatly appreciated!!
Mike
I'm very new to postgreSQL and i need to know how to specify the username and passwd for a database that i've already created. any help is greatly appreciated!!
Mike
RE: specifying a username for a DB
Maybe this will help. Its from the postgres static doc version 7.3.1.
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=sql-createuser.html
LelandJ
Leland F. Jackson, CPA
Software - Master (TM)
https://www.smvfp.com
Nothing Runs Like the Fox
RE: specifying a username for a DB
log in as root
go to the command promt(or console as you call it)
type service postgresql start
there should be a confirmation saying that service started
type su postgres
then type createuser somename
there will be a question saying
"should user be allowed to create/drop databases?"
type y
then create a database by typing
createdb dbname
then type
psql template1
then type grant all privileges on dbname to somename
that should be all