Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit77d3355

Browse files
committed
Minor improvements to postmaster/backend man pages.
1 parent41543b0 commit77d3355

File tree

2 files changed

+50
-26
lines changed

2 files changed

+50
-26
lines changed

‎src/man/postgres.1‎

Lines changed: 18 additions & 8 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/postgres.1,v 1.14 1999/03/17 22:53:31 momjian Exp $
4-
.TH POSTGRESQL UNIX12/08/96 PostgreSQL PostgreSQL
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/postgres.1,v 1.15 1999/05/19 23:30:43 tgl Exp $
4+
.TH POSTGRESQL UNIX05/19/99 PostgreSQL PostgreSQL
55
.SH NAME
66
postgres - the Postgres backend server
77
.SH SYNOPSIS
@@ -57,6 +57,11 @@ done while other Postgres backends are being managed by a
5757
.IR postmaster
5858
on this set of databases.
5959
.PP
60+
Some of the switches explained in this man page can be passed to the backend
61+
through the "database options" field of a connection request, and thus can be
62+
set for a particular backend without going to the trouble of restarting the
63+
postmaster. This is particularly handy for debugging-related switches.
64+
.PP
6065
The optional argument
6166
.IR dbname
6267
specifies the name of the database to be accessed.
@@ -77,7 +82,8 @@ is the number of shared-memory buffers that the
7782
.IR"postmaster"
7883
has allocated for the backend server processes that it starts. If the
7984
backend is running standalone, this specifies the number of buffers to
80-
allocate. This value defaults to 64, and each buffer is 8k bytes.
85+
allocate. This value defaults to 64 buffers, where each buffer is 8k bytes
86+
(or whatever BLCKSZ is set to in config.h).
8187
.TP
8288
.BR"-C"
8389
Do not show server version number.
@@ -116,9 +122,12 @@ useful for interactive use.
116122
Specifies\*(lqquiet\*(rq mode.
117123
.TP
118124
.BR"-S"
119-
Specifies the amount of memory to be used by internal sorts before using
120-
disk files for sorting. This value is specified in 1k bytes, and
121-
defaults to 512.
125+
Specifies the amount of memory to be used by internal sorts and hashes
126+
before resorting to temporary disk files. The value is specified in
127+
kilobytes, and defaults to 512 kilobytes. Note that for a complex query,
128+
several sorts and/or hashes might be running in parallel, and each one
129+
will be allowed to use as much as -S kilobytes before it starts to put
130+
data into temporary files.
122131
.TP
123132
.BR"-e"
124133
The
@@ -185,8 +194,9 @@ Forbids the use of particular scan and join methods:
185194
disable sequential and index scans respectively, while
186195
.IR n"," m" and" h
187196
disable nested-loop, merge and hash joins respectively.
188-
This is another feature that may not necessarily produce executable
189-
plans.
197+
(Neither sequential scans nor nested-loop joins can be disabled completely;
198+
the -fs and -fn options simply discourage the optimizer from using those
199+
plan types if it has any other alternative.)
190200
.TP
191201
.BR"-i"
192202
Prevents query execution, but shows the plan tree.

‎src/man/postmaster.1‎

Lines changed: 32 additions & 18 deletions
Original file line numberDiff line numberDiff line change
@@ -1,7 +1,7 @@
11
.\" This is -*-nroff-*-
22
.\" XXX standard disclaimer belongs here....
3-
.\" $Header: /cvsroot/pgsql/src/man/Attic/postmaster.1,v 1.15 1999/02/22 05:26:58 momjian Exp $
4-
.TH POSTMASTER UNIX02/20/99 PostgreSQL PostgreSQL
3+
.\" $Header: /cvsroot/pgsql/src/man/Attic/postmaster.1,v 1.16 1999/05/19 23:30:43 tgl Exp $
4+
.TH POSTMASTER UNIX05/19/99 PostgreSQL PostgreSQL
55
.SH "NAME"
66
postmaster - run the Postgres postmaster
77
.SH "SYNOPSIS"
@@ -49,12 +49,17 @@ port]
4949
The
5050
.IR"postmaster"
5151
manages the communication between frontend and backend processes, as
52-
well as allocating the shared buffer pool andsemaphores (on machines
53-
without a test-and-set instruction). The
52+
well as allocating the shared buffer pool andSysV semaphores
53+
(on machineswithout a test-and-set instruction). The
5454
.IR postmaster
5555
does not itself interact with the user and should be started as a
5656
background process.
57-
.BR"Only one postmaster should be run on a machine."
57+
.PP
58+
.BR"Only one postmaster should be running at a time in a given
59+
Postgres installation."
60+
Here, an installation means a database directory and postmaster port number.
61+
You can run more than one postmaster on a machine only if each one has a
62+
separate directory and port number.
5863
.PP
5964
The
6065
.IR"postmaster"
@@ -65,12 +70,13 @@ understands the following command-line options:
6570
is the number of shared-memory buffers for the
6671
.IR"postmaster"
6772
to allocate and manage for the backend server processes that it
68-
starts. This value defaults to 64, and each buffer is 8k bytes.
73+
starts. This value defaults to 64 buffers, where each buffer is 8k bytes
74+
(or whatever BLCKSZ is set to in config.h).
6975
.TP
7076
.BR"-D"" data_dir"
7177
Specifies the directory to use as the root of the tree of database
72-
directories.This directory usesthevalue of the environment
73-
variable
78+
directories.If -D is not given,thedefault data directory name is
79+
the value of the environmentvariable
7480
.SMPGDATA.
7581
If
7682
.SMPGDATA
@@ -86,7 +92,7 @@ is the maximum number of backend server processes that this postmaster
8692
is allowed to start. In the stock configuration, this value defaults
8793
to 64, and can be set as high as 1024 if your system will support that
8894
many processes. Both the default and upper limit values can be altered
89-
when building Postgres.
95+
when building Postgres (see src/include/config.h).
9096
.TP
9197
.BR"-S"
9298
Specifies that the
@@ -113,7 +119,8 @@ authentication, use
113119
to deny any unauthenticated
114120
connections, use
115121
.BR"-a nounauth .
116-
This option no longer has any effect.
122+
This option no longer has any effect! The pg_hba.conf configuration
123+
file now controls authentication.
117124
.TP
118125
.BR"-b"" backend_pathname"
119126
.IR"backend_pathname"
@@ -131,6 +138,9 @@ was invoked. If no pathname was specified, then the
131138
.SMPATH
132139
environment variable is searched for an executable named
133140
\*(lqpostgres\*(rq).
141+
This option is also obsolete, since the postmaster and backend are now
142+
a single executable --- the postmaster forks a backend but does not do
143+
an exec.
134144
.TP
135145
.BR"-d"" [debug_level]"
136146
The optional argument
@@ -201,9 +211,12 @@ Specifies the TCP/IP port or local Unix domain socket file extension
201211
on which the
202212
.IR postmaster
203213
is to listen for connections from frontend applications. Defaults to
204-
5432, or the value of the
214+
the value of the
215+
.SMPGPORT
216+
environment variable, or if
205217
.SMPGPORT
206-
environment variable (if set). If you specify a port other than the
218+
is not set, then the default value established when Postgres was
219+
compiled (normally 5432). If you specify a port other than the
207220
default port then all frontend application users must specify the same
208221
port (using command-line options or
209222
.SMPGPORT\c
@@ -253,7 +266,7 @@ simplest and most common way to start the
253266
.nf
254267

255268
# start with specific port and executable name
256-
nohup postmaster -p -b /usr/postgres/bin/postgres &
269+
nohup postmaster -p1234-b /usr/postgres/bin/postgres &
257270

258271
.fi
259272
This command will start up a
@@ -281,7 +294,7 @@ postgres(1),
281294
.BR"FindBackend: could not find a backend to execute..."
282295
If you see this message, you do not have the
283296
.IR"postgres"
284-
executable in your path. Add thedirectoy in which postgres resides to
297+
executable in your path. Add thedirectory in which postgres resides to
285298
your path.
286299
.TP
287300
.BR"semget: No space left on device"
@@ -293,10 +306,11 @@ again. If this still doesn't work, you probably need to configure
293306
your kernel for shared memory and semaphores as described in the
294307
installation notes. If you run multiple
295308
.IR postmasters
296-
on a single host, or have reduced the shared memory and semaphore
297-
parameters from the defaults in the generic kernel, you may have to
298-
go back and increase the shared memory and semaphores configured
299-
into your kernel.
309+
on a single host, or have a kernel with particularly small shared memory
310+
and/or semaphore limits, you may have to reconfigure your kernel to increase
311+
its shared memory or semaphore parameters. (You may be able to postpone
312+
reconfiguring your kernel by reducing -B to reduce Postgres' shared memory
313+
consumption, or by reducing -N to reduce Postgres' semaphore consumption.)
300314
.TP
301315
.BR"StreamServerPort: cannot bind to port"
302316
If you see this message, you should be certain that there is no other

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp