Hi When I write the following commands at the prompt,
>createuser -S -d -R user1 > createdb sample
I am asked to enter a password. I have not set any password anywhere. Which password is it asking for? Please help. I have built from source on Windows XP.
Thanks is advance,
Regards Swati
Hi Swati,
what are the setting of your pg_hba.conf? I assume that there is a entry like this:
# TYPE DATABASE USER CIDR-ADDRESS METHOD
# "local" is for Unix domain socket connections only local all all password
That means that the password you are asked is the password of the standard user for your cluster - commonly postgres.
Cheers
Andy
*argh* - more detailed to avoid confusion. The auth method 'password' in pg_hba.conf means, that you will be asked for a password for the user you try to create a db with. If no user is given (with createdb -U [username]), this user is postgres ...
If you don't need the password authentication you have to edit the pg_conf file and replace "password" with "trust", after this reload the cluster. It won't prompt you for password.