Postgres Pro
Downloads
Home   >   mailing lists

Thread: Add user on old database with password

Add user on old database with password

From
"Ramesh PAtel "
Date:
<div align="left"><font face="Arial"><span style="font-size:10pt">Hi All</span></font></div><div align="left"><br
/></div><divalign="left"><font face="Arial"><span style="font-size:10pt">i am new on Postgresql7.3. so please
help.</span></font></div><divalign="left"><br /></div><div align="left"><font face="Arial"><span
style="font-size:10pt">ihave create one(ICPS) Database  with Postgre user and password is NULL.</span></font></div><div
align="left"><fontface="Arial"><span style="font-size:10pt">now i want to</span></font></div><div align="left"><font
face="Arial"><spanstyle="font-size:10pt">1) create one user with password and all Grant on Database. it is a admin
user</span></font></div><divalign="left"><font face="Arial"><span style="font-size:10pt">2) i want to add password to
postgresuser.</span></font></div><div align="left"><br /></div><div align="left"><font face="Arial"><span
style="font-size:10pt">PleaseHelp</span></font></div><div align="left"><br /></div><div align="left"><font
face="Arial"><spanstyle="font-size:10pt">Ramesh Patel</span></font></div><div align="left"><font face="Arial"><span
style="font-size:10pt">ramesh@banas.guj.nic.in</span></font></div><divalign="left"></div>

Re: Add user on old database with password

From
"A.Bhuvaneswaran"
Date:
> 1) create one user with password and all Grant on Database. it is a admin
> user

The below steps would help:

$ su - postgres
$ createuser your_user
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
CREATE USER

Use GRANT command to grant privileges to specified user.

> 2) i want to add password to postgres user.

1) If the authentication mode is trust then it is simple. Connect to any
database as postgres and using alter user you must be able to set password
for postgres user.

2) If the authentication mode is any other, then you may not be able to
connect to any database as postgres user, since you didn't set password
for postgres user. So, set the authentication mode to trust and restart
postmaster and repeat step one to set password for postgres user. Finally
restore the authentication mode.

regards,
bhuvaneswaran