Server IP : 103.119.228.120 / Your IP : 18.219.47.239 Web Server : Apache System : Linux v8.techscape8.com 3.10.0-1160.119.1.el7.tuxcare.els2.x86_64 #1 SMP Mon Jul 15 12:09:18 UTC 2024 x86_64 User : nobody ( 99) PHP Version : 5.6.40 Disable Function : shell_exec,symlink,system,exec,proc_get_status,proc_nice,proc_terminate,define_syslog_variables,syslog,openlog,closelog,escapeshellcmd,passthru,ocinum cols,ini_alter,leak,listen,chgrp,apache_note,apache_setenv,debugger_on,debugger_off,ftp_exec,dl,dll,myshellexec,proc_open,socket_bind,proc_close,escapeshellarg,parse_ini_filepopen,fpassthru,exec,passthru,escapeshellarg,escapeshellcmd,proc_close,proc_open,ini_alter,popen,show_source,proc_nice,proc_terminate,proc_get_status,proc_close,pfsockopen,leak,apache_child_terminate,posix_kill,posix_mkfifo,posix_setpgid,posix_setsid,posix_setuid,dl,symlink,shell_exec,system,dl,passthru,escapeshellarg,escapeshellcmd,myshellexec,c99_buff_prepare,c99_sess_put,fpassthru,getdisfunc,fx29exec,fx29exec2,is_windows,disp_freespace,fx29sh_getupdate,fx29_buff_prepare,fx29_sess_put,fx29shexit,fx29fsearch,fx29ftpbrutecheck,fx29sh_tools,fx29sh_about,milw0rm,imagez,sh_name,myshellexec,checkproxyhost,dosyayicek,c99_buff_prepare,c99_sess_put,c99getsource,c99sh_getupdate,c99fsearch,c99shexit,view_perms,posix_getpwuid,posix_getgrgid,posix_kill,parse_perms,parsesort,view_perms_color,set_encoder_input,ls_setcheckboxall,ls_reverse_all,rsg_read,rsg_glob,selfURL,dispsecinfo,unix2DosTime,addFile,system,get_users,view_size,DirFiles,DirFilesWide,DirPrintHTMLHeaders,GetFilesTotal,GetTitles,GetTimeTotal,GetMatchesCount,GetFileMatchesCount,GetResultFiles,fs_copy_dir,fs_copy_obj,fs_move_dir,fs_move_obj,fs_rmdir,SearchText,getmicrotime MySQL : ON | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /usr/share/doc/postgresql-9.2.24/html/ |
Upload File : |
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >Server Configuration</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REV="MADE" HREF="mailto:pgsql-docs@postgresql.org"><LINK REL="HOME" TITLE="PostgreSQL 9.2.24 Documentation" HREF="index.html"><LINK REL="UP" TITLE="Server Administration" HREF="admin.html"><LINK REL="PREVIOUS" TITLE="Registering Event Log on Windows" HREF="event-log-registration.html"><LINK REL="NEXT" TITLE="Setting Parameters" HREF="config-setting.html"><LINK REL="STYLESHEET" TYPE="text/css" HREF="stylesheet.css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1"><META NAME="creation" CONTENT="2017-11-06T22:43:11"></HEAD ><BODY CLASS="CHAPTER" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="5" ALIGN="center" VALIGN="bottom" ><A HREF="index.html" >PostgreSQL 9.2.24 Documentation</A ></TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A TITLE="Registering Event Log on Windows" HREF="event-log-registration.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="10%" ALIGN="left" VALIGN="top" ><A HREF="admin.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="60%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="20%" ALIGN="right" VALIGN="top" ><A TITLE="Setting Parameters" HREF="config-setting.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="CHAPTER" ><H1 ><A NAME="RUNTIME-CONFIG" ></A >Chapter 18. Server Configuration</H1 ><DIV CLASS="TOC" ><DL ><DT ><B >Table of Contents</B ></DT ><DT >18.1. <A HREF="config-setting.html" >Setting Parameters</A ></DT ><DD ><DL ><DT >18.1.1. <A HREF="config-setting.html#CONFIG-SETTING-NAMES-VALUES" >Parameter Names and Values</A ></DT ><DT >18.1.2. <A HREF="config-setting.html#CONFIG-SETTING-CONFIGURATION-FILE" >Setting Parameters via the Configuration File</A ></DT ><DT >18.1.3. <A HREF="config-setting.html#CONFIG-SETTING-OTHER-METHODS" >Other Ways to Set Parameters</A ></DT ><DT >18.1.4. <A HREF="config-setting.html#CONFIG-SETTING-EXAMINING" >Examining Parameter Settings</A ></DT ></DL ></DD ><DT >18.2. <A HREF="runtime-config-file-locations.html" >File Locations</A ></DT ><DT >18.3. <A HREF="runtime-config-connection.html" >Connections and Authentication</A ></DT ><DD ><DL ><DT >18.3.1. <A HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS" >Connection Settings</A ></DT ><DT >18.3.2. <A HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SECURITY" >Security and Authentication</A ></DT ></DL ></DD ><DT >18.4. <A HREF="runtime-config-resource.html" >Resource Consumption</A ></DT ><DD ><DL ><DT >18.4.1. <A HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY" >Memory</A ></DT ><DT >18.4.2. <A HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-DISK" >Disk</A ></DT ><DT >18.4.3. <A HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-KERNEL" >Kernel Resource Usage</A ></DT ><DT >18.4.4. <A HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST" >Cost-based Vacuum Delay</A ></DT ><DT >18.4.5. <A HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER" >Background Writer</A ></DT ><DT >18.4.6. <A HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-ASYNC-BEHAVIOR" >Asynchronous Behavior</A ></DT ></DL ></DD ><DT >18.5. <A HREF="runtime-config-wal.html" >Write Ahead Log</A ></DT ><DD ><DL ><DT >18.5.1. <A HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-SETTINGS" >Settings</A ></DT ><DT >18.5.2. <A HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-CHECKPOINTS" >Checkpoints</A ></DT ><DT >18.5.3. <A HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING" >Archiving</A ></DT ></DL ></DD ><DT >18.6. <A HREF="runtime-config-replication.html" >Replication</A ></DT ><DD ><DL ><DT >18.6.1. <A HREF="runtime-config-replication.html#RUNTIME-CONFIG-REPLICATION-SENDER" >Sending Server(s)</A ></DT ><DT >18.6.2. <A HREF="runtime-config-replication.html#RUNTIME-CONFIG-REPLICATION-MASTER" >Master Server</A ></DT ><DT >18.6.3. <A HREF="runtime-config-replication.html#RUNTIME-CONFIG-REPLICATION-STANDBY" >Standby Servers</A ></DT ></DL ></DD ><DT >18.7. <A HREF="runtime-config-query.html" >Query Planning</A ></DT ><DD ><DL ><DT >18.7.1. <A HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE" >Planner Method Configuration</A ></DT ><DT >18.7.2. <A HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-CONSTANTS" >Planner Cost Constants</A ></DT ><DT >18.7.3. <A HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-GEQO" >Genetic Query Optimizer</A ></DT ><DT >18.7.4. <A HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-OTHER" >Other Planner Options</A ></DT ></DL ></DD ><DT >18.8. <A HREF="runtime-config-logging.html" >Error Reporting and Logging</A ></DT ><DD ><DL ><DT >18.8.1. <A HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE" >Where To Log</A ></DT ><DT >18.8.2. <A HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN" >When To Log</A ></DT ><DT >18.8.3. <A HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT" >What To Log</A ></DT ><DT >18.8.4. <A HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG" >Using CSV-Format Log Output</A ></DT ></DL ></DD ><DT >18.9. <A HREF="runtime-config-statistics.html" >Run-time Statistics</A ></DT ><DD ><DL ><DT >18.9.1. <A HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR" >Query and Index Statistics Collector</A ></DT ><DT >18.9.2. <A HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-MONITOR" >Statistics Monitoring</A ></DT ></DL ></DD ><DT >18.10. <A HREF="runtime-config-autovacuum.html" >Automatic Vacuuming</A ></DT ><DT >18.11. <A HREF="runtime-config-client.html" >Client Connection Defaults</A ></DT ><DD ><DL ><DT >18.11.1. <A HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT" >Statement Behavior</A ></DT ><DT >18.11.2. <A HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT" >Locale and Formatting</A ></DT ><DT >18.11.3. <A HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-OTHER" >Other Defaults</A ></DT ></DL ></DD ><DT >18.12. <A HREF="runtime-config-locks.html" >Lock Management</A ></DT ><DT >18.13. <A HREF="runtime-config-compatible.html" >Version and Platform Compatibility</A ></DT ><DD ><DL ><DT >18.13.1. <A HREF="runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION" >Previous PostgreSQL Versions</A ></DT ><DT >18.13.2. <A HREF="runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-CLIENTS" >Platform and Client Compatibility</A ></DT ></DL ></DD ><DT >18.14. <A HREF="runtime-config-error-handling.html" >Error Handling</A ></DT ><DT >18.15. <A HREF="runtime-config-preset.html" >Preset Options</A ></DT ><DT >18.16. <A HREF="runtime-config-custom.html" >Customized Options</A ></DT ><DT >18.17. <A HREF="runtime-config-developer.html" >Developer Options</A ></DT ><DT >18.18. <A HREF="runtime-config-short.html" >Short Options</A ></DT ></DL ></DIV ><P > There are many configuration parameters that affect the behavior of the database system. In the first section of this chapter, we describe how to set configuration parameters. The subsequent sections discuss each parameter in detail. </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="event-log-registration.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="config-setting.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Registering <SPAN CLASS="APPLICATION" >Event Log</SPAN > on <SPAN CLASS="SYSTEMITEM" >Windows</SPAN ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="admin.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Setting Parameters</TD ></TR ></TABLE ></DIV ></BODY ></HTML >