How to create a user with password

From: "Web Administrator" <webadmin(at)ucsd-pps(dot)ucsd(dot)edu>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: How to create a user with password
Date: 2002-04-02 20:56:59
Message-ID: 9D9CD511E4A9D345ABDBCD1A3EC5238F055430@mckenzie.AD.UCSD.EDU
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Judy Jecelin 2002-04-02 22:27:09 indexes separate from data
Previous Message Tom Lane 2002-04-02 20:39:42 Re: Help I ve just delete pg_xlog