pre_auth_delay
A development GUC determining the delay before authentication occurs
pre_auth_delay is a development configuration parameter specifying the delay between a new server process being forked and authentication being conducted.
pre_auth_delay was added in PostgreSQL 7.2.
Usage
pre_auth_delay is intended primarily for testing and debugging the authentication process, and would not normally be enabled in a production cluster.
The valid range is 0 to 60 (seconds).
If changed to a value greater than 0, a delay of the specified interval will occur before the authentication process commences. There will be no output either to the client or in the PostgreSQL logs.
Default
The default value for pre_auth_delay is: 0.
Details by PostgreSQL version
pre_auth_delay (PostgreSQL 17)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Sets the amount of time to wait before authentication on connection startup. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline | |
| pending_restart | false |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 16)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Sets the amount of time to wait before authentication on connection startup. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline | |
| pending_restart | false |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 15)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Sets the amount of time to wait before authentication on connection startup. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline | |
| pending_restart | false |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 14)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline | |
| pending_restart | false |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 13)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline | |
| pending_restart | false |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 12)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline | |
| pending_restart | false |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 11)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline | |
| pending_restart | false |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 10)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline | |
| pending_restart | false |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 9.6)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline | |
| pending_restart | false |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 9.5)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline | |
| pending_restart | false |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 9.4)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 9.3)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 9.2)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 9.1)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 9.0)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 8.4)
| setting | 0 |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
| enumvals | |
| boot_val | 0 |
| reset_val | 0 |
| sourcefile | |
| sourceline |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 8.3)
| setting | |
| unit | s |
| category | Developer Options |
| short_desc | Waits N seconds on connection startup before authentication. |
| extra_desc | This allows attaching a debugger to the process. |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
Documentation: pre_auth_delay
pre_auth_delay (PostgreSQL 8.2)
| setting | |
| unit | s |
| category | Developer Options |
| short_desc | no description available |
| extra_desc | |
| context | sighup |
| vartype | integer |
| source | default |
| min_val | 0 |
| max_val | 60 |
Documentation: pre_auth_delay
Change history
- PostgreSQL 7.2
- added (commit 35b7601b)
References
- PostgreSQL documentation: pre_auth_delay