How to create a user with password 
Author Message
 How to create a user with password

This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C1DAEF.BF4B3320
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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

------=_NextPart_000_0000_01C1DAEF.BF4B3320
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3DWindows-1=
252">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 6.0.5762.3">
<TITLE> How to create a user with password</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi, all:</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;In the file of pg_hba.conf, I give =
the following parameter:</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;TYPE&nbsp;&nbsp; DATABASE&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IP_ADDRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MASK&nbsp;&nbsp;&nbsp; &nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;AUTH_TYPE&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUTH_ARGUMENT</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;Local&nbsp; all&nbsp;&nbsp;&nbsp;&n=
bsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;password&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;host&nbsp;&nbsp; all&nbsp;&nbsp;&nb=
sp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.122.122.0&nbsp;&nb=
sp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 255.255.255.0&nbsp;&nbsp; </=
FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;password&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
; Now look what I got:</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;$su postgres</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;bash$psql template1</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;$password</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Wha=
t is the password for user 'postgres' ? How can I </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;create one for this user?</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;bash$createuser dbadmin</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;Shall the new user be allowed to cr=
eate database?(y/n) y</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;Shall the new user be allowed to cr=
eate more new user? (y/n) y</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;password: 'dbadminpassword'</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;FATAL 1: password authentication fa=
iled for user &quot;postgres&quot;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;Createuser: creation of user 'dbadm=
in' failed</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
; If I change the config setting to </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;Local&nbsp; all&nbsp;&nbsp;&nbsp;&n=
bsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp; trust</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
; I can login to template1 database and create users and </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;databases, but I fail to give a pas=
sword to a user. Look:</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;$su postgres</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;bash$createuser dbadmin with passwo=
rd 'dbpassword'</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
; Now it seems the 'dbpasswod' became the created user.</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;Anybody knows how to create passwor=
d for 'postgres' ? How to </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;create a user with password?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
 </FONT>

<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial">&nbsp;-----------------=
--------------------------- </FONT>

<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial">&nbsp;Hong Jin</FONT>


</P>

</BODY>
</HTML>
------=_NextPart_000_0000_01C1DAEF.BF4B3320--



Mon, 20 Sep 2004 04:50:42 GMT
 How to create a user with password

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C1DBD1.60034780
Content-Type: text/plain; charset="iso-8859-1"

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:

Quote:
-----Original Message-----

Sent: quarta-feira, 3 de abril de 2002 14:07

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

------_=_NextPart_001_01C1DBD1.60034780
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3Diso-8859-=
1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 5.5.2653.12">
<TITLE>RE: [ADMIN] How to create a user with password</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>use the utility pg_passwd. The argument is the file that =
will hold the passwords</FONT>
<BR><FONT SIZE=3D2>&nbsp;$pg_passwd&nbsp; passfile </FONT>
<BR><FONT SIZE=3D2>Username:postgres </FONT>
<BR><FONT SIZE=3D2>New password: </FONT>
<BR><FONT SIZE=3D2>Re-enter new password: </FONT>
</P>

<P><FONT SIZE=3D2>-----Original Message-----</FONT>


<BR><FONT SIZE=3D2>Sent: quarta-feira, 3 de abril de 2002 14:07</FONT>

<BR><FONT SIZE=3D2>Cc: Jin, Hong</FONT>
<BR><FONT SIZE=3D2>Subject: [ADMIN] How to create a user with password</FON=
T>
</P>
<BR>

<P><FONT SIZE=3D2>Hi, all: </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;In the file of pg_hba.conf, I give the following p=
arameter: </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;TYPE&nbsp;&nbsp; DATABASE&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp; IP_ADDRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MASK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;AUTH_TYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUTH_ARGUMENT </FONT>
<BR><FONT SIZE=3D2>&nbsp;Local&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;password&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;host&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.122.122.0&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 255.255.255.0&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;password&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FON=
T>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Now look what=
 I got: </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;$su postgres </FONT>
