From 86c23a6eb28b0588644dcefeb33ef5a2aa8b9453 Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Thu, 5 Jan 2006 10:07:46 +0000 Subject: Make all command-line options of postmaster and postgres the same. See http://archives.postgresql.org/pgsql-hackers/2006-01/msg00151.php for the complete plan. --- doc/src/sgml/ref/postgres-ref.sgml | 259 ++++++++----------------------------- 1 file changed, 53 insertions(+), 206 deletions(-) (limited to 'doc/src/sgml/ref/postgres-ref.sgml') diff --git a/doc/src/sgml/ref/postgres-ref.sgml b/doc/src/sgml/ref/postgres-ref.sgml index 4baecaf2eda..1cf8521bebb 100644 --- a/doc/src/sgml/ref/postgres-ref.sgml +++ b/doc/src/sgml/ref/postgres-ref.sgml @@ -1,5 +1,5 @@ @@ -21,53 +21,9 @@ PostgreSQL documentation - postgres - -A 01 - -B nbuffers - -c name=value - -d debug-level - --describe-config - -D datadir - -e - -E - -fsitnmh - -F - -N - -o filename - -O - -P - - -s - -tpaplex - - -S work-mem - -W seconds - --name=value + option database - - - postgres - -A 01 - -B nbuffers - -c name=value - -d debug-level - -D datadir - -e - -fsitnmh - -F - -o filename - -O - -p database - -P - - -s - -tpaplex - - -S work-mem - -v protocol - -W seconds - --name=value @@ -77,23 +33,21 @@ PostgreSQL documentation The postgres executable is the actual PostgreSQL server process that processes - queries. It is normally not called directly; instead a multiuser server is started. - - - - The second form above is how - postgres is invoked by the (only - conceptually, since both postmaster and - postgres are in fact the same program); it - should not be invoked directly this way. The first form invokes - the server directly in interactive single-user mode. The primary use - for this mode is during bootstrapping by . - Sometimes it is used for debugging or disaster recovery. + SQL statements. It is normally not called directly; instead a + multiuser server is started. + Conceptually, the postmaster starts a new + postgres process for each connection. + (postmaster and postgres + are in fact the same program, and on most platforms the connection + process is forked). + If the postgres command is called directly, it + invokes the server in interactive single-user mode. The primary + use for this mode is during bootstrapping by . Sometimes it is used for debugging or + disaster recovery. When invoked in interactive mode from the shell, the user can enter queries and the results will be printed to the screen, but in a form that is more useful for developers than end users. But note @@ -117,11 +71,9 @@ PostgreSQL documentation When postgres is started by a then it - inherits all options set by the latter. Additionally, - postgres-specific options can be passed - from the postmaster with the - switch. + linkend="app-postmaster"> then it inherits all options set by the + latter. In single-user mode, postgres accepts + all the options that postmaster would accept. @@ -141,74 +93,17 @@ PostgreSQL documentation The options , , , , , - , and have the same meanings - as the except that - -d 0 prevents the server log level of - the postmaster from being propagated to postgres. + , , , + , and + have the same meanings as with the + except that -d 0 prevents the server log level of the + postmaster from being propagated to + postgres. Other postmaster + options are also accepted but will have no noticeable effect + because they only apply to the multiuser server mode, namely + , , , + , and . - - - - - - - Sets the default date style to European, that is - DMY ordering of input date fields. This also causes - the day to be printed before the month in certain date output formats. - See for more information. - - - - - - filename - - - Send all server log output to - filename. - If postgres is running under the - postmaster, this option is ignored, - and the stderr inherited from the - postmaster is used. - - - - - - - - - Ignore system indexes when reading system tables (but still update - the indexes when modifying the tables). This is useful when - recovering from damaged system indexes. - - - - - - - - - Print time information and other statistics at the end of each command. - This is useful for benchmarking or for use in tuning the number of - buffers. - - - - - - work-mem - - - Specifies the amount of memory to be used by internal sorts and hashes - before resorting to temporary disk files. See the description of the - work_mem configuration parameter in . - - - - - @@ -235,83 +130,41 @@ PostgreSQL documentation - + Disables use of newline as a statement delimiter. - - - - - Semi-internal Options - - - There are several other options that may be specified, used - mainly for debugging purposes. These are listed here only for - the use by PostgreSQL system - developers. Use of any of these options is highly - discouraged. Furthermore, any of these options may - disappear or change in a future release without notice. - - - - - { s | i | m | n | h } - - - Forbids the use of particular scan and join methods: - s and i - disable sequential and index scans respectively, while - n, m, and h - disable nested-loop, merge and hash joins respectively. - - - - - Neither sequential scans nor nested-loop joins can be disabled completely; - the -fs and -fn - options simply discourage the optimizer from using those - plan types if it has any other alternative. - - - - - + filename - Allows the structure of system tables to be modified. This is - used by initdb. + Send all server log output to + filename. + If postgres is running under the + postmaster, this option is ignored, + and the stderr inherited from the + postmaster is used. + + - - database - - - Indicates that this process has been started by a - postmaster and specifies the database to use. - etc. - - - + + Semi-internal Options - - pa[rser] | pl[anner] | e[xecutor] - - - Print timing statistics for each query relating to each of the - major system modules. This option cannot be used together - with the option. - - - + + The options , , + , , and + have the same meanings as with the and are reserved for debugging and + disaster recovery. Further options for internal use are: + protocol @@ -323,12 +176,12 @@ PostgreSQL documentation - seconds + database - As soon as this option is encountered, the process sleeps for - the specified amount of seconds. This gives developers time - to attach a debugger to the server process. + Indicates that this process has been started by a + postmaster and specifies the database to use. + etc. @@ -343,8 +196,8 @@ PostgreSQL documentation - + @@ -361,13 +214,7 @@ PostgreSQL documentation - - - - For others, which have little influence during single-user mode, - see . - @@ -423,7 +270,7 @@ PostgreSQL documentation - But if you use the -- cgit v1.2.3