Postgres Pro
Downloads
Home   >   mailing lists

Thread: How to create a user with password

How to create a user with password

From
"Web Administrator"
Date:

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

Re: How to create a user with password

From
Srinivasa R Chava
Date:
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

Re: How to create a user with password

From
Felipe Nascimento
Date:

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

Re: How to create a user with password

From
"Nasir Simbolon"
Date:
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"