Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
specifying a username for a DB
- Thread starter blues77
- Start date
Hi blues77,
Maybe this will help. Its from the postgres static doc version 7.3.1.
LelandJ Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox
Maybe this will help. Its from the postgres static doc version 7.3.1.
LelandJ Leland F. Jackson, CPA
Software - Master (TM)
Nothing Runs Like the Fox
this is for redhat 7.x
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
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
- Status
Similar threads
- Locked
- Question
- Locked
- Question