scram_iterations
The number of computational iterations to be performed when encrypting a password using SCRAM-SHA-256. The default is 4096. A higher number of iterations provides additional protection against brute-force attacks on stored passwords, but makes authentication slower. Changing the value has no effect on existing passwords encrypted with SCRAM-SHA-256 as the iteration count is fixed at the time of encryption. In order to make use of a changed value, a new password must be set. Note If a role password was created with a different iteration count than the value of scram_iterations specified in the postgresql.conf file or on the server command line, an unauthenticated user can discern the existence of the role by observing discrepancies in the server's responses to connection attempts. If you find this concerning, ensure that all role passwords are created with scram_iterations set to the value specified in the postgresql.conf file or on the server command line.
英文手册覆盖始于 PostgreSQL 7.4. 来源历史与运行验证各自保留独立版本边界。
当前阅读 PG 18·选择有来源记录的版本
此版本暂无所选语言的定义，以下显示原始英文内容。
- boot val
- 4096
- category
- Connections and Authentication / Authentication
- context
- user
- documented
- true
- enumvals
- 未知
- extra desc
- 未知
- lang
- en
- max val
- 2147483647
- metadata version
- 18
- min val
- 1
- name
- scram_iterations
- short desc
- Sets the iteration count for SCRAM secret generation.
- source
- pg-settings-source-snapshot
- unit
- 未知
- vartype
- integer
版本定义 PG 18
The number of computational iterations to be performed when encrypting a password using SCRAM-SHA-256. The default is 4096. A higher number of iterations provides additional protection against brute-force attacks on stored passwords, but makes authentication slower. Changing the value has no effect on existing passwords encrypted with SCRAM-SHA-256 as the iteration count is fixed at the time of encryption. In order to make use of a changed value, a new password must be set. Note If a role password was created with a different iteration count than the value of scram_iterations specified in the postgresql.conf file or on the server command line, an unauthenticated user can discern the existence of the role by observing discrepancies in the server's responses to connection attempts. If you find this concerning, ensure that all role passwords are created with scram_iterations set to the value specified in the postgresql.conf file or on the server command line.
比较版本
来源引用
定义来源
center · PostgreSQL 18 · english-manuals:9247ef2e985d9470767d84f96ee480028094dfc72dc6b9cd3bea7b1d890a9a63
正文语言: en · english-manuals:9247ef2e985d9470767d84f96ee480028094dfc72dc6b9cd3bea7b1d890a9a63