Re: 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
h1jin(at)ucsd(dot)edu

login using trust authentication method. Then change the password
for postgresql user with
'alter user command. I think this will work .
Thanks
chava
--

Srinivasa R Chava (Chava) <s(dot)chava(at)wcom(dot)com>
- Boss: Sean T Laduderdale <sean(dot)lauderdale(at)wcom(dot)com>
vnet4603575
Application Developer
Corporate Intra/Internet Systems
WORLDCOM - http://www.worldcom.com/ - NASDAQ:WCOM
500 Clinton Center Drive (Corporate Headquarters)
Clinton, Mississippi (MS) USA 39056
(601)460-3122 / vnet4603122 / (800)844-1009 / FAX(601)460-8257