createuser --password

On Mon, Jul 08, 2002 at 11:06:39AM +0200, Stephane Schildknecht wrote:

Hi,

Hello ;-).

Is there a way to give the password of the user to be created on the
command line ?

From command line you can try to do "ALTER USER", using "-c" switch
of psql, eg like this:

psql -c "ALTER USER test WITH PASSWORD 'test';" template1

	Best regards,
-- 
--- Artur Pietruk, arturp@plukwa.net

take a look at.
http://archives.postgresql.org/pgsql-admin/2001-09/msg00095.php

the utility you are looking for is: pg_passwd

Felipe

-----Original Message-----
From: Stephane Schildknecht [mailto:sschildknecht@aurora-linux.com]
Sent: segunda-feira, 8 de julho de 2002 06:07
To: Postgresql-Admin; PostgreSQL-General
Subject: [ADMIN] createuser --password

Hi,

Is there a way to give the password of the user to be created on the
command line ?

S@S
--
_Stéphane SCHILDKNECHT___________________________________
| AurorA-SAS 69-71, Av. Pierre Grenier 92100 BOULOGNE |
| Tel : 01.58.17.03.20 Fax : 01.58.17.03.21 |
| mailto:sschildknecht@aurora-linux.com - ICQ : 142504394 |
| "Free Markets have taught that innovation is best when |
| ideas flow freely." Adam Smith |
|_________________________________________________________|

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

Uh, not really. pg_passwd is for managing secondary passwords.

---------------------------------------------------------------------------

Felipe Nascimento wrote:

take a look at.
http://archives.postgresql.org/pgsql-admin/2001-09/msg00095.php

the utility you are looking for is: pg_passwd

Felipe

-----Original Message-----
From: Stephane Schildknecht [mailto:sschildknecht@aurora-linux.com]
Sent: segunda-feira, 8 de julho de 2002 06:07
To: Postgresql-Admin; PostgreSQL-General
Subject: [ADMIN] createuser --password

Hi,

Is there a way to give the password of the user to be created on the
command line ?

S@S
--
_St?phane SCHILDKNECHT___________________________________
| AurorA-SAS 69-71, Av. Pierre Grenier 92100 BOULOGNE |
| Tel : 01.58.17.03.20 Fax : 01.58.17.03.21 |
| mailto:sschildknecht@aurora-linux.com - ICQ : 142504394 |
| "Free Markets have taught that innovation is best when |
| ideas flow freely." Adam Smith |
|_________________________________________________________|

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Hi,

I am not sure about the command line option, but the password for any user
can be set using ALTER USER sql command.

ALTER USER my_user ENCRYPTED PASSWORD 'my_pass';

also refer the documentation for details.

regards,
bhuvaneswaran.

On 8 Jul 2002, Stephane Schildknecht wrote: