Обсуждение: Auth users and command pg_passwd
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi. One year ago, I was worked with postgresql 7.1. In this, my pg_hba.conf was "finished-line" like this; password <path/to/file_passwords> Then, when I have one year whitout "touch" anything about postgres, I have compiled postgresql, but I do not find the command "pg_passwd" to create a file of passwords with same ciphered(coded). Where the command is "pg_passwd" in the version 7.2.3? Already it does not exist? With what command it has been replaced? I do not manage to find nothing of this in the documentation. I will apologize about my bad english... Sorry. Thank you very much!! - -- Have a nice day ;-) TooManySecrets -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (FreeBSD) iD8DBQE+S8mzICNFwaoqbY8RArUVAJ0UbUWL44hEkUlIUOOhDn2KSM9VVwCeIfPd GSgZqtjYhdbwWpx7EDeSLas= =HSP8 -----END PGP SIGNATURE-----
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? --------------------------------------------------------------------------- TooManySecrets wrote: [ PGP not available, raw data follows ] > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi. > > One year ago, I was worked with postgresql 7.1. In this, my pg_hba.conf was > "finished-line" like this; password <path/to/file_passwords> > > Then, when I have one year whitout "touch" anything about postgres, I have > compiled postgresql, but I do not find the command "pg_passwd" to create a > file of passwords with same ciphered(coded). > Where the command is "pg_passwd" in the version 7.2.3? Already it does not > exist? With what command it has been replaced? I do not manage to find > nothing of this in the documentation. > > I will apologize about my bad english... Sorry. > > Thank you very much!! > > - -- > Have a nice day ;-) > TooManySecrets > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.2.1 (FreeBSD) > > iD8DBQE+S8mzICNFwaoqbY8RArUVAJ0UbUWL44hEkUlIUOOhDn2KSM9VVwCeIfPd > GSgZqtjYhdbwWpx7EDeSLas= > =HSP8 > -----END PGP SIGNATURE----- > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.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
-----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-----
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