<BR><FONT SIZE=3D2>&nbsp;bash$psql template1 </FONT>
<BR><FONT SIZE=3D2>&nbsp;$password </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; What is the p=
assword for user 'postgres' ? How can I </FONT>
<BR><FONT SIZE=3D2>&nbsp;create one for this user? </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;bash$createuser dbadmin </FONT>
<BR><FONT SIZE=3D2>&nbsp;Shall the new user be allowed to create database?(=
y/n) y </FONT>
<BR><FONT SIZE=3D2>&nbsp;Shall the new user be allowed to create more new u=
ser? (y/n) y </FONT>
<BR><FONT SIZE=3D2>&nbsp;password: 'dbadminpassword' </FONT>
<BR><FONT SIZE=3D2>&nbsp;FATAL 1: password authentication failed for user &=
quot;postgres&quot; </FONT>
<BR><FONT SIZE=3D2>&nbsp;Createuser: creation of user 'dbadmin' failed </FO=
NT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If I change t=
he config setting to </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;Local&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; trust </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I can login t=
o template1 database and create users and </FONT>
<BR><FONT SIZE=3D2>&nbsp;databases, but I fail to give a password to a user=
. Look: </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;$su postgres </FONT>
<BR><FONT SIZE=3D2>&nbsp;bash$createuser dbadmin with password 'dbpassword'=
 </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Now it seems =
the 'dbpasswod' became the created user. </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;Anybody knows how to create password for 'postgres=
' ? How to </FONT>
<BR><FONT SIZE=3D2>&nbsp;create a user with password? </FONT>
<BR><FONT SIZE=3D2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
<BR><FONT SIZE=3D2>&nbsp;-------------------------------------------- </FON=
T>
<BR><FONT SIZE=3D2>&nbsp;Hong Jin </FONT>

</P>

</BODY>
</HTML>
------_=_NextPart_001_01C1DBD1.60034780--



Mon, 20 Sep 2004 20:26:42 GMT
 How to create a user with password
This is a multi-part message in MIME format.

------=_NextPart_000_0000_01C1DA45.A97FAD00
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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

------=_NextPart_000_0000_01C1DA45.A97FAD00
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3DWindows-1=
252">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 6.0.5762.3">
<TITLE>How to create a user with password</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT SIZE=3D2 FACE=3D"Arial">Hi, all:</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">In the file of pg_hba.conf, I give the fol=
lowing parameter:</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">TYPE&nbsp;&nbsp;&nbsp; DATABASE&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; IP_ADDRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MASK&nbsp;&nbsp;&nbsp; &nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUTH_TYPE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUTH_ARGUMENT</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Local&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&n=
bsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; password&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">host&nbsp;&nbsp;&nbsp; all&nbsp;&nbsp;&nb=
sp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.122.122.0&nbsp;&nb=
sp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 255.255.255.0&nbsp;&nbsp; pa=
ssword&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 FACE=3D"Arial"=

Quote:
>Now look what I got:</FONT>

</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">$su postgres</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">bash$psql template1</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">$password</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
 What is the password for user 'postgres' ? How can I create one for this u=
ser?</FONT>
</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">bash$createuser dbadmin</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Shall the new user be allowed to create d=
atabase?(y/n) y</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Shall the new user be allowed to create m=
ore new user? (y/n) y</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">password: 'dbadminpassword'</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">FATAL 1: password authentication failed f=
or user &quot;postgres&quot;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">Createuser: creation of user 'dbadmin' fa=
iled</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 FACE=3D"Arial"=

Quote:
>If I change the config setting to </FONT>

</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Local &nbsp; all&nbsp;&nbsp;&nbsp;&nbsp; &=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp; trust</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 FACE=3D"Arial"=

Quote:
>I can login to template1 database and create users and databases, but I fa=

il to give a password to a user. Look:</FONT></P>

