Обсуждение: 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@ucsd.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.chava@wcom.com> - Boss: Sean T Laduderdale <sean.lauderdale@wcom.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
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:webadmin@ucsd-pps.ucsd.edu]
Sent: quarta-feira, 3 de abril de 2002 14:07
To: pgsql-admin@postgresql.org
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
h1jin@ucsd.edu
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:webadmin@ucsd-pps.ucsd.edu]
> Sent: quarta-feira, 3 de abril de 2002 14:07
> To: pgsql-admin@postgresql.org
> 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
> h1jin@ucsd.edu
--
"Having nothing, nothing can he lose."
-- William Shakespeare, "Henry VI"