Sophie: postgresql9.4-docs-9.4.24-1.mga6 noarch

postgresql9.4-docs-9.4.24-1.mga6.noarch.rpm

<!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.4.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="2019-08-11T16:12:25"></HEAD
><BODY
CLASS="CHAPTER"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="4"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.4.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"
>Parameter Interaction via the Configuration File</A
></DT
><DT
>18.1.3. <A
HREF="config-setting.html#CONFIG-SETTING-SQL-COMMAND-INTERACTION"
>Parameter Interaction via SQL</A
></DT
><DT
>18.1.4. <A
HREF="config-setting.html#AEN29980"
>Parameter Interaction via the Shell</A
></DT
><DT
>18.1.5. <A
HREF="config-setting.html#CONFIG-INCLUDES"
>Managing Configuration File Contents</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-PRELOAD"
>Shared Library Preloading</A
></DT
><DT
>18.11.4. <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 interact with 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
>