You can assign the password as part of createuser, and it is stored
encrypted in the database.
---------------------------------------------------------------------------
TooManySecrets wrote:
[ PGP not available, raw data follows ]
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On Thursday 13 February 2003 20:34, Bruce Momjian wrote:
> > pg_password is gone. Few were using it, and now we encrypt the
> > passwords stored in pg_shadow. Were you sharing your /etc/password file
> > with PostgreSQL, or did you have another reason for using pg_password?
>
> Not. I before was creating a user with the command "createuser", and then,
> like as user "postgres", was executing the command " pg_passwd data/passwd ",
> where one was guarding the user and his key encripted. Hereby, in the file
> "pg_hba.conf", it was had by place (the authentication ) this way:
> password/var/lib/data/passwd
>
> I will study more held up the documentation.
>
> Thank you very much.
>
> - --
> Have a nice day ;-)
> TooManySecrets
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.2.1 (FreeBSD)
>
> iD8DBQE+TKLyICNFwaoqbY8RAqcKAJ9ghIexbX9XMryJkUy2MRA/Mr9ngACeLx8V
> lNKlsSlaKTPVWj+6gED8Tkk=
> =ismN
> -----END PGP SIGNATURE-----
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
[ End of raw data]
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073