<P><FONT SIZE=3D2 FACE=3D"Arial">$su postgres</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">bash$createuser dbadmin with password 'db=
password'</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <FONT SIZE=3D2 FACE=3D"Arial"=

Quote:
>Now it seems the 'dbpasswod' became the created user.</FONT>

</P>

<P><FONT SIZE=3D2 FACE=3D"Arial">Anybody knows how to create password for '=
postgres' ? How to create a user with password?</FONT>
</P>

<P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20

<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial">-----------------------=
---------------------</FONT>
</P>

<P><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial">Hong Jin</FONT>


</P>

</BODY>
</HTML>
------=_NextPart_000_0000_01C1DA45.A97FAD00--



Mon, 20 Sep 2004 23:37:12 GMT
 How to create a user with password
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

Quote:
> 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-----

> Sent: quarta-feira, 3 de abril de 2002 14:07

> 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


--
"Having nothing, nothing can he lose."
                -- William Shakespeare, "Henry VI"

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster



Mon, 20 Sep 2004 23:57:35 GMT
 How to create a user with password
This is a multi-part message in MIME format.

------=_NextPart_000_0010_01C1DA53.E2ECE040
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Quote:
> 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


------=_NextPart_000_0010_01C1DA53.E2ECE040
Content-Type: text/html;
        charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3DWindows-1=
252">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 6.0.5762.3">
<TITLE> How to create a user with password</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->

<P><FONT SIZE=3D2 FACE=3D"Arial">&gt; Hi, all:</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; In the file of pg_hba.conf, I give t=
he following parameter:</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; TYPE&nbsp; DATABASE&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp; IP_ADDRESS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MASK&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; AUTH_TYPE&nbsp;&nbsp;&nbsp;&nbsp; &n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AUTH_ARGUMENT</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Local all&nbsp;&nbsp;&nbsp;&nbsp; &n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; password&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; host&nbsp; all&nbsp;&nbsp;&nbsp;&nbs=
p; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 127.122.122.0&nbsp;&nbsp; &nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 255.255.255.0&nbsp;&nbsp; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; password&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Now l=
ook what I got:</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; $su postgres</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; bash$psql template1</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; $password</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; What =
is the password for user 'postgres' ? How can I </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; create one for this user?</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; bash$createuser dbadmin</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Shall the new user be allowed to cre=
ate database?(y/n) y</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Shall the new user be allowed to cre=
ate more new user? (y/n) y</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; password: 'dbadminpassword'</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; FATAL 1: password authentication fai=
led for user &quot;postgres&quot;</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Createuser: creation of user 'dbadmi=
n' failed</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If I =
change the config setting to </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Local &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp; all&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; trust</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I can=
 login to template1 database and create users and </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; databases, but I fail to give a pass=
word to a user. Look:</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; $su postgres</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; bash$createuser dbadmin with passwor=
d 'dbpassword'</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Now i=
t seems the 'dbpasswod' became the created user.</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; Anybody knows how to create password=
 for 'postgres' ? How to </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; create a user with password?</FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </FON=
T>

<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial">&gt; ------------------=
--------------------------</FONT>

<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial">&gt; </FONT>

<BR><FONT COLOR=3D"#000000" SIZE=3D2 FACE=3D"Arial">&gt; Hong Jin</FONT>


<BR><FONT SIZE=3D2 FACE=3D"Arial">&gt; </FONT>
</P>

</BODY>
</HTML>
------=_NextPart_000_0010_01C1DA53.E2ECE040--



Tue, 21 Sep 2004 00:09:56 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. How to create a user with password]

2. FW: create user / password

3. Creating New User in Accessdb (with password)?

4. Newbe: create users & passwords

5. R: Creating New User in Accessdb (with password)?

6. Create user and password via SQL script ??

7. create user / password

8. How do I create Users and Passwords?

9. creating username and password from user reg data

10. CREATE USER command? How to create user accounts

11. User gets password restricted access without using a password


 
Powered by phpBB® Forum Software