Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
allow_in_place_tablespaces
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows tablespaces directly inside pg_tblspc, for testing. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_in_place_tablespaces |
allow_system_table_mods
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows modifications of the structure of system tables. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_system_table_mods |
backtrace_functions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Log backtrace for errors in these functions. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | backtrace_functions |
debug_discard_caches
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Aggressively flush system caches for debugging purposes. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | debug_discard_caches |
debug_io_direct
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Use direct I/O for file access. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | debug_io_direct |
debug_logical_replication_streaming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces immediate streaming or serialization of changes in large transactions. On the publisher, it allows streaming or serializing each change in logical decoding. On the subscriber, it allows serialization of all changes to files and notifies the parallel apply workers to read and apply them at the end of the transaction. |
| Data type | enumeration |
| Default value | buffered |
| Allowed values | buffered |
| Parameter type | read-only |
| Documentation | debug_logical_replication_streaming |
debug_parallel_query
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces the planner's use parallel query nodes. This can be useful for testing the parallel query infrastructure by forcing the planner to generate plans that contain nodes that perform tuple communication between workers and the main process. |
| Data type | enumeration |
| Default value | off |
| Allowed values | off,on,regress |
| Parameter type | dynamic |
| Documentation | debug_parallel_query |
ignore_checksum_failure
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing after a checksum failure. Detection of a checksum failure normally causes PostgreSQL to report an error, aborting the current transaction. Setting ignore_checksum_failure to true causes the system to ignore the failure (but still report a warning), and continue processing. This behavior could cause crashes or other serious problems. Only has an effect if checksums are enabled. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_checksum_failure |
ignore_invalid_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues recovery after an invalid pages failure. Detection of WAL records having references to invalid pages during recovery causes PostgreSQL to raise a PANIC-level error, aborting the recovery. Setting "ignore_invalid_pages" to true causes the system to ignore invalid page references in WAL records (but still report a warning), and continue recovery. This behavior may cause crashes, data loss, propagate or hide corruption, or other serious problems. Only has an effect during recovery or in standby mode. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_invalid_pages |
ignore_system_indexes
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Disables reading from system indexes. It does not prevent updating the indexes, so it is safe to use. The worst consequence is slowness. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_system_indexes |
jit_debugging_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT-compiled functions with debugger. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_debugging_support |
jit_dump_bitcode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Write out LLVM bitcode to facilitate JIT debugging. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_dump_bitcode |
jit_expressions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of expressions. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_expressions |
jit_profiling_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT-compiled functions with perf profiler. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_profiling_support |
jit_tuple_deforming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of tuple deforming. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_tuple_deforming |
post_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the amount of time to wait after authentication on connection startup. This allows attaching a debugger to the process. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | post_auth_delay |
pre_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the amount of time to wait before authentication on connection startup. This allows attaching a debugger to the process. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | pre_auth_delay |
remove_temp_files_after_crash
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Remove temporary files after backend crash. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | remove_temp_files_after_crash |
send_abort_for_crash
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Send SIGABRT not SIGQUIT to child processes after backend crash. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | send_abort_for_crash |
send_abort_for_kill
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Send SIGABRT not SIGKILL to stuck child processes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | send_abort_for_kill |
trace_connection_negotiation
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Logs details of pre-authentication connection handshake. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_connection_negotiation |
trace_notify
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Generates debugging output for LISTEN and NOTIFY. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_notify |
trace_sort
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Emit information about resource usage in sorting. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_sort |
wal_consistency_checking
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the WAL resource managers for which WAL consistency checks are done. Full-page images will be logged for all data blocks and cross-checked against the results of WAL replay. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | wal_consistency_checking |
zero_damaged_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing past damaged page headers. Detection of a damaged page header normally causes PostgreSQL to report an error, aborting the current transaction. Setting "zero_damaged_pages" to true causes the system to instead report a warning, zero out the damaged page, and continue processing. This behavior will destroy data, namely all the rows on the damaged page. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | zero_damaged_pages |
allow_in_place_tablespaces
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows tablespaces directly inside pg_tblspc, for testing. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_in_place_tablespaces |
allow_system_table_mods
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows modifications of the structure of system tables. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_system_table_mods |
backtrace_functions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Log backtrace for errors in these functions. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | backtrace_functions |
debug_discard_caches
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Aggressively flush system caches for debugging purposes. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | debug_discard_caches |
debug_io_direct
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Use direct I/O for file access. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | debug_io_direct |
debug_logical_replication_streaming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces immediate streaming or serialization of changes in large transactions. On the publisher, it allows streaming or serializing each change in logical decoding. On the subscriber, it allows serialization of all changes to files and notifies the parallel apply workers to read and apply them at the end of the transaction. |
| Data type | set |
| Default value | buffered |
| Allowed values | buffered |
| Parameter type | read-only |
| Documentation | debug_logical_replication_streaming |
debug_parallel_query
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces use of parallel query facilities. |
| Data type | enumeration |
| Default value | off |
| Allowed values | off,on,regress |
| Parameter type | dynamic |
| Documentation | debug_parallel_query |
ignore_checksum_failure
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing after a checksum failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_checksum_failure |
ignore_invalid_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues recovery after an invalid pages failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_invalid_pages |
ignore_system_indexes
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Disables reading from system indexes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_system_indexes |
jit_debugging_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT-compiled functions with debugger. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_debugging_support |
jit_dump_bitcode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Write out LLVM bitcode to facilitate JIT debugging. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_dump_bitcode |
jit_expressions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of expressions. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_expressions |
jit_profiling_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT-compiled functions with perf profiler. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_profiling_support |
jit_tuple_deforming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of tuple deforming. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_tuple_deforming |
post_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the amount of time to wait after authentication on connection startup. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | post_auth_delay |
pre_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the amount of time to wait before authentication on connection startup. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | pre_auth_delay |
remove_temp_files_after_crash
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Remove temporary files after backend crash. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | remove_temp_files_after_crash |
send_abort_for_crash
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Send SIGABRT not SIGQUIT to child processes after backend crash. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | send_abort_for_crash |
send_abort_for_kill
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Send SIGABRT not SIGKILL to stuck child processes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | send_abort_for_kill |
trace_connection_negotiation
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Logs details of pre-authentication connection handshake. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_connection_negotiation |
trace_notify
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Generates debugging output for LISTEN and NOTIFY. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_notify |
trace_sort
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Emit information about resource usage in sorting. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_sort |
wal_consistency_checking
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the WAL resource managers for which WAL consistency checks are done. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | wal_consistency_checking |
zero_damaged_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing past damaged page headers. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | zero_damaged_pages |
allow_in_place_tablespaces
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows tablespaces directly inside pg_tblspc, for testing. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_in_place_tablespaces |
allow_system_table_mods
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows modifications of the structure of system tables. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_system_table_mods |
backtrace_functions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Log backtrace for errors in these functions. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | backtrace_functions |
debug_discard_caches
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Aggressively flush system caches for debugging purposes. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | debug_discard_caches |
debug_io_direct
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Use direct I/O for file access. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | debug_io_direct |
debug_logical_replication_streaming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces immediate streaming or serialization of changes in large transactions. On the publisher, it allows streaming or serializing each change in logical decoding. On the subscriber, it allows serialization of all changes to files and notifies the parallel apply workers to read and apply them at the end of the transaction. |
| Data type | set |
| Default value | buffered |
| Allowed values | buffered |
| Parameter type | read-only |
| Documentation | debug_logical_replication_streaming |
debug_parallel_query
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces use of parallel query facilities. |
| Data type | enumeration |
| Default value | off |
| Allowed values | off,on,regress |
| Parameter type | dynamic |
| Documentation | debug_parallel_query |
ignore_checksum_failure
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing after a checksum failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_checksum_failure |
ignore_invalid_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues recovery after an invalid pages failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_invalid_pages |
ignore_system_indexes
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Disables reading from system indexes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_system_indexes |
jit_debugging_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT-compiled functions with debugger. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_debugging_support |
jit_dump_bitcode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Write out LLVM bitcode to facilitate JIT debugging. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_dump_bitcode |
jit_expressions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of expressions. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_expressions |
jit_profiling_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT-compiled functions with perf profiler. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_profiling_support |
jit_tuple_deforming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of tuple deforming. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_tuple_deforming |
post_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the amount of time to wait after authentication on connection startup. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | post_auth_delay |
pre_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the amount of time to wait before authentication on connection startup. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | pre_auth_delay |
remove_temp_files_after_crash
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Remove temporary files after backend crash. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | remove_temp_files_after_crash |
send_abort_for_crash
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Send SIGABRT not SIGQUIT to child processes after backend crash. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | send_abort_for_crash |
send_abort_for_kill
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Send SIGABRT not SIGKILL to stuck child processes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | send_abort_for_kill |
trace_notify
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Generates debugging output for LISTEN and NOTIFY. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_notify |
trace_recovery_messages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Enables logging of recovery-related debugging information. |
| Data type | enumeration |
| Default value | log |
| Allowed values | log |
| Parameter type | read-only |
| Documentation | trace_recovery_messages |
trace_sort
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Emit information about resource usage in sorting. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_sort |
wal_consistency_checking
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the WAL resource managers for which WAL consistency checks are done. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | wal_consistency_checking |
zero_damaged_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing past damaged page headers. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | zero_damaged_pages |
allow_in_place_tablespaces
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows tablespaces directly inside pg_tblspc, for testing. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_in_place_tablespaces |
allow_system_table_mods
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows modifications of the structure of system tables. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_system_table_mods |
backtrace_functions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Log backtrace for errors in these functions. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | backtrace_functions |
debug_discard_caches
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Aggressively flush system caches for debugging purposes. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | debug_discard_caches |
force_parallel_mode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces use of parallel query facilities. |
| Data type | enumeration |
| Default value | off |
| Allowed values | off,on,regress |
| Parameter type | dynamic |
| Documentation | force_parallel_mode |
ignore_checksum_failure
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing after a checksum failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_checksum_failure |
ignore_invalid_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues recovery after an invalid pages failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_invalid_pages |
ignore_system_indexes
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Disables reading from system indexes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_system_indexes |
jit_debugging_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT-compiled functions with debugger. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_debugging_support |
jit_dump_bitcode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Write out LLVM bitcode to facilitate JIT debugging. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_dump_bitcode |
jit_expressions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of expressions. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_expressions |
jit_profiling_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT-compiled functions with perf profiler. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_profiling_support |
jit_tuple_deforming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of tuple deforming. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_tuple_deforming |
post_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the amount of time to wait after authentication on connection startup. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | post_auth_delay |
pre_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the amount of time to wait before authentication on connection startup. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | pre_auth_delay |
trace_notify
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Generates debugging output for LISTEN and NOTIFY. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_notify |
trace_recovery_messages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Enables logging of recovery-related debugging information. |
| Data type | enumeration |
| Default value | log |
| Allowed values | log |
| Parameter type | read-only |
| Documentation | trace_recovery_messages |
trace_sort
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Emit information about resource usage in sorting. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_sort |
wal_consistency_checking
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the WAL resource managers for which WAL consistency checks are done. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | wal_consistency_checking |
zero_damaged_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing past damaged page headers. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | zero_damaged_pages |
allow_in_place_tablespaces
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows tablespaces directly inside pg_tblspc, for testing. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_in_place_tablespaces |
allow_system_table_mods
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows modifications of the structure of system tables. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_system_table_mods |
backtrace_functions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Log backtrace for errors in these functions. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | backtrace_functions |
debug_discard_caches
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Aggressively flush system caches for debugging purposes. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | debug_discard_caches |
force_parallel_mode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces use of parallel query facilities. |
| Data type | enumeration |
| Default value | off |
| Allowed values | off,on,regress |
| Parameter type | dynamic |
| Documentation | force_parallel_mode |
ignore_checksum_failure
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing after a checksum failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_checksum_failure |
ignore_invalid_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues recovery after an invalid pages failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_invalid_pages |
ignore_system_indexes
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Disables reading from system indexes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_system_indexes |
jit_debugging_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT-compiled functions with debugger. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_debugging_support |
jit_dump_bitcode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Write out LLVM bitcode to facilitate JIT debugging. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_dump_bitcode |
jit_expressions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of expressions. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_expressions |
jit_profiling_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT-compiled functions with perf profiler. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_profiling_support |
jit_tuple_deforming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of tuple deforming. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_tuple_deforming |
post_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Waits N seconds on connection startup after authentication. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | post_auth_delay |
pre_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Waits N seconds on connection startup before authentication. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | pre_auth_delay |
remove_temp_files_after_crash
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Remove temporary files after backend crash. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation |
trace_notify
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Generates debugging output for LISTEN and NOTIFY. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_notify |
trace_recovery_messages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Enables logging of recovery-related debugging information. |
| Data type | enumeration |
| Default value | log |
| Allowed values | log |
| Parameter type | read-only |
| Documentation | trace_recovery_messages |
trace_sort
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Emit information about resource usage in sorting. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_sort |
wal_consistency_checking
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the WAL resource managers for which WAL consistency checks are done. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | wal_consistency_checking |
zero_damaged_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing past damaged page headers. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | zero_damaged_pages |
allow_in_place_tablespaces
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows tablespaces directly inside pg_tblspc, for testing. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_in_place_tablespaces |
allow_system_table_mods
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows modifications of the structure of system tables. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_system_table_mods |
backtrace_functions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Log backtrace for errors in these functions. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | backtrace_functions |
force_parallel_mode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces use of parallel query facilities. |
| Data type | enumeration |
| Default value | off |
| Allowed values | off,on,regress |
| Parameter type | dynamic |
| Documentation | force_parallel_mode |
ignore_checksum_failure
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing after a checksum failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_checksum_failure |
ignore_invalid_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues recovery after an invalid pages failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_invalid_pages |
ignore_system_indexes
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Disables reading from system indexes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_system_indexes |
jit_debugging_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT compiled function with debugger. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_debugging_support |
jit_dump_bitcode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Write out LLVM bitcode to facilitate JIT debugging. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_dump_bitcode |
jit_expressions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of expressions. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_expressions |
jit_profiling_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT compiled function with perf profiler. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_profiling_support |
jit_tuple_deforming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of tuple deforming. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_tuple_deforming |
post_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Waits N seconds on connection startup after authentication. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | post_auth_delay |
pre_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Waits N seconds on connection startup before authentication. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | pre_auth_delay |
trace_notify
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Generates debugging output for LISTEN and NOTIFY. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_notify |
trace_recovery_messages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Enables logging of recovery-related debugging information. |
| Data type | enumeration |
| Default value | log |
| Allowed values | log |
| Parameter type | read-only |
| Documentation | trace_recovery_messages |
trace_sort
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Emit information about resource usage in sorting. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_sort |
wal_consistency_checking
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the WAL resource managers for which WAL consistency checks are done. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | wal_consistency_checking |
zero_damaged_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing past damaged page headers. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | zero_damaged_pages |
allow_in_place_tablespaces
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows tablespaces directly inside pg_tblspc, for testing. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_in_place_tablespaces |
allow_system_table_mods
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows modifications of the structure of system tables. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_system_table_mods |
force_parallel_mode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces use of parallel query facilities. |
| Data type | enumeration |
| Default value | off |
| Allowed values | off,on,regress |
| Parameter type | dynamic |
| Documentation | force_parallel_mode |
ignore_checksum_failure
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing after a checksum failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_checksum_failure |
ignore_system_indexes
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Disables reading from system indexes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_system_indexes |
jit_debugging_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT compiled function with debugger. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_debugging_support |
jit_dump_bitcode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Write out LLVM bitcode to facilitate JIT debugging. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_dump_bitcode |
jit_expressions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of expressions. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_expressions |
jit_profiling_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT compiled function with perf profiler. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_profiling_support |
jit_tuple_deforming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of tuple deforming. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_tuple_deforming |
post_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Waits N seconds on connection startup after authentication. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | post_auth_delay |
pre_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Waits N seconds on connection startup before authentication. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | pre_auth_delay |
trace_notify
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Generates debugging output for LISTEN and NOTIFY. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_notify |
trace_recovery_messages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Enables logging of recovery-related debugging information. |
| Data type | enumeration |
| Default value | log |
| Allowed values | log |
| Parameter type | read-only |
| Documentation | trace_recovery_messages |
trace_sort
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Emit information about resource usage in sorting. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_sort |
wal_consistency_checking
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the WAL resource managers for which WAL consistency checks are done. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | wal_consistency_checking |
zero_damaged_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing past damaged page headers. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | zero_damaged_pages |
allow_in_place_tablespaces
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows tablespaces directly inside pg_tblspc, for testing. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_in_place_tablespaces |
allow_system_table_mods
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allows modifications of the structure of system tables. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | allow_system_table_mods |
force_parallel_mode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Forces use of parallel query facilities. |
| Data type | enumeration |
| Default value | off |
| Allowed values | off,on,regress |
| Parameter type | dynamic |
| Documentation | force_parallel_mode |
ignore_checksum_failure
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing after a checksum failure. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_checksum_failure |
ignore_system_indexes
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Disables reading from system indexes. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | ignore_system_indexes |
jit_debugging_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT compiled function with debugger. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_debugging_support |
jit_dump_bitcode
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Write out LLVM bitcode to facilitate JIT debugging. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_dump_bitcode |
jit_expressions
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of expressions. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_expressions |
jit_profiling_support
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Register JIT compiled function with perf profiler. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | jit_profiling_support |
jit_tuple_deforming
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Allow JIT compilation of tuple deforming. |
| Data type | boolean |
| Default value | on |
| Allowed values | on |
| Parameter type | read-only |
| Documentation | jit_tuple_deforming |
post_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Waits N seconds on connection startup after authentication. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | post_auth_delay |
pre_auth_delay
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Waits N seconds on connection startup before authentication. |
| Data type | integer |
| Default value | 0 |
| Allowed values | 0 |
| Parameter type | read-only |
| Documentation | pre_auth_delay |
trace_notify
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Generates debugging output for LISTEN and NOTIFY. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_notify |
trace_recovery_messages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Enables logging of recovery-related debugging information. |
| Data type | enumeration |
| Default value | log |
| Allowed values | log |
| Parameter type | read-only |
| Documentation | trace_recovery_messages |
trace_sort
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Emit information about resource usage in sorting. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | trace_sort |
wal_consistency_checking
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Sets the WAL resource managers for which WAL consistency checks are done. |
| Data type | string |
| Default value | |
| Allowed values | |
| Parameter type | read-only |
| Documentation | wal_consistency_checking |
zero_damaged_pages
| Attribute | Value |
|---|---|
| Category | Developer Options |
| Description | Continues processing past damaged page headers. |
| Data type | boolean |
| Default value | off |
| Allowed values | off |
| Parameter type | read-only |
| Documentation | zero_damaged_pages |