postgres数据库配置文件详解

发布时间：2020-07-15 08:34:57 作者：鹏爱
来源：网络阅读：4001

allow_system_table_mods	Allows modifications of the structure of system tables.	允许修改系统表的结构。
application_name	Sets the application name to be reported in statistics and logs.	设置要在统计和日志中报告的应用程序名称。
archive_command	Sets the shell command that will be called to archive a WAL file.	设置将调用的命令来归档一个文件。
archive_mode	Allows archiving of WAL files using archive_command.	允许使用archive_command WAL文件归档。
archive_timeout	Forces a switch to the next xlog file if a new file has not been started within N seconds.	强制切换到下一个文件，如果一个新Xlog文件尚未在N秒开始。
array_nulls	Enable input of NULL elements in arrays.	启用数组中null元素的输入。
authentication_timeout	Sets the maximum allowed time to complete client authentication.	设置完成客户端身份验证的最大允许时间。
autovacuum	Starts the autovacuum subprocess.	开始autovacuum子。
autovacuum_analyze_scale_factor	Number of tuple inserts, updates, or deletes prior to analyze as a fraction of reltuples.	元组的插入、更新或删除数，分析作为reltuples分数之前。
autovacuum_analyze_threshold	Minimum number of tuple inserts, updates, or deletes prior to analyze.	在分析之前插入、更新或删除的最小元组数。
autovacuum_freeze_max_age	Age at which to autovacuum a table to prevent transaction ID wraparound.	年龄在autovacuum表以防止事务ID的概括。
autovacuum_max_workers	Sets the maximum number of simultaneously running autovacuum worker processes.	组同时运行autovacuum工人最大进程数。
autovacuum_naptime	Time to sleep between autovacuum runs.	睡觉的时间autovacuum之间运行。
autovacuum_vacuum_cost_delay	Vacuum cost delay in milliseconds, for autovacuum.	真空成本延迟毫秒，对于autovacuum。
autovacuum_vacuum_cost_limit	Vacuum cost amount available before napping, for autovacuum.	真空成本金额可用午睡前后，为autovacuum。
autovacuum_vacuum_scale_factor	Number of tuple updates or deletes prior to vacuum as a fraction of reltuples.	一些元组更新或删除reltuples真空作为一部分之前。
autovacuum_vacuum_threshold	Minimum number of tuple updates or deletes prior to vacuum.	在真空之前元组更新或删除的最小数目。
backslash_quote	Sets whether "\'" is allowed in string literals.	设置字符串文本中是否允许“\\”。
bgwriter_delay	Background writer sleep time between rounds.	背景作家轮间睡眠时间。
bgwriter_lru_maxpages	Background writer maximum number of LRU pages to flush per round.	背景的作家最大数量的LRU页面刷新每轮。
bgwriter_lru_multiplier	Multiple of the average buffer usage to free per round.	平均缓冲区使用量的倍数为每轮免费。
block_size	Shows the size of a disk block.	显示磁盘块的大小。
bonjour	Enables advertising the server via Bonjour.	使广告服务器通过卓悦。
bonjour_name	Sets the Bonjour service name.	集的Bonjour服务名称。
bytea_output	Sets the output format for bytea.	集bytea输出格式。
check_function_bodies	Check function bodies during CREATE FUNCTION.	在创建函数期间检查函数体。
checkpoint_completion_target	Time spent flushing dirty buffers during checkpoint, as fraction of checkpoint interval.	在检查点中清除脏缓冲区的时间，作为检查点间隔的一部分。
checkpoint_segments	Sets the maximum distance in log segments between automatic WAL checkpoints.	设置自动检查点之间的日志段的最大距离。
checkpoint_timeout	Sets the maximum time between automatic WAL checkpoints.	设置自动检查点之间的最大时间。
checkpoint_warning	Enables warnings if checkpoint segments are filled more frequently than this.	如果检查点段填充比此更频繁，则启用警告。
client_encoding	Sets the client's character set encoding.	设置客户端的字符集编码。
client_min_messages	Sets the message levels that are sent to the client.	设置发送给客户机的消息级别。
commit_delay	Sets the delay in microseconds between transaction commit and flushing WAL to disk.	在事务提交和刷新到磁盘之间设置延迟微秒。
commit_siblings	Sets the minimum concurrent open transactions before performing commit_delay.	设置最小并发公开交易前执行commit_delay。
config_file	Sets the server's main configuration file.	设置服务器的主配置文件。
constraint_exclusion	Enables the planner to use constraints to optimize queries.	使规划人员能够使用约束来优化查询。
cpu_index_tuple_cost	Sets the planner's estimate of the cost of processing each index entry during an index scan.	在索引扫描期间设置计划者对处理每个索引项的成本的估计值。
cpu_operator_cost	Sets the planner's estimate of the cost of processing each operator or function call.	设置计划者对每个操作员或函数调用处理成本的估计值。
cpu_tuple_cost	Sets the planner's estimate of the cost of processing each tuple (row).	设置计划程序处理每个元组（行）的成本的估计值。
cursor_tuple_fraction	Sets the planner's estimate of the fraction of a cursor's rows that will be retrieved.	设置要检索的游标行的小数部分的计划者的估计值。
data_directory	Sets the server's data directory.	设置服务器的数据目录。
DateStyle	Sets the display format for date and time values.	设置日期和时间值的显示格式。
db_user_namespace	Enables per-database user names.	启用每个数据库用户名。
deadlock_timeout	Sets the time to wait on a lock before checking for deadlock.	在检查死锁之前设置等待锁的时间。
debug_assertions	Turns on various assertion checks.	打开各种断言检查。
debug_pretty_print	Indents parse and plan tree displays.	缩进的解析和计划树显示。
debug_print_parse	Logs each query's parse tree.	记录每个查询的解析树。
debug_print_plan	Logs each query's execution plan.	记录每个查询的执行计划。
debug_print_rewritten	Logs each query's rewritten parse tree.	记录每个查询重写的解析树。
default_statistics_target	Sets the default statistics target.	设置默认统计目标。
default_tablespace	Sets the default tablespace to create tables and indexes in.	设置默认表空间以创建表和索引。
default_text_search_config	Sets default text search configuration.	设置默认文本搜索配置。
default_transaction_deferrable	Sets the default deferrable status of new transactions.	套新事务的默认延迟状态。
default_transaction_isolation	Sets the transaction isolation level of each new transaction.	设置每个新事务的事务隔离级别。
default_transaction_read_only	Sets the default read-only status of new transactions.	设置新事务的默认只读状态。
default_with_oids	Create new tables with OIDs by default.	创建新表时默认。
dynamic_library_path	Sets the path for dynamically loadable modules.	设置动态可加载模块的路径。
effective_cache_size	Sets the planner's assumption about the size of the disk cache.	设置规划程序关于磁盘缓存大小的假设。
effective_io_concurrency	Number of simultaneous requests that can be handled efficiently by the disk subsystem.	磁盘子系统可以高效处理的同时请求数。
enable_bitmapscan	Enables the planner's use of bitmap-scan plans.	使规划人员使用位图扫描计划。
enable_hashagg	Enables the planner's use of hashed aggregation plans.	使计划使用哈希聚合计划。
enable_hashjoin	Enables the planner's use of hash join plans.	使计划人员使用哈希连接计划。
enable_indexonlyscan	Enables the planner's use of index-only-scan plans.	使规划人员只使用索引扫描计划。
enable_indexscan	Enables the planner's use of index-scan plans.	允许计划人员使用索引扫描计划。
enable_material	Enables the planner's use of materialization.	允许策划者使用物化。
enable_mergejoin	Enables the planner's use of merge join plans.	使计划人员使用合并联接计划。
enable_nestloop	Enables the planner's use of nested-loop join plans.	使策划者能够使用嵌套循环连接计划。
enable_seqscan	Enables the planner's use of sequential-scan plans.	使规划人员使用顺序扫描计划。
enable_sort	Enables the planner's use of explicit sort steps.	使规划人员使用显式排序步骤。
enable_tidscan	Enables the planner's use of TID scan plans.	使计划使用TID扫描计划。
escape_string_warning	Warn about backslash escapes in ordinary string literals.	警告在普通字符串中的反斜杠。
event_source	Sets the application name used to identify PostgreSQL messages in the event log.	设置用于确定在事件日志消息的应用程序名称PostgreSQL。
exit_on_error	Terminate session on any error.	终止任何错误的会话。
external_pid_file	Writes the postmaster PID to the specified file.	将邮政局长PID写入指定的文件。
extra_float_digits	Sets the number of digits displayed for floating-point values.	设置显示浮点值的位数。
from_collapse_limit	Sets the FROM-list size beyond which subqueries are not collapsed.	设置从列表的大小超过该子查询不倒塌。
fsync	Forces synchronization of updates to disk.	强制更新到磁盘的同步。
full_page_writes	Writes full pages to WAL when first modified after a checkpoint.	在检查点第一次修改后写入完整的页面。
geqo	Enables genetic query optimization.	启用遗传查询优化。
geqo_effort	GEQO: effort is used to set the default for other GEQO parameters.	geqo：努力是用来为其他geqo参数设置默认。
geqo_generations	GEQO: number of iterations of the algorithm.	geqo：算法的迭代次数。
geqo_pool_size	GEQO: number of individuals in the population.	geqo：群体中的个体数。
geqo_seed	GEQO: seed for random path selection.	geqo：种子随机路径选择。
geqo_selection_bias	GEQO: selective pressure within the population.	geqo：在人口压力。
geqo_threshold	Sets the threshold of FROM items beyond which GEQO is used.	设置阈值的物品之外，geqo使用。
gin_fuzzy_search_limit	Sets the maximum allowed result for exact search by GIN.	设置杜松子酒精确搜索的最大允许结果。
hba_file	Sets the server's "hba" configuration file.	设置服务器的HBA配置文件。
hot_standby	Allows connections and queries during recovery.	允许恢复期间的连接和查询。
hot_standby_feedback	Allows feedback from a hot standby to the primary that will avoid query conflicts.	允许来自热备份的反馈到主，避免查询冲突。
ident_file	Sets the server's "ident" configuration file.	设置服务器的“识别”配置文件。
ignore_system_indexes	Disables reading from system indexes.	禁用系统索引读取。
integer_datetimes	Datetimes are integer based.	日期是基于整数。
IntervalStyle	Sets the display format for interval values.	设置区间值的显示格式。
join_collapse_limit	Sets the FROM-list size beyond which JOIN constructs are not flattened.	设置从列表大小超出连接结构不被压扁。
krb_caseins_users	Sets whether Kerberos and GSSAPI user names should be treated as case-insensitive.	设置是否和Kerberos GSSAPI用户名应该是不区分大小写。
krb_server_keyfile	Sets the location of the Kerberos server key file.	设置Kerberos服务器密钥文件的位置。
krb_srvname	Sets the name of the Kerberos service.	设置Kerberos服务的名称。
lc_collate	Shows the collation order locale.	显示排序规则区域设置。
lc_ctype	Shows the character classification and case conversion locale.	显示字符分类和案例转换区域设置。
lc_messages	Sets the language in which messages are displayed.	设置显示消息的语言。
lc_monetary	Sets the locale for formatting monetary amounts.	设置格式化货币金额的区域设置。
lc_numeric	Sets the locale for formatting numbers.	设置格式化数字的区域设置。
lc_time	Sets the locale for formatting date and time values.	设置格式化日期和时间值的区域设置。
listen_addresses	Sets the host name or IP address(es) to listen to.	设置主机名或IP地址（ES）以监听。
lo_compat_privileges	Enables backward compatibility mode for privilege checks on large objects.	允许对大型对象进行特权检查的向后兼容性模式。
local_preload_libraries	Lists shared libraries to preload into each backend.	列出预加载到每个后端的共享库。
log_autovacuum_min_duration	Sets the minimum execution time above which autovacuum actions will be logged.	集的最小执行时间上autovacuum行为将被记录。
log_checkpoints	Logs each checkpoint.	记录每个检查点。
log_connections	Logs each successful connection.	记录每个成功连接。
log_destination	Sets the destination for server log output.	设置服务器日志输出的目的地。
log_directory	Sets the destination directory for log files.	设置日志文件的目标目录。
log_disconnections	Logs end of a session, including duration.	记录会话结束，包括持续时间。
log_duration	Logs the duration of each completed SQL statement.	记录每个已完成SQL语句的持续时间。
log_error_verbosity	Sets the verbosity of logged messages.	设置日志信息的冗长。
log_executor_stats	Writes executor performance statistics to the server log.	将执行器性能统计信息写入服务器日志。
log_file_mode	Sets the file permissions for log files.	设置日志文件的文件权限。
log_filename	Sets the file name pattern for log files.	设置日志文件的文件名模式。
log_hostname	Logs the host name in the connection logs.	在连接日志中记录主机名。
log_line_prefix	Controls information prefixed to each log line.	控制信息到每个日志行前缀。
log_lock_waits	Logs long lock waits.	记录长锁等待。
log_min_duration_statement	Sets the minimum execution time above which statements will be logged.	设置将记录哪些语句的最低执行时间。
log_min_error_statement	Causes all statements generating error at or above this level to be logged.	使所有语句在该级别之上或高于该级别生成错误。
log_min_messages	Sets the message levels that are logged.	设置记录的消息级别。
log_parser_stats	Writes parser performance statistics to the server log.	将分析器性能统计信息写入服务器日志。
log_planner_stats	Writes planner performance statistics to the server log.	将计划性能统计信息写入服务器日志。
log_rotation_age	Automatic log file rotation will occur after N minutes.	自动日志文件轮换将在N分钟后发生。
log_rotation_size	Automatic log file rotation will occur after N kilobytes.	日志文件自动旋转后会发生N字节。
log_statement	Sets the type of statements logged.	设置记录的语句的类型。
log_statement_stats	Writes cumulative performance statistics to the server log.	将累积性能统计信息写入服务器日志。
log_temp_files	Log the use of temporary files larger than this number of kilobytes.	日志使用临时文件大于千字节数。
log_timezone	Sets the time zone to use in log messages.	设置要在日志消息中使用的时区。
log_truncate_on_rotation	Truncate existing log files of same name during log rotation.	在日志旋转期间截断现有的同名日志文件。
logging_collector	Start a subprocess to capture stderr output and/or csvlogs into log files.	启动子捕获stderr输出和/或csvlogs写入日志文件。
maintenance_work_mem	Sets the maximum memory to be used for maintenance operations.	设置用于维护操作的最大内存。
max_connections	Sets the maximum number of concurrent connections.	设置并发连接的最大数量。
max_files_per_process	Sets the maximum number of simultaneously open files for each server process.	为每个服务器进程设置同时打开文件的最大数量。
max_function_args	Shows the maximum number of function arguments.	显示函数参数的最大数目。
max_identifier_length	Shows the maximum identifier length.	显示最大标识符长度。
max_index_keys	Shows the maximum number of index keys.	显示索引键的最大数目。
max_locks_per_transaction	Sets the maximum number of locks per transaction.	设置每个事务的最大锁数。
max_pred_locks_per_transaction	Sets the maximum number of predicate locks per transaction.	设置每个事务的最大谓词锁数。
max_prepared_transactions	Sets the maximum number of simultaneously prepared transactions.	设置同时准备的事务的最大数目。
max_stack_depth	Sets the maximum stack depth, in kilobytes.	设置最大堆栈深度，以千字节为单位。
max_standby_archive_delay	Sets the maximum delay before canceling queries when a hot standby server is processing archived WAL data.	设置热备份服务器正在处理归档的数据时取消查询之前的最大延迟。
max_standby_streaming_delay	Sets the maximum delay before canceling queries when a hot standby server is processing streamed WAL data.	设置热备份服务器处理流式数据时，取消查询之前的最大延迟。
max_wal_senders	Sets the maximum number of simultaneously running WAL sender processes.	设置同时运行的发送进程的最大数目。
password_encryption	Encrypt passwords.	加密的密码。
pg_stat_statements.max	Sets the maximum number of statements tracked by pg_stat_statements.	设置跟踪pg_stat_statements语句的最大数量。
pg_stat_statements.save	Save pg_stat_statements statistics across server shutdowns.	保存在服务器停机pg_stat_statements统计。
pg_stat_statements.track	Selects which statements are tracked by pg_stat_statements.	选择哪个陈述是被pg_stat_statements。
pg_stat_statements.track_utility	Selects whether utility commands are tracked by pg_stat_statements.	选择是否实用程序命令跟踪的pg_stat_statements。
port	Sets the TCP port the server listens on.	设置服务器侦听的TCP端口。
post_auth_delay	Waits N seconds on connection startup after authentication.	在验证后连接启动时等待秒。
pre_auth_delay	Waits N seconds on connection startup before authentication.	在身份验证之前，在连接启动时等待秒。
quote_all_identifiers	When generating SQL fragments, quote all identifiers.	在生成SQL片段时，引用所有标识符。
random_page_cost	Sets the planner's estimate of the cost of a nonsequentially fetched disk page.	设置一个进行非连续读取的磁盘页的成本计划的估计。
replication_timeout	Sets the maximum time to wait for WAL replication.	设置等待复制的最大时间。
restart_after_crash	Reinitialize server after backend crash.	初始化服务器后端碰撞后。
search_path	Sets the schema search order for names that are not schema-qualified.	为不符合模式的名称设置模式搜索顺序。
segment_size	Shows the number of pages per disk file.	显示每个磁盘文件的页数。
seq_page_cost	Sets the planner's estimate of the cost of a sequentially fetched disk page.	设置计划程序对顺序获取的磁盘页的成本估计值。
server_encoding	Sets the server (database) character set encoding.	设置服务器（数据库）字符集编码。
server_version	Shows the server version.	显示服务器版本。
server_version_num	Shows the server version as an integer.	将服务器版本显示为整数。
session_replication_role	Sets the session's behavior for triggers and rewrite rules.	设置会话的触发器和重写规则的行为。
shared_buffers	Sets the number of shared memory buffers used by the server.	设置服务器使用的共享内存缓冲区的数目。
shared_preload_libraries	Lists shared libraries to preload into server.	列出共享库以预加载到服务器。
sql_inheritance	Causes subtables to be included by default in various commands.	原因子被默认包含各种命令。
ssl	Enables SSL connections.	启用SSL连接。
ssl_ca_file	Location of the SSL certificate authority file.	SSL证书颁发机构文件的位置。
ssl_cert_file	Location of the SSL server certificate file.	SSL服务器证书文件的位置。
ssl_ciphers	Sets the list of allowed SSL ciphers.	设置允许的SSL密码列表。
ssl_crl_file	Location of the SSL certificate revocation list file.	SSL证书吊销列表文件的位置。
ssl_key_file	Location of the SSL server private key file.	SSL服务器私钥文件的位置。
ssl_renegotiation_limit	Set the amount of traffic to send and receive before renegotiating the encryption keys.	将流量发送和接收之前重新加密密钥。
standard_conforming_strings	Causes '...' strings to treat backslashes literally.	原因'…'字符串处理的反斜杠，字面上的意思。
statement_timeout	Sets the maximum allowed duration of any statement.	设置任何语句的最大允许持续时间。
stats_temp_directory	Writes temporary statistics files to the specified directory.	将临时统计文件写入指定目录。
superuser_reserved_connections	Sets the number of connection slots reserved for superusers.	套连接插槽保留对超级用户的数量。
synchronize_seqscans	Enable synchronized sequential scans.	启用同步顺序扫描。
synchronous_commit	Sets the current transaction's synchronization level.	设置当前事务的同步级别。
synchronous_standby_names	List of names of potential synchronous standbys.	对潜在同步备用名称列表。
syslog_facility	Sets the syslog "facility" to be used when syslog enabled.	设置日志“设施”时要使用系统日志功能。
syslog_ident	Sets the program name used to identify PostgreSQL messages in syslog.	设置用于确定消息syslog PostgreSQL程序名称。
tcp_keepalives_count	Maximum number of TCP keepalive retransmits.	TCP的KeepAlive最大数量的转发。
tcp_keepalives_idle	Time between issuing TCP keepalives.	发行TCP保持信号之间的时间。
tcp_keepalives_interval	Time between TCP keepalive retransmits.	发生时间之间的TCP重发。
temp_buffers	Sets the maximum number of temporary buffers used by each session.	设置每个会话所使用的临时缓冲区的最大数目。
temp_file_limit	Limits the total size of all temporary files used by each session.	限制每个会话使用的所有临时文件的总大小。
temp_tablespaces	Sets the tablespace(s) to use for temporary tables and sort files.	设置用于临时表和排序文件的表空间（s）。
TimeZone	Sets the time zone for displaying and interpreting time stamps.	设置显示和解释时间戳的时区。
timezone_abbreviations	Selects a file of time zone abbreviations.	选择时区缩写的文件。
trace_notify	Generates debugging output for LISTEN and NOTIFY.	生成监听和通知的调试输出。
trace_recovery_messages	Enables logging of recovery-related debugging information.	启用与恢复相关的调试信息的日志记录。
trace_sort	Emit information about resource usage in sorting.	在排序时发出有关资源使用的信息。
track_activities	Collects information about executing commands.	收集有关执行命令的信息。
track_activity_query_size	Sets the size reserved for pg_stat_activity.query, in bytes.	设置预留pg_stat_activity.query的大小，以字节为单位。
track_counts	Collects statistics on database activity.	收集数据库活动的统计信息。
track_functions	Collects function-level statistics on database activity.	收集数据库活动的功能级别统计信息。
track_io_timing	Collects timing statistics for database I/O activity.	收集数据库I/O活动的定时统计信息。
transaction_deferrable	Whether to defer a read-only serializable transaction until it can be executed with no possible serialization failures.	是否推迟一个只读事务直到它可以执行任何可能的序列化失败。
transaction_isolation	Sets the current transaction's isolation level.	设置当前事务的隔离级别。
transaction_read_only	Sets the current transaction's read-only status.	设置当前事务的只读状态。
transform_null_equals	Treats "expr=NULL" as "expr IS NULL".	对待“expr = null”为“表达式为空”。
unix_socket_directory	Sets the directory where the Unix-domain socket will be created.	设置将创建UNIX域套接字的目录。
unix_socket_group	Sets the owning group of the Unix-domain socket.	设置UNIX域套接字的拥有组。
unix_socket_permissions	Sets the access permissions of the Unix-domain socket.	设置UNIX域套接字的访问权限。
update_process_title	Updates the process title to show the active SQL command.	更新进程标题以显示活动SQL命令。
vacuum_cost_delay	Vacuum cost delay in milliseconds.	真空成本延迟毫秒。
vacuum_cost_limit	Vacuum cost amount available before napping.	午睡前可用的真空成本。
vacuum_cost_page_dirty	Vacuum cost for a page dirtied by vacuum.	一个页面被真空成本。
vacuum_cost_page_hit	Vacuum cost for a page found in the buffer cache.	在缓冲区缓存中找到的页的真空成本。
vacuum_cost_page_miss	Vacuum cost for a page not found in the buffer cache.	在缓冲区缓存中未找到的页的真空成本。
vacuum_defer_cleanup_age	Number of transactions by which VACUUM and HOT cleanup should be deferred, if any.	如果有任何真空和热清洗应推迟的交易数量。
vacuum_freeze_min_age	Minimum age at which VACUUM should freeze a table row.	真空度应冻结表列的最小年龄。
vacuum_freeze_table_age	Age at which VACUUM should scan whole table to freeze tuples.	真空扫描整个表冻结元组的年龄。
wal_block_size	Shows the block size in the write ahead log.	显示写前日志中的块大小。
wal_buffers	Sets the number of disk-page buffers in shared memory for WAL.	为共享内存设置磁盘页缓冲区的数目。
wal_keep_segments	Sets the number of WAL files held for standby servers.	设置为备用服务器保存的沃尔玛文件的数量。
wal_level	Set the level of information written to the WAL.	将写入到沃尔玛的信息级别设置为。
wal_receiver_status_interval	Sets the maximum interval between WAL receiver status reports to the primary.	将接收器状态报告之间的最大间隔设置为主。
wal_segment_size	Shows the number of pages per write ahead log segment.	显示每个写前日志段的页数。
wal_sync_method	Selects the method used for forcing WAL updates to disk.	选择用于强制将更新更新到磁盘的方法。
wal_writer_delay	WAL writer sleep time between WAL flushes.	沃尔玛作家睡眠时间之间的沃尔玛刷新。
work_mem	Sets the maximum memory to be used for query workspaces.	设置用于查询工作区的最大内存。
xmlbinary	Sets how binary values are to be encoded in XML.	设置二进制值是如何用XML编码的。
xmloption	Sets whether XML data in implicit parsing and serialization operations is to be considered as documents or content fragments.	设置隐式解析和序列化操作中的XML数据是否被视为文档或内容片段。
zero_damaged_pages	Continues processing past damaged page headers.	继续处理过去损坏的页眉。

postgres数据库配置文件详解

相关阅读