← Back to branch summary

~ubuntu-branches/ubuntu/oneiric/postgresql-9.1/oneiric-security

« back to all changes in this revision

Viewing changes to doc/src/sgml/html/runtime-config.html

  • Committer: Bazaar Package Importer
  • Author(s): Martin Pitt
  • Date: 2011-05-11 10:41:53 UTC
  • Revision ID: james.westby@ubuntu.com-20110511104153-psbh2o58553fv1m0
Tags: upstream-9.1~beta1
Import upstream version 9.1~beta1

Show diffs side-by-side

added added

removed removed

Lines of Context:
doc/src/sgml/html/runtime-config.html
 
1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
 
2
<HTML
 
3
><HEAD
 
4
><TITLE
 
5
>Server Configuration</TITLE
 
6
><META
 
7
NAME="GENERATOR"
 
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
 
9
REV="MADE"
 
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
 
11
REL="HOME"
 
12
TITLE="PostgreSQL 9.1beta1 Documentation"
 
13
HREF="index.html"><LINK
 
14
REL="UP"
 
15
TITLE="Server Administration"
 
16
HREF="admin.html"><LINK
 
17
REL="PREVIOUS"
 
18
TITLE="Secure TCP/IP Connections with SSH Tunnels"
 
19
HREF="ssh-tunnels.html"><LINK
 
20
REL="NEXT"
 
21
TITLE="Setting Parameters"
 
22
HREF="config-setting.html"><LINK
 
23
REL="STYLESHEET"
 
24
TYPE="text/css"
 
25
HREF="stylesheet.css"><META
 
26
HTTP-EQUIV="Content-Type"
 
27
CONTENT="text/html; charset=ISO-8859-1"><META
 
28
NAME="creation"
 
29
CONTENT="2011-04-27T21:20:33"></HEAD
 
30
><BODY
 
31
CLASS="CHAPTER"
 
32
><DIV
 
33
CLASS="NAVHEADER"
 
34
><TABLE
 
35
SUMMARY="Header navigation table"
 
36
WIDTH="100%"
 
37
BORDER="0"
 
38
CELLPADDING="0"
 
39
CELLSPACING="0"
 
40
><TR
 
41
><TH
 
42
COLSPAN="5"
 
43
ALIGN="center"
 
44
VALIGN="bottom"
 
45
><A
 
46
HREF="index.html"
 
47
>PostgreSQL 9.1beta1 Documentation</A
 
48
></TH
 
49
></TR
 
50
><TR
 
51
><TD
 
52
WIDTH="10%"
 
53
ALIGN="left"
 
54
VALIGN="top"
 
55
><A
 
56
TITLE="Secure TCP/IP Connections with SSH Tunnels"
 
57
HREF="ssh-tunnels.html"
 
58
ACCESSKEY="P"
 
59
>Prev</A
 
60
></TD
 
61
><TD
 
62
WIDTH="10%"
 
63
ALIGN="left"
 
64
VALIGN="top"
 
65
><A
 
66
TITLE="Server Setup and Operation"
 
67
HREF="runtime.html"
 
68
>Fast Backward</A
 
69
></TD
 
70
><TD
 
71
WIDTH="60%"
 
72
ALIGN="center"
 
73
VALIGN="bottom"
 
74
></TD
 
75
><TD
 
76
WIDTH="10%"
 
77
ALIGN="right"
 
78
VALIGN="top"
 
79
><A
 
80
TITLE="Client Authentication"
 
81
HREF="client-authentication.html"
 
82
>Fast Forward</A
 
83
></TD
 
84
><TD
 
85
WIDTH="10%"
 
86
ALIGN="right"
 
87
VALIGN="top"
 
88
><A
 
89
TITLE="Setting Parameters"
 
90
HREF="config-setting.html"
 
91
ACCESSKEY="N"
 
92
>Next</A
 
93
></TD
 
94
></TR
 
95
></TABLE
 
96
><HR
 
97
ALIGN="LEFT"
 
98
WIDTH="100%"></DIV
 
99
><DIV
 
100
CLASS="CHAPTER"
 
101
><H1
 
102
><A
 
103
NAME="RUNTIME-CONFIG"
 
104
></A
 
105
>Chapter 18. Server Configuration</H1
 
106
><DIV
 
107
CLASS="TOC"
 
108
><DL
 
109
><DT
 
110
><B
 
111
>Table of Contents</B
 
112
></DT
 
113
><DT
 
114
>18.1. <A
 
115
HREF="config-setting.html"
 
116
>Setting Parameters</A
 
117
></DT
 
118
><DT
 
119
>18.2. <A
 
120
HREF="runtime-config-file-locations.html"
 
121
>File Locations</A
 
122
></DT
 
123
><DT
 
124
>18.3. <A
 
125
HREF="runtime-config-connection.html"
 
126
>Connections and Authentication</A
 
127
></DT
 
128
><DD
 
129
><DL
 
130
><DT
 
131
>18.3.1. <A
 
132
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SETTINGS"
 
133
>Connection Settings</A
 
