Thread: Assigning Password to New created user
Hello All,
I am trying to create database creation script.
Authentication method in pg_hba.conf is set to 'Password'.
1) I want to create a new user and want to assign a password to it internally (Something like createuser qsweb -P <password>)
2) When script issue command it ask for Superuser password. is there any way to provide this also internally??
Thanks in Advance
With Regards
Ashish....
On Tue, 2007-06-05 at 11:34 +0530, Ashish Karalkar wrote: > Hello All, > > I am trying to create database creation script. > Authentication method in pg_hba.conf is set to 'Password'. > > 1) I want to create a new user and want to assign a password to it > internally (Something like createuser qsweb -P <password>) > 2) When script issue command it ask for Superuser password. is there > any way to provide this also internally?? > You can put it in a .pgpass file in your home directory : http://www.postgresql.org/docs/8.2/interactive/libpq-pgpass.html Make sure the permissions are 0600. Or (not recommended for security reasons) you can set and export the environment variable PGPASSWORD. -- Oliver Elphick olly@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA ======================================== Do you want to know God? http://www.lfix.co.uk/knowing_god.html