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:
> Hi,
>
>
Felipe Nascimento wrote:
> Could you explain primary and secondary passwords?
> How can I create primary passwords?
Primary passwords are stored in pg_shadow. We will not even support
secondary passwords in 7.3 so don't worry about them. It was an old
idea to allow /etc/passwd to function in Po
Title: RE: [ADMIN] createuser --password
Could you explain primary and secondary passwords?
How can I create primary passwords?
Is a lack of security using only this secondary passwords?
Tks
Felipe
-Original Message-
From: Bruce Momjian [mailto:[EMAIL PROTECTED]]
Sent: segunda
oking for is: pg_passwd
>
> Felipe
>
> -Original Message-
> From: Stephane Schildknecht [mailto:[EMAIL PROTECTED]]
> Sent: segunda-feira, 8 de julho de 2002 06:07
> To: Postgresql-Admin; PostgreSQL-General
> Subject: [ADMIN] createuser --password
>
>
> Hi,
&
Title: RE: [ADMIN] createuser --password
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:[EMAIL PROTECTED]]
Sent: segunda-feira, 8 de julho
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
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:[E