On Wed, Jul 8, 2009 at 3:22 PM, Andreas Wenk <a.w...@netzmeister-st-pauli.de > 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@postgresql.org) > 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.
