Invalid PG_PWD
От | pgsql-bugs@postgresql.org |
---|---|
Тема | Invalid PG_PWD |
Дата | |
Msg-id | 200008250856.e7P8u2469245@hub.org обсуждение исходный текст |
Список | pgsql-bugs |
Ricard Pillosu (rpillosu@atilon.com) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description Invalid PG_PWD Long Description We can't use pg_passwd to generate paswords for users, when pg_hba.conf contain : local password pg_pwd Firts, I generate password for postgres user, with the utility : pg_passwd pg_pwd After that, I try to create another user with password and the file pg_pwd that contained only postgres user, now containsonly tue new user in an older password format. From this point, it is impossible to connect to postgresql with anyuser. I must to edit pg_pwd, delete the line, execute pg_passswd pg_pwd again and then all is OK. If I try to create a user without pasword, the file pg_pwd becomes empty. If I modify the file pg_hba.conf like this : local password without the name of the file pg_pwd, then the password system seams to generate it's passwords inside the pg_shadow file,and I can work normally. Thanks. Sample Code Format with pg_passwd utility and pg_pwd param in pg_hba.conf : postgres:RAztuRdKHwkCQ Format without pg_passwd utility and without pg_pwd param in pg_hba.conf: adm_general 0 x x x x ADM \N No file was uploaded with this report
В списке pgsql-bugs по дате отправления: