Re: Password?

[Abbas <abbas.dba@xxxxxxxxx>]

On Wed, Jul 8, 2009 at 3:22 PM, Andreas Wenk <a.wenk@xxxxxxxxxxxxxxxxxxxxxxx> wrote:

Andreas Wenk schrieb:

Ms swati chande schrieb:

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 ...

see also createdb --help for options ...

Cheers

Andy

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

      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.

Thanks,
Abbas.