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 [EMAIL PROTECTED] > [ End of raw data] -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