134
></DT
 
135
><DT
 
136
>18.3.2. <A
 
137
HREF="runtime-config-connection.html#RUNTIME-CONFIG-CONNECTION-SECURITY"
 
138
>Security and Authentication</A
 
139
></DT
 
140
></DL
 
141
></DD
 
142
><DT
 
143
>18.4. <A
 
144
HREF="runtime-config-resource.html"
 
145
>Resource Consumption</A
 
146
></DT
 
147
><DD
 
148
><DL
 
149
><DT
 
150
>18.4.1. <A
 
151
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-MEMORY"
 
152
>Memory</A
 
153
></DT
 
154
><DT
 
155
>18.4.2. <A
 
156
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-KERNEL"
 
157
>Kernel Resource Usage</A
 
158
></DT
 
159
><DT
 
160
>18.4.3. <A
 
161
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-VACUUM-COST"
 
162
>Cost-based Vacuum Delay</A
 
163
></DT
 
164
><DT
 
165
>18.4.4. <A
 
166
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-BACKGROUND-WRITER"
 
167
>Background Writer</A
 
168
></DT
 
169
><DT
 
170
>18.4.5. <A
 
171
HREF="runtime-config-resource.html#RUNTIME-CONFIG-RESOURCE-ASYNC-BEHAVIOR"
 
172
>Asynchronous Behavior</A
 
173
></DT
 
174
></DL
 
175
></DD
 
176
><DT
 
177
>18.5. <A
 
178
HREF="runtime-config-wal.html"
 
179
>Write Ahead Log</A
 
180
></DT
 
181
><DD
 
182
><DL
 
183
><DT
 
184
>18.5.1. <A
 
185
HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-SETTINGS"
 
186
>Settings</A
 
187
></DT
 
188
><DT
 
189
>18.5.2. <A
 
190
HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-CHECKPOINTS"
 
191
>Checkpoints</A
 
192
></DT
 
193
><DT
 
194
>18.5.3. <A
 
195
HREF="runtime-config-wal.html#RUNTIME-CONFIG-WAL-ARCHIVING"
 
196
>Archiving</A
 
197
></DT
 
198
><DT
 
199
>18.5.4. <A
 
200
HREF="runtime-config-wal.html#RUNTIME-CONFIG-REPLICATION"
 
201
>Streaming Replication</A
 
202
></DT
 
203
><DT
 
204
>18.5.5. <A
 
205
HREF="runtime-config-wal.html#RUNTIME-CONFIG-SYNC-REP"
 
206
>Synchronous Replication</A
 
207
></DT
 
208
><DT
 
209
>18.5.6. <A
 
210
HREF="runtime-config-wal.html#RUNTIME-CONFIG-STANDBY"
 
211
>Standby Servers</A
 
212
></DT
 
213
></DL
 
214
></DD
 
215
><DT
 
216
>18.6. <A
 
217
HREF="runtime-config-query.html"
 
218
>Query Planning</A
 
219
></DT
 
220
><DD
 
221
><DL
 
222
><DT
 
223
>18.6.1. <A
 
224
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-ENABLE"
 
225
>Planner Method Configuration</A
 
226
></DT
 
227
><DT
 
228
>18.6.2. <A
 
229
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-CONSTANTS"
 
230
>Planner Cost Constants</A
 
231
></DT
 
232
><DT
 
233
>18.6.3. <A
 
234
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-GEQO"
 
235
>Genetic Query Optimizer</A
 
236
></DT
 
237
><DT
 
238
>18.6.4. <A
 
239
HREF="runtime-config-query.html#RUNTIME-CONFIG-QUERY-OTHER"
 
240
>Other Planner Options</A
 
241
></DT
 
242
></DL
 
243
></DD
 
244
><DT
 
245
>18.7. <A
 
246
HREF="runtime-config-logging.html"
 
247
>Error Reporting and Logging</A
 
248
></DT
 
249
><DD
 
250
><DL
 
251
><DT
 
252
>18.7.1. <A
 
253
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE"
 
254
>Where To Log</A
 
255
></DT
 
256
><DT
 
257
>18.7.2. <A
 
258
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN"
 
259
>When To Log</A
 
260
></DT
 
261
><DT
 
262
>18.7.3. <A
 
263
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT"
 
264
>What To Log</A
 
265
></DT
 
266
><DT
 
267
>18.7.4. <A
 
268
HREF="runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG"
 
269
>Using CSV-Format Log Output</A
 
270
></DT
 
271
></DL
 
272
></DD
 
273
><DT
 
274
>18.8. <A
 
275
HREF="runtime-config-statistics.html"
 
276
>Run-time Statistics</A
 
277
></DT
 
278
><DD
 
279
><DL
 
280
><DT
 
281
>18.8.1. <A
 
282
HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-COLLECTOR"
 
283
>Query and Index Statistics Collector</A
 
284
></DT
 
285
><DT
 
286
>18.8.2. <A
 
287
HREF="runtime-config-statistics.html#RUNTIME-CONFIG-STATISTICS-MONITOR"
 
