Index: doc/src/sgml/charset.sgml =================================================================== RCS file: /cvsroot/pgsql-server/doc/src/sgml/charset.sgml,v retrieving revision 2.38 diff -c -c -r2.38 charset.sgml *** doc/src/sgml/charset.sgml 31 Aug 2003 17:32:18 -0000 2.38 --- doc/src/sgml/charset.sgml 11 Sep 2003 18:22:52 -0000 *************** *** 769,775 **** ! Using SET CLIENT_ENCODING TO. Setting the client encoding can be done with this SQL command: --- 769,775 ---- ! Using SET client_encoding TO. Setting the client encoding can be done with this SQL command: *************** *** 786,798 **** To query the current client encoding: ! SHOW CLIENT_ENCODING; To return to the default encoding: ! RESET CLIENT_ENCODING; --- 786,798 ---- To query the current client encoding: ! SHOW client_encoding; To return to the default encoding: ! RESET client_encoding; Index: doc/src/sgml/func.sgml =================================================================== RCS file: /cvsroot/pgsql-server/doc/src/sgml/func.sgml,v retrieving revision 1.171 diff -c -c -r1.171 func.sgml *** doc/src/sgml/func.sgml 11 Sep 2003 17:26:20 -0000 1.171 --- doc/src/sgml/func.sgml 11 Sep 2003 18:23:00 -0000 *************** *** 3435,3441 **** Normally the flavor of RE being used is determined by ! REGEX_FLAVOR. However, this can be overridden by a director prefix. If an RE of any flavor begins with ***:, the rest of the RE is taken as an ARE. --- 3435,3441 ---- Normally the flavor of RE being used is determined by ! regex_flavor. However, this can be overridden by a director prefix. If an RE of any flavor begins with ***:, the rest of the RE is taken as an ARE. *************** *** 3762,3768 **** While these differences are unlikely to create a problem for most applications, you can avoid them if necessary by ! setting REGEX_FLAVOR to extended. --- 3762,3768 ---- While these differences are unlikely to create a problem for most applications, you can avoid them if necessary by ! setting regex_flavor to extended. Index: doc/src/sgml/perform.sgml =================================================================== RCS file: /cvsroot/pgsql-server/doc/src/sgml/perform.sgml,v retrieving revision 1.32 diff -c -c -r1.32 perform.sgml *** doc/src/sgml/perform.sgml 11 Sep 2003 17:31:45 -0000 1.32 --- doc/src/sgml/perform.sgml 11 Sep 2003 18:23:02 -0000 *************** *** 603,609 **** PostgreSQL planner will switch from exhaustive search to a genetic probabilistic search through a limited number of possibilities. (The switch-over threshold is ! set by the GEQO_THRESHOLD run-time parameter.) The genetic search takes less time, but it won't necessarily find the best possible plan. --- 603,609 ---- PostgreSQL planner will switch from exhaustive search to a genetic probabilistic search through a limited number of possibilities. (The switch-over threshold is ! set by the geqo_threshold run-time parameter.) The genetic search takes less time, but it won't necessarily find the best possible plan. Index: doc/src/sgml/plpgsql.sgml =================================================================== RCS file: /cvsroot/pgsql-server/doc/src/sgml/plpgsql.sgml,v retrieving revision 1.23 diff -c -c -r1.23 plpgsql.sgml *** doc/src/sgml/plpgsql.sgml 11 Sep 2003 17:31:45 -0000 1.23 --- doc/src/sgml/plpgsql.sgml 11 Sep 2003 18:23:07 -0000 *************** *** 1350,1356 **** allow users to allow users to define set-returning functions that do not have this limitation. Currently, the point at which data begins being written to disk is controlled by the ! SORT_MEM configuration variable. Administrators who have sufficient memory to store larger result sets in memory should consider increasing this parameter. --- 1350,1356 ---- allow users to allow users to define set-returning functions that do not have this limitation. Currently, the point at which data begins being written to disk is controlled by the ! sort_mem configuration variable. Administrators who have sufficient memory to store larger result sets in memory should consider increasing this parameter. Index: doc/src/sgml/runtime.sgml =================================================================== RCS file: /cvsroot/pgsql-server/doc/src/sgml/runtime.sgml,v retrieving revision 1.205 diff -c -c -r1.205 runtime.sgml *** doc/src/sgml/runtime.sgml 11 Sep 2003 17:27:38 -0000 1.205 --- doc/src/sgml/runtime.sgml 11 Sep 2003 18:23:12 -0000 *************** *** 630,636 **** ! TCPIP_SOCKET (boolean) If this is true, then the server will accept TCP/IP connections.TCP/IP --- 630,636 ---- ! tcpip_socket (boolean) If this is true, then the server will accept TCP/IP connections.TCP/IP *************** *** 642,648 **** ! MAX_CONNECTIONS (integer) Determines the maximum number of concurrent connections to the --- 642,648 ---- ! max_connections (integer) Determines the maximum number of concurrent connections to the *************** *** 663,691 **** ! SUPERUSER_RESERVED_CONNECTIONS (integer) Determines the number of connection slots that are reserved for connections by PostgreSQL ! superusers. At most MAX_CONNECTIONS connections can ever be active simultaneously. Whenever the number of active ! concurrent connections is at least MAX_CONNECTIONS minus ! SUPERUSER_RESERVED_CONNECTIONS, new connections will be accepted only for superusers. The default value is 2. The value must be less than the value of ! MAX_CONNECTIONS. This parameter can only be set at server start. ! PORT (integer) port --- 663,691 ---- ! superuser_reserved_connections (integer) Determines the number of connection slots that are reserved for connections by PostgreSQL ! superusers. At most max_connections connections can ever be active simultaneously. Whenever the number of active ! concurrent connections is at least max_connections minus ! superuser_reserved_connections, new connections will be accepted only for superusers. The default value is 2. The value must be less than the value of ! max_connections. This parameter can only be set at server start. ! port (integer) port *************** *** 697,703 **** ! UNIX_SOCKET_DIRECTORY (string) Specifies the directory of the Unix-domain socket on which the --- 697,703 ---- ! unix_socket_directory (string) Specifies the directory of the Unix-domain socket on which the *************** *** 709,721 **** ! UNIX_SOCKET_GROUP (string) Sets the group owner of the Unix domain socket. (The owning user of the socket is always the user that starts the server.) In combination with the option ! UNIX_SOCKET_PERMISSIONS this can be used as an additional access control mechanism for this socket type. By default this is the empty string, which uses the default group for the current user. This option can only be set at --- 709,721 ---- ! unix_socket_group (string) Sets the group owner of the Unix domain socket. (The owning user of the socket is always the user that starts the server.) In combination with the option ! unix_socket_permissions this can be used as an additional access control mechanism for this socket type. By default this is the empty string, which uses the default group for the current user. This option can only be set at *************** *** 725,731 **** ! UNIX_SOCKET_PERMISSIONS (integer) Sets the access permissions of the Unix domain socket. Unix --- 725,731 ---- ! unix_socket_permissions (integer) Sets the access permissions of the Unix domain socket. Unix *************** *** 741,747 **** The default permissions are 0777, meaning anyone can connect. Reasonable alternatives are 0770 (only user and group, see also under ! UNIX_SOCKET_GROUP) and 0700 (only user). (Note that actually for a Unix domain socket, only write permission matters and there is no point in setting or revoking read or execute permissions.) --- 741,747 ---- The default permissions are 0777, meaning anyone can connect. Reasonable alternatives are 0770 (only user and group, see also under ! unix_socket_group) and 0700 (only user). (Note that actually for a Unix domain socket, only write permission matters and there is no point in setting or revoking read or execute permissions.) *************** *** 759,765 **** ! VIRTUAL_HOST (string) Specifies the host name or IP address on which the server is --- 759,765 ---- ! virtual_host (string) Specifies the host name or IP address on which the server is *************** *** 771,777 **** ! RENDEZVOUS_NAME (string) Specifies the Rendezvous broadcast name. By default, the --- 771,777 ---- ! rendezvous_name (string) Specifies the Rendezvous broadcast name. By default, the *************** *** 787,793 **** ! AUTHENTICATION_TIMEOUT (integer) timeoutclient authentication client authenticationtimeout during --- 787,793 ---- ! authentication_timeout (integer) timeoutclient authentication client authenticationtimeout during *************** *** 807,813 **** SSL ! SSL (boolean) Enables SSL connections. Please read --- 807,813 ---- SSL ! ssl (boolean) Enables SSL connections. Please read *************** *** 818,824 **** ! PASSWORD_ENCRYPTION (boolean) When a password is specified in CREATE USER or --- 818,824 ---- ! password_encryption (boolean) When a password is specified in CREATE USER or *************** *** 830,836 **** ! KRB_SERVER_KEYFILE (string) Sets the location of the Kerberos server key file. See --- 830,836 ---- ! krb_server_keyfile (string) Sets the location of the Kerberos server key file. See *************** *** 840,846 **** ! DB_USER_NAMESPACE (boolean) This allows per-database user names. It is off by default. --- 840,846 ---- ! db_user_namespace (boolean) This allows per-database user names. It is off by default. *************** *** 885,891 **** ! SHARED_BUFFERS (integer) Sets the number of shared memory buffers used by the database --- 885,891 ---- ! shared_buffers (integer) Sets the number of shared memory buffers used by the database *************** *** 894,900 **** initdb). Each buffer is 8192 bytes, unless a different value of BLCKSZ was chosen when building the server. This setting must be at least 16, as well as at ! least twice the value of MAX_CONNECTIONS; however, settings significantly higher than the minimum are usually needed for good performance. Values of a few thousand are recommended for production installations. This option can --- 894,900 ---- initdb). Each buffer is 8192 bytes, unless a different value of BLCKSZ was chosen when building the server. This setting must be at least 16, as well as at ! least twice the value of max_connections; however, settings significantly higher than the minimum are usually needed for good performance. Values of a few thousand are recommended for production installations. This option can *************** *** 912,918 **** ! SORT_MEM (integer) Specifies the amount of memory to be used by internal sort operations and --- 912,918 ---- ! sort_mem (integer) Specifies the amount of memory to be used by internal sort operations and *************** *** 923,929 **** as this value specifies before it starts to put data into temporary files. Also, several running sessions could be doing sort operations simultaneously. So the total memory used could be many ! times the value of SORT_MEM. Sort operations are used by ORDER BY, merge joins, and CREATE INDEX. Hash tables are used in hash joins, hash-based aggregation, and hash-based processing of IN subqueries. Because --- 923,929 ---- as this value specifies before it starts to put data into temporary files. Also, several running sessions could be doing sort operations simultaneously. So the total memory used could be many ! times the value of sort_mem. Sort operations are used by ORDER BY, merge joins, and CREATE INDEX. Hash tables are used in hash joins, hash-based aggregation, and hash-based processing of IN subqueries. Because *************** *** 934,940 **** ! VACUUM_MEM (integer) Specifies the maximum amount of memory to be used by --- 934,940 ---- ! vacuum_mem (integer) Specifies the maximum amount of memory to be used by *************** *** 953,972 **** ! MAX_FSM_PAGES (integer) Sets the maximum number of disk pages for which free space will be tracked in the shared free-space map. Six bytes of shared memory are consumed for each page slot. This setting must be more than ! 16 * MAX_FSM_RELATIONS. The default is 20000. This option can only be set at server start. ! MAX_FSM_RELATIONS (integer) Sets the maximum number of relations (tables and indexes) for which --- 953,972 ---- ! max_fsm_pages (integer) Sets the maximum number of disk pages for which free space will be tracked in the shared free-space map. Six bytes of shared memory are consumed for each page slot. This setting must be more than ! 16 * max_fsm_relations. The default is 20000. This option can only be set at server start. ! max_fsm_relations (integer) Sets the maximum number of relations (tables and indexes) for which *************** *** 985,991 **** ! MAX_FILES_PER_PROCESS (integer) Sets the maximum number of simultaneously open files allowed to each --- 985,991 ---- ! max_files_per_process (integer) Sets the maximum number of simultaneously open files allowed to each *************** *** 1007,1013 **** ! PRELOAD_LIBRARIES (string) preload_libraries --- 1007,1013 ---- ! preload_libraries (string) preload_libraries *************** *** 1066,1072 **** fsync ! FSYNC (boolean) If this option is on, the PostgreSQL server --- 1066,1072 ---- fsync ! fsync (boolean) If this option is on, the PostgreSQL server *************** *** 1083,1089 **** performance penalty: when a transaction is committed, PostgreSQL must wait for the operating system to flush the write-ahead log to disk. When ! FSYNC is disabled, the operating system is allowed to do its best in buffering, ordering, and delaying writes. This can result in significantly improved performance. However, if the system crashes, the results of the last few --- 1083,1089 ---- performance penalty: when a transaction is committed, PostgreSQL must wait for the operating system to flush the write-ahead log to disk. When ! fsync is disabled, the operating system is allowed to do its best in buffering, ordering, and delaying writes. This can result in significantly improved performance. However, if the system crashes, the results of the last few *************** *** 1093,1107 **** Due to the risks involved, there is no universally correct ! setting for FSYNC. Some administrators ! always disable FSYNC, while others only turn it off for bulk loads, where there is a clear restart point if something goes wrong, whereas some administrators ! always leave FSYNC enabled. The default is ! to enable FSYNC, for maximum reliability. If you trust your operating system, your hardware, and your utility company (or your battery backup), you can consider ! disabling FSYNC. --- 1093,1107 ---- Due to the risks involved, there is no universally correct ! setting for fsync. Some administrators ! always disable fsync, while others only turn it off for bulk loads, where there is a clear restart point if something goes wrong, whereas some administrators ! always leave fsync enabled. The default is ! to enable fsync, for maximum reliability. If you trust your operating system, your hardware, and your utility company (or your battery backup), you can consider ! disabling fsync. *************** *** 1112,1126 **** ! WAL_SYNC_METHOD (string) Method used for forcing WAL updates out to disk. Possible values are ! FSYNC (call fsync() at each commit), ! FDATASYNC (call fdatasync() at each commit), ! OPEN_SYNC (write WAL files with open() option O_SYNC), and ! OPEN_DATASYNC (write WAL files with open() option O_DSYNC). Not all of these choices are available on all platforms. This option can only be set at server start or in the postgresql.conf file. --- 1112,1126 ---- ! wal_sync_method (string) Method used for forcing WAL updates out to disk. Possible values are ! fsync (call fsync() at each commit), ! fdatasync (call fdatasync() at each commit), ! open_sync (write WAL files with open() option O_SYNC), and ! open_datasync (write WAL files with open() option O_DSYNC). Not all of these choices are available on all platforms. This option can only be set at server start or in the postgresql.conf file. *************** *** 1129,1135 **** ! WAL_BUFFERS (integer) Number of disk-page buffers in shared memory for WAL --- 1129,1135 ---- ! wal_buffers (integer) Number of disk-page buffers in shared memory for WAL *************** *** 1146,1152 **** ! CHECKPOINT_SEGMENTS (integer) Maximum distance between automatic WAL checkpoints, in log --- 1146,1152 ---- ! checkpoint_segments (integer) Maximum distance between automatic WAL checkpoints, in log *************** *** 1158,1164 **** ! CHECKPOINT_TIMEOUT (integer) Maximum time between automatic WAL checkpoints, in --- 1158,1164 ---- ! checkpoint_timeout (integer) Maximum time between automatic WAL checkpoints, in *************** *** 1170,1176 **** ! CHECKPOINT_WARNING (integer) Write a message to the server logs if checkpoints caused by --- 1170,1176 ---- ! checkpoint_warning (integer) Write a message to the server logs if checkpoints caused by *************** *** 1183,1189 **** ! COMMIT_DELAY (integer) Time delay between writing a commit record to the WAL buffer --- 1183,1189 ---- ! commit_delay (integer) Time delay between writing a commit record to the WAL buffer *************** *** 1194,1200 **** ready to commit within the given interval. But the delay is just wasted if no other transactions become ready to commit. Therefore, the delay is only performed if at least ! COMMIT_SIBLINGS other transactions are active at the instant that a server process has written its commit record. The default is zero (no delay). --- 1194,1200 ---- ready to commit within the given interval. But the delay is just wasted if no other transactions become ready to commit. Therefore, the delay is only performed if at least ! commit_siblings other transactions are active at the instant that a server process has written its commit record. The default is zero (no delay). *************** *** 1202,1212 **** ! COMMIT_SIBLINGS (integer) Minimum number of concurrent open transactions to require ! before performing the COMMIT_DELAY delay. A larger value makes it more probable that at least one other transaction will become ready to commit during the delay interval. The default is five. --- 1202,1212 ---- ! commit_siblings (integer) Minimum number of concurrent open transactions to require ! before performing the commit_delay delay. A larger value makes it more probable that at least one other transaction will become ready to commit during the delay interval. The default is five. *************** *** 1243,1249 **** ! ENABLE_HASHAGG (boolean) Enables or disables the query planner's use of hashed --- 1243,1249 ---- ! enable_hashagg (boolean) Enables or disables the query planner's use of hashed *************** *** 1254,1260 **** ! ENABLE_HASHJOIN (boolean) Enables or disables the query planner's use of hash-join plan --- 1254,1260 ---- ! enable_hashjoin (boolean) Enables or disables the query planner's use of hash-join plan *************** *** 1269,1275 **** index scan ! ENABLE_INDEXSCAN (boolean) Enables or disables the query planner's use of index-scan plan --- 1269,1275 ---- index scan ! enable_indexscan (boolean) Enables or disables the query planner's use of index-scan plan *************** *** 1280,1286 **** ! ENABLE_MERGEJOIN (boolean) Enables or disables the query planner's use of merge-join plan --- 1280,1286 ---- ! enable_mergejoin (boolean) Enables or disables the query planner's use of merge-join plan *************** *** 1291,1297 **** ! ENABLE_NESTLOOP (boolean) Enables or disables the query planner's use of nested-loop join --- 1291,1297 ---- ! enable_nestloop (boolean) Enables or disables the query planner's use of nested-loop join *************** *** 1308,1314 **** sequential scan ! ENABLE_SEQSCAN (boolean) Enables or disables the query planner's use of sequential scan --- 1308,1314 ---- sequential scan ! enable_seqscan (boolean) Enables or disables the query planner's use of sequential scan *************** *** 1321,1327 **** ! ENABLE_SORT (boolean) Enables or disables the query planner's use of explicit sort --- 1321,1327 ---- ! enable_sort (boolean) Enables or disables the query planner's use of explicit sort *************** *** 1334,1340 **** ! ENABLE_TIDSCAN (boolean) Enables or disables the query planner's use of TID --- 1334,1340 ---- ! enable_tidscan (boolean) Enables or disables the query planner's use of TID *************** *** 1363,1369 **** ! EFFECTIVE_CACHE_SIZE (floating point) Sets the planner's assumption about the effective size of the --- 1363,1369 ---- ! effective_cache_size (floating point) Sets the planner's assumption about the effective size of the *************** *** 1376,1382 **** ! RANDOM_PAGE_COST (floating point) Sets the query planner's estimate of the cost of a --- 1376,1382 ---- ! random_page_cost (floating point) Sets the query planner's estimate of the cost of a *************** *** 1389,1395 **** ! CPU_TUPLE_COST (floating point) Sets the query planner's estimate of the cost of processing --- 1389,1395 ---- ! cpu_tuple_cost (floating point) Sets the query planner's estimate of the cost of processing *************** *** 1400,1406 **** ! CPU_INDEX_TUPLE_COST (floating point) Sets the query planner's estimate of the cost of processing --- 1400,1406 ---- ! cpu_index_tuple_cost (floating point) Sets the query planner's estimate of the cost of processing *************** *** 1411,1417 **** ! CPU_OPERATOR_COST (floating point) Sets the planner's estimate of the cost of processing each --- 1411,1417 ---- ! cpu_operator_cost (floating point) Sets the planner's estimate of the cost of processing each *************** *** 1437,1455 **** GEQO genetic query optimization ! GEQO (boolean) Enables or disables genetic query optimization, which is an algorithm that attempts to do query planning without exhaustive searching. This is on by default. See also the various other ! GEQO_ settings. ! GEQO_THRESHOLD (integer) Use genetic query optimization to plan queries with at least --- 1437,1455 ---- GEQO genetic query optimization ! geqo (boolean) Enables or disables genetic query optimization, which is an algorithm that attempts to do query planning without exhaustive searching. This is on by default. See also the various other ! geqo_ settings. ! geqo_threshold (integer) Use genetic query optimization to plan queries with at least *************** *** 1463,1472 **** ! GEQO_EFFORT (integer) ! GEQO_GENERATIONS (integer) ! GEQO_POOL_SIZE (integer) ! GEQO_SELECTION_BIAS (floating point) Various tuning parameters for the genetic query optimization --- 1463,1472 ---- ! geqo_effort (integer) ! geqo_generations (integer) ! geqo_pool_size (integer) ! geqo_selection_bias (floating point) Various tuning parameters for the genetic query optimization *************** *** 1495,1501 **** ! DEFAULT_STATISTICS_TARGET (integer) Sets the default statistics target for table columns that have not --- 1495,1501 ---- ! default_statistics_target (integer) Sets the default statistics target for table columns that have not *************** *** 1508,1533 **** ! FROM_COLLAPSE_LIMIT (integer) The planner will merge sub-queries into upper queries if the resulting FROM list would have no more than this many items. Smaller values reduce planning time but may yield inferior query plans. The default is 8. It is usually wise to keep this less than ! GEQO_THRESHOLD. ! JOIN_COLLAPSE_LIMIT (integer) The planner will flatten explicit inner JOIN constructs into lists of FROM items whenever a list of no more than this many items would result. Usually this is set the same as ! FROM_COLLAPSE_LIMIT. Setting it to 1 prevents any flattening of inner JOINs, allowing explicit JOIN syntax to be used to control the join order. Intermediate values might be useful to trade off planning time --- 1508,1533 ---- ! from_collapse_limit (integer) The planner will merge sub-queries into upper queries if the resulting FROM list would have no more than this many items. Smaller values reduce planning time but may yield inferior query plans. The default is 8. It is usually wise to keep this less than ! geqo_threshold. ! join_collapse_limit (integer) The planner will flatten explicit inner JOIN constructs into lists of FROM items whenever a list of no more than this many items would result. Usually this is set the same as ! from_collapse_limit. Setting it to 1 prevents any flattening of inner JOINs, allowing explicit JOIN syntax to be used to control the join order. Intermediate values might be useful to trade off planning time *************** *** 1557,1563 **** ! SYSLOG (integer) PostgreSQL allows the use of --- 1557,1563 ---- ! syslog (integer) PostgreSQL allows the use of *************** *** 1573,1579 **** ! SYSLOG_FACILITY (string) This option determines the syslog --- 1573,1579 ---- ! syslog_facility (string) This option determines the syslog *************** *** 1590,1596 **** ! SYSLOG_IDENT (string) If logging to syslog is enabled, this option --- 1590,1596 ---- ! syslog_ident (string) If logging to syslog is enabled, this option *************** *** 1610,1616 **** ! CLIENT_MIN_MESSAGES (string) Controls which message levels are sent to the client. --- 1610,1616 ---- ! client_min_messages (string) Controls which message levels are sent to the client. *************** *** 1621,1633 **** includes all the levels that follow it. The later the level, the fewer messages are sent. The default is NOTICE. Note that LOG has a different ! rank here than in LOG_MIN_MESSAGES. ! LOG_MIN_MESSAGES (string) Controls which message levels are written to the server log. --- 1621,1633 ---- includes all the levels that follow it. The later the level, the fewer messages are sent. The default is NOTICE. Note that LOG has a different ! rank here than in log_min_messages. ! log_min_messages (string) Controls which message levels are written to the server log. *************** *** 1639,1664 **** follow it. The later the level, the fewer messages are sent to the log. The default is NOTICE. Note that LOG has a different rank here than in ! CLIENT_MIN_MESSAGES. Only superusers can increase this option. ! LOG_ERROR_VERBOSITY (string) Controls the amount of detail written in the server log for each ! message that is logged. Valid values are TERSE, ! DEFAULT, and VERBOSE, each adding more fields to displayed messages. ! LOG_MIN_ERROR_STATEMENT (string) Controls whether or not the SQL statement that causes an error --- 1639,1664 ---- follow it. The later the level, the fewer messages are sent to the log. The default is NOTICE. Note that LOG has a different rank here than in ! client_min_messages. Only superusers can increase this option. ! log_error_verbosity (string) Controls the amount of detail written in the server log for each ! message that is logged. Valid values are terse, ! default, and verbose, each adding more fields to displayed messages. ! log_min_error_statement (string) Controls whether or not the SQL statement that causes an error *************** *** 1682,1688 **** ! LOG_MIN_DURATION_STATEMENT (integer) Sets a minimum statement execution time (in milliseconds) --- 1682,1688 ---- ! log_min_duration_statement (integer) Sets a minimum statement execution time (in milliseconds) *************** *** 1701,1707 **** ! SILENT_MODE (boolean) Runs the server silently. If this option is set, the server --- 1701,1707 ---- ! silent_mode (boolean) Runs the server silently. If this option is set, the server *************** *** 1807,1816 **** ! DEBUG_PRINT_PARSE (boolean) ! DEBUG_PRINT_REWRITTEN (boolean) ! DEBUG_PRINT_PLAN (boolean) ! DEBUG_PRETTY_PRINT (boolean) These options enable various debugging output to be sent to the --- 1807,1816 ---- ! debug_print_parse (boolean) ! debug_print_rewritten (boolean) ! debug_print_plan (boolean) ! debug_pretty_print (boolean) These options enable various debugging output to be sent to the *************** *** 1826,1832 **** ! LOG_CONNECTIONS (boolean) This outputs a line to the server logs detailing each successful --- 1826,1832 ---- ! log_connections (boolean) This outputs a line to the server logs detailing each successful *************** *** 1839,1850 **** ! LOG_DURATION (boolean) Causes the duration of every completed statement to be logged. ! To use this option, enable LOG_STATEMENT and ! LOG_PID so you can link the statement to the duration using the process ID. Only superusers can turn off this option if it is enabled by the administrator. --- 1839,1850 ---- ! log_duration (boolean) Causes the duration of every completed statement to be logged. ! To use this option, enable log_statement and ! log_pid so you can link the statement to the duration using the process ID. Only superusers can turn off this option if it is enabled by the administrator. *************** *** 1853,1859 **** ! LOG_PID (boolean) Prefixes each message in the server log file with the process ID of --- 1853,1859 ---- ! log_pid (boolean) Prefixes each message in the server log file with the process ID of *************** *** 1866,1872 **** ! LOG_STATEMENT (boolean) Causes each SQL statement to be logged. --- 1866,1872 ---- ! log_statement (boolean) Causes each SQL statement to be logged. *************** *** 1877,1883 **** ! LOG_TIMESTAMP (boolean) Prefixes each server log message with a time stamp. The default --- 1877,1883 ---- ! log_timestamp (boolean) Prefixes each server log message with a time stamp. The default *************** *** 1887,1893 **** ! LOG_HOSTNAME (boolean) By default, connection logs only show the IP address of the --- 1887,1893 ---- ! log_hostname (boolean) By default, connection logs only show the IP address of the *************** *** 1900,1906 **** ! LOG_SOURCE_PORT (boolean) Shows the outgoing port number of the connecting host in the --- 1900,1906 ---- ! log_source_port (boolean) Shows the outgoing port number of the connecting host in the *************** *** 1924,1933 **** ! LOG_STATEMENT_STATS (boolean) ! LOG_PARSER_STATS (boolean) ! LOG_PLANNER_STATS (boolean) ! LOG_EXECUTOR_STATS (boolean) For each query, write performance statistics of the respective --- 1924,1933 ---- ! log_statement_stats (boolean) ! log_parser_stats (boolean) ! log_planner_stats (boolean) ! log_executor_stats (boolean) For each query, write performance statistics of the respective *************** *** 1947,1953 **** ! STATS_START_COLLECTOR (boolean) Controls whether the server should start the --- 1947,1953 ---- ! stats_start_collector (boolean) Controls whether the server should start the *************** *** 1960,1966 **** ! STATS_COMMAND_STRING (boolean) Enables the collection of statistics on the currently --- 1960,1966 ---- ! stats_command_string (boolean) Enables the collection of statistics on the currently *************** *** 1977,1984 **** ! STATS_BLOCK_LEVEL (boolean) ! STATS_ROW_LEVEL (boolean) These enable the collection of block-level and row-level statistics --- 1977,1984 ---- ! stats_block_level (boolean) ! stats_row_level (boolean) These enable the collection of block-level and row-level statistics *************** *** 1992,1998 **** ! STATS_RESET_ON_SERVER_START (boolean) If on, collected statistics are zeroed out whenever the server --- 1992,1998 ---- ! stats_reset_on_server_start (boolean) If on, collected statistics are zeroed out whenever the server *************** *** 2015,2021 **** ! SEARCH_PATH (string) search_path pathfor schemas --- 2015,2021 ---- ! search_path (string) search_path pathfor schemas *************** *** 2030,2036 **** ! The value for SEARCH_PATH has to be a comma-separated list of schema names. If one of the list items is the special value $user, then the schema having the name returned by SESSION_USER is substituted, if there --- 2030,2036 ---- ! The value for search_path has to be a comma-separated list of schema names. If one of the list items is the special value $user, then the schema having the name returned by SESSION_USER is substituted, if there *************** *** 2070,2078 **** The current effective value of the search path can be examined via the SQL function current_schemas(). This is not quite the same as ! examining the value of SEARCH_PATH, since current_schemas() shows how the requests ! appearing in SEARCH_PATH were resolved. --- 2070,2078 ---- The current effective value of the search path can be examined via the SQL function current_schemas(). This is not quite the same as ! examining the value of search_path, since current_schemas() shows how the requests ! appearing in search_path were resolved. *************** *** 2087,2093 **** transaction isolation level ! DEFAULT_TRANSACTION_ISOLATION (string) Each SQL transaction has an isolation level, which can be either --- 2087,2093 ---- transaction isolation level ! default_transaction_isolation (string) Each SQL transaction has an isolation level, which can be either *************** *** 2108,2114 **** read-only transaction ! DEFAULT_TRANSACTION_READ_ONLY (boolean) A read-only SQL transaction cannot alter non-temporary tables. --- 2108,2114 ---- read-only transaction ! default_transaction_read_only (boolean) A read-only SQL transaction cannot alter non-temporary tables. *************** *** 2123,2129 **** ! STATEMENT_TIMEOUT (integer) Aborts any statement that takes over the specified number of --- 2123,2129 ---- ! statement_timeout (integer) Aborts any statement that takes over the specified number of *************** *** 2140,2146 **** ! DATESTYLE (string) date style --- 2140,2146 ---- ! datestyle (string) date style *************** *** 2161,2167 **** ! TIMEZONE (string) time zone --- 2161,2167 ---- ! timezone (string) time zone *************** *** 2174,2180 **** ! AUSTRALIAN_TIMEZONES (boolean) time zoneAustralian --- 2174,2180 ---- ! australian_timezones (boolean) time zoneAustralian *************** *** 2196,2202 **** display ! EXTRA_FLOAT_DIGITS (integer) This parameter adjusts the number of digits displayed for --- 2196,2202 ---- display ! extra_float_digits (integer) This parameter adjusts the number of digits displayed for *************** *** 2212,2218 **** ! CLIENT_ENCODING (string) character set --- 2212,2218 ---- ! client_encoding (string) character set *************** *** 2223,2229 **** ! LC_MESSAGES (string) Sets the language in which messages are displayed. Acceptable --- 2223,2229 ---- ! lc_messages (string) Sets the language in which messages are displayed. Acceptable *************** *** 2244,2250 **** ! LC_MONETARY (string) Sets the locale to use for formatting monetary amounts, for --- 2244,2250 ---- ! lc_monetary (string) Sets the locale to use for formatting monetary amounts, for *************** *** 2259,2265 **** ! LC_NUMERIC (string) Sets the locale to use for formatting numbers, for example --- 2259,2265 ---- ! lc_numeric (string) Sets the locale to use for formatting numbers, for example *************** *** 2274,2280 **** ! LC_TIME (string) Sets the locale to use for formatting date and time values. --- 2274,2280 ---- ! lc_time (string) Sets the locale to use for formatting date and time values. *************** *** 2297,2303 **** ! EXPLAIN_PRETTY_PRINT (boolean) Determines whether EXPLAIN VERBOSE uses the indented --- 2297,2303 ---- ! explain_pretty_print (boolean) Determines whether EXPLAIN VERBOSE uses the indented *************** *** 2307,2313 **** ! DYNAMIC_LIBRARY_PATH (string) dynamic_library_path dynamic loading --- 2307,2313 ---- ! dynamic_library_path (string) dynamic_library_path dynamic loading *************** *** 2321,2327 **** ! The value for DYNAMIC_LIBRARY_PATH has to be a colon-separated list of absolute directory names. If a directory name starts with the special value $libdir, the compiled-in PostgreSQL package --- 2321,2327 ---- ! The value for dynamic_library_path has to be a colon-separated list of absolute directory names. If a directory name starts with the special value $libdir, the compiled-in PostgreSQL package *************** *** 2353,2359 **** ! MAX_EXPR_DEPTH (integer) Sets the maximum expression nesting depth of the parser. The --- 2353,2359 ---- ! max_expr_depth (integer) Sets the maximum expression nesting depth of the parser. The *************** *** 2383,2389 **** deadlock ! DEADLOCK_TIMEOUT (integer) This is the amount of time, in milliseconds, to wait on a lock --- 2383,2389 ---- deadlock ! deadlock_timeout (integer) This is the amount of time, in milliseconds, to wait on a lock *************** *** 2405,2416 **** ! MAX_LOCKS_PER_TRANSACTION (integer) The shared lock table is sized on the assumption that at most ! MAX_LOCKS_PER_TRANSACTION * ! MAX_CONNECTIONS distinct objects will need to be locked at any one time. The default, 64, has historically proven sufficient, but you might need to raise this value if you have clients that touch many different tables in a single --- 2405,2416 ---- ! max_locks_per_transaction (integer) The shared lock table is sized on the assumption that at most ! max_locks_per_transaction * ! max_connections distinct objects will need to be locked at any one time. The default, 64, has historically proven sufficient, but you might need to raise this value if you have clients that touch many different tables in a single *************** *** 2430,2436 **** ! ADD_MISSING_FROM (boolean) FROMmissing --- 2430,2436 ---- ! add_missing_from (boolean) FROMmissing *************** *** 2447,2453 **** ! REGEX_FLAVOR (string) regular expressions --- 2447,2453 ---- ! regex_flavor (string) regular expressions *************** *** 2461,2467 **** ! SQL_INHERITANCE (boolean) inheritance --- 2461,2467 ---- ! sql_inheritance (boolean) inheritance *************** *** 2483,2489 **** ! TRANSFORM_NULL_EQUALS (boolean) IS NULL --- 2483,2489 ---- ! transform_null_equals (boolean) IS NULL *************** *** 2544,2550 **** ! DEBUG_ASSERTIONS (boolean) Turns on various assertion checks. This is a debugging aid. If --- 2544,2550 ---- ! debug_assertions (boolean) Turns on various assertion checks. This is a debugging aid. If *************** *** 2562,2568 **** ! PRE_AUTH_DELAY (integer) If nonzero, a delay of this many seconds occurs just after a new --- 2562,2568 ---- ! pre_auth_delay (integer) If nonzero, a delay of this many seconds occurs just after a new *************** *** 2575,2581 **** ! TRACE_NOTIFY (boolean) Generates a great amount of debugging output for the --- 2575,2581 ---- ! trace_notify (boolean) Generates a great amount of debugging output for the *************** *** 2589,2601 **** ! TRACE_LOCKS (boolean) ! TRACE_LWLOCKS (boolean) ! TRACE_USERLOCKS (boolean) ! TRACE_LOCK_OIDMIN (boolean) ! TRACE_LOCK_TABLE (boolean) ! DEBUG_DEADLOCKS (boolean) ! LOG_BTREE_BUILD_STATS (boolean) Various other code tracing and debugging options. --- 2589,2601 ---- ! trace_locks (boolean) ! trace_lwlocks (boolean) ! trace_userlocks (boolean) ! trace_lock_oidmin (boolean) ! trace_lock_table (boolean) ! debug_deadlocks (boolean) ! log_btree_build_stats (boolean) Various other code tracing and debugging options. *************** *** 2604,2610 **** ! WAL_DEBUG (integer) If nonzero, turn on WAL-related debugging output. --- 2604,2610 ---- ! wal_debug (integer) If nonzero, turn on WAL-related debugging output. *************** *** 2613,2624 **** ! ZERO_DAMAGED_PAGES (boolean) 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. But it allows you to get --- 2613,2624 ---- ! zero_damaged_pages (boolean) 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. But it allows you to get *************** *** 2814,2820 **** SHMMAX Maximum size of shared memory segment (bytes) ! 250 kB + 8.2 kB * SHARED_BUFFERS + 14.2 kB * MAX_CONNECTIONS up to infinity --- 2814,2820 ---- SHMMAX Maximum size of shared memory segment (bytes) ! 250 kB + 8.2 kB * shared_buffers + 14.2 kB * max_connections up to infinity *************** *** 3359,3365 **** processes do so then the system-wide limit can easily be exceeded. If you find this happening, and you do not want to alter the system-wide limit, you can set PostgreSQL's ! MAX_FILES_PER_PROCESS configuration parameter to limit the consumption of open files. --- 3359,3365 ---- processes do so then the system-wide limit can easily be exceeded. If you find this happening, and you do not want to alter the system-wide limit, you can set PostgreSQL's ! max_files_per_process configuration parameter to limit the consumption of open files. *************** *** 3468,3474 **** With SSL support compiled in, the PostgreSQL server can be started with SSL enabled by setting the parameter ! SSL to on in postgresql.conf. When starting in SSL mode, the server will look for the files server.key and server.crt in the data directory, which should contain the server private key --- 3468,3474 ---- With SSL support compiled in, the PostgreSQL server can be started with SSL enabled by setting the parameter ! ssl to on in postgresql.conf. When starting in SSL mode, the server will look for the files server.key and server.crt in the data directory, which should contain the server private key Index: src/backend/postmaster/postmaster.c =================================================================== RCS file: /cvsroot/pgsql-server/src/backend/postmaster/postmaster.c,v retrieving revision 1.343 diff -c -c -r1.343 postmaster.c *** src/backend/postmaster/postmaster.c 4 Sep 2003 03:38:55 -0000 1.343 --- src/backend/postmaster/postmaster.c 11 Sep 2003 18:23:16 -0000 *************** *** 2609,2615 **** ereport(LOG, (errmsg("checkpoints are occurring too frequently (%d seconds apart)", elapsed_secs), ! errhint("Consider increasing CHECKPOINT_SEGMENTS."))); } LastSignalledCheckpoint = now; } --- 2609,2615 ---- ereport(LOG, (errmsg("checkpoints are occurring too frequently (%d seconds apart)", elapsed_secs), ! errhint("Consider increasing 'checkpoint_segments'."))); } LastSignalledCheckpoint = now; } Index: src/backend/utils/misc/guc.c =================================================================== RCS file: /cvsroot/pgsql-server/src/backend/utils/misc/guc.c,v retrieving revision 1.156 diff -c -c -r1.156 guc.c *** src/backend/utils/misc/guc.c 7 Sep 2003 15:26:53 -0000 1.156 --- src/backend/utils/misc/guc.c 11 Sep 2003 18:23:21 -0000 *************** *** 1311,1317 **** { {"log_error_verbosity", PGC_SUSET, LOGGING_WHEN, gettext_noop("Controls verbosity of logged messages"), ! gettext_noop("Valid values are TERSE, DEFAULT, and VERBOSE") }, &log_error_verbosity_str, "default", assign_log_error_verbosity, NULL --- 1311,1317 ---- { {"log_error_verbosity", PGC_SUSET, LOGGING_WHEN, gettext_noop("Controls verbosity of logged messages"), ! gettext_noop("Valid values are 'terse', 'default', and 'verbose'") }, &log_error_verbosity_str, "default", assign_log_error_verbosity, NULL