Also you need to specify the file name of password file in AUTH_ARGUMENT parameter in pg_hba.conf file.
TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMENT Local all password passfile > use the utility pg_passwd. The argument is the file that will hold the > passwords > $pg_passwd passfile > Username:postgres > New password: > Re-enter new password: > > -----Original Message----- > From: Web Administrator [mailto:[EMAIL PROTECTED]] > Sent: quarta-feira, 3 de abril de 2002 14:07 > To: [EMAIL PROTECTED] > Cc: Jin, Hong > Subject: [ADMIN] How to create a user with password > > > Hi, all: > > In the file of pg_hba.conf, I give the following parameter: > > TYPE DATABASE IP_ADDRESS MASK > AUTH_TYPE AUTH_ARGUMENT > Local all > password > host all 127.122.122.0 255.255.255.0 > password > > Now look what I got: > > $su postgres > bash$psql template1 > $password > > What is the password for user 'postgres' ? How can I > create one for this user? > > bash$createuser dbadmin > Shall the new user be allowed to create database?(y/n) y > Shall the new user be allowed to create more new user? (y/n) y > password: 'dbadminpassword' > FATAL 1: password authentication failed for user "postgres" > Createuser: creation of user 'dbadmin' failed > > If I change the config setting to > > Local all trust > > I can login to template1 database and create users and > databases, but I fail to give a password to a user. Look: > > $su postgres > bash$createuser dbadmin with password 'dbpassword' > > Now it seems the 'dbpasswod' became the created user. > > Anybody knows how to create password for 'postgres' ? How to > create a user with password? > > -------------------------------------------- > Hong Jin > [EMAIL PROTECTED] -- "Having nothing, nothing can he lose." -- William Shakespeare, "Henry VI" -- "Having nothing, nothing can he lose." -- William Shakespeare, "Henry VI" ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