288
>Statistics Monitoring</A
 
289
></DT
 
290
></DL
 
291
></DD
 
292
><DT
 
293
>18.9. <A
 
294
HREF="runtime-config-autovacuum.html"
 
295
>Automatic Vacuuming</A
 
296
></DT
 
297
><DT
 
298
>18.10. <A
 
299
HREF="runtime-config-client.html"
 
300
>Client Connection Defaults</A
 
301
></DT
 
302
><DD
 
303
><DL
 
304
><DT
 
305
>18.10.1. <A
 
306
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-STATEMENT"
 
307
>Statement Behavior</A
 
308
></DT
 
309
><DT
 
310
>18.10.2. <A
 
311
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-FORMAT"
 
312
>Locale and Formatting</A
 
313
></DT
 
314
><DT
 
315
>18.10.3. <A
 
316
HREF="runtime-config-client.html#RUNTIME-CONFIG-CLIENT-OTHER"
 
317
>Other Defaults</A
 
318
></DT
 
319
></DL
 
320
></DD
 
321
><DT
 
322
>18.11. <A
 
323
HREF="runtime-config-locks.html"
 
324
>Lock Management</A
 
325
></DT
 
326
><DT
 
327
>18.12. <A
 
328
HREF="runtime-config-compatible.html"
 
329
>Version and Platform Compatibility</A
 
330
></DT
 
331
><DD
 
332
><DL
 
333
><DT
 
334
>18.12.1. <A
 
335
HREF="runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-VERSION"
 
336
>Previous PostgreSQL Versions</A
 
337
></DT
 
338
><DT
 
339
>18.12.2. <A
 
340
HREF="runtime-config-compatible.html#RUNTIME-CONFIG-COMPATIBLE-CLIENTS"
 
341
>Platform and Client Compatibility</A
 
342
></DT
 
343
></DL
 
344
></DD
 
345
><DT
 
346
>18.13. <A
 
347
HREF="runtime-config-error-handling.html"
 
348
>Error Handling</A
 
349
></DT
 
350
><DT
 
351
>18.14. <A
 
352
HREF="runtime-config-preset.html"
 
353
>Preset Options</A
 
354
></DT
 
355
><DT
 
356
>18.15. <A
 
357
HREF="runtime-config-custom.html"
 
358
>Customized Options</A
 
359
></DT
 
360
><DT
 
361
>18.16. <A
 
362
HREF="runtime-config-developer.html"
 
363
>Developer Options</A
 
364
></DT
 
365
><DT
 
366
>18.17. <A
 
367
HREF="runtime-config-short.html"
 
368
>Short Options</A
 
369
></DT
 
370
></DL
 
371
></DIV
 
372
><P
 
373
>   There are many configuration parameters that affect the behavior of
 
374
   the database system. In the first section of this chapter, we
 
375
   describe how to set configuration parameters. The subsequent sections
 
376
   discuss each parameter in detail.
 
377
  </P
 
378
></DIV
 
379
><DIV
 
380
CLASS="NAVFOOTER"
 
381
><HR
 
382
ALIGN="LEFT"
 
383
WIDTH="100%"><TABLE
 
384
SUMMARY="Footer navigation table"
 
385
WIDTH="100%"
 
386
BORDER="0"
 
387
CELLPADDING="0"
 
388
CELLSPACING="0"
 
389
><TR
 
390
><TD
 
391
WIDTH="33%"
 
392
ALIGN="left"
 
393
VALIGN="top"
 
394
><A
 
395
HREF="ssh-tunnels.html"
 
396
ACCESSKEY="P"
 
397
>Prev</A
 
398
></TD
 
399
><TD
 
400
WIDTH="34%"
 
401
ALIGN="center"
 
402
VALIGN="top"
 
403
><A
 
404
HREF="index.html"
 
405
ACCESSKEY="H"
 
406
>Home</A
 
407
></TD
 
408
><TD
 
409
WIDTH="33%"
 
410
ALIGN="right"
 
411
VALIGN="top"
 
412
><A
 
413
HREF="config-setting.html"
 
414
ACCESSKEY="N"
 
415
>Next</A
 
416
></TD
 
417
></TR
 
418
><TR
 
419
><TD
 
420
WIDTH="33%"
 
421
ALIGN="left"
 
422
VALIGN="top"
 
423
>Secure TCP/IP Connections with <SPAN
 
424
CLASS="APPLICATION"
 
425
>SSH</SPAN
 
426
> Tunnels</TD
 
427
><TD
 
428
WIDTH="34%"
 
429
ALIGN="center"
 
430
VALIGN="top"
 
431
><A
 
432
HREF="admin.html"
 
433
ACCESSKEY="U"
 
434
>Up</A
 
435
></TD
 
436
><TD
 
437
WIDTH="33%"
 
438
ALIGN="right"
 
439
VALIGN="top"
 
440
>Setting Parameters</TD
 
441
></TR
 
442
></TABLE
 
443
></DIV
 
444
></BODY
 
445
></HTML
 
446
>
 
 
b'\\ No newline at end of file'