I686LINUX/util/I686LINUX/doc/postgresql/html/admin.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >Server Administration</TITLE
   6 ><META
   7 NAME="GENERATOR"
   8 CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK
   9 REV="MADE"
  10 HREF="mailto:pgsql-docs@postgresql.org"><LINK
  11 REL="HOME"
  12 TITLE="PostgreSQL 7.4.1 Documentation"
  13 HREF="index.html"><LINK
  14 REL="PREVIOUS"
  15 TITLE="Populating a Database"
  16 HREF="populate.html"><LINK
  17 REL="NEXT"
  18 TITLE="  Installation Instructions"
  19 HREF="installation.html"><LINK
  20 REL="STYLESHEET"
  21 TYPE="text/css"
  22 HREF="stylesheet.css"><META
  23 NAME="creation"
  24 CONTENT="2003-12-22T03:48:47"></HEAD
  25 ><BODY
  26 CLASS="PART"
  27 ><DIV
  28 CLASS="NAVHEADER"
  29 ><TABLE
  30 SUMMARY="Header navigation table"
  31 WIDTH="100%"
  32 BORDER="0"
  33 CELLPADDING="0"
  34 CELLSPACING="0"
  35 ><TR
  36 ><TH
  37 COLSPAN="5"
  38 ALIGN="center"
  39 VALIGN="bottom"
  40 >PostgreSQL 7.4.1 Documentation</TH
  41 ></TR
  42 ><TR
  43 ><TD
  44 WIDTH="10%"
  45 ALIGN="left"
  46 VALIGN="top"
  47 ><A
  48 HREF="populate.html"
  49 ACCESSKEY="P"
  50 >Prev</A
  51 ></TD
  52 ><TD
  53 WIDTH="10%"
  54 ALIGN="left"
  55 VALIGN="top"
  56 ><A
  57 HREF="sql.html"
  58 >Fast Backward</A
  59 ></TD
  60 ><TD
  61 WIDTH="60%"
  62 ALIGN="center"
  63 VALIGN="bottom"
  64 ></TD
  65 ><TD
  66 WIDTH="10%"
  67 ALIGN="right"
  68 VALIGN="top"
  69 ><A
  70 HREF="client-interfaces.html"
  71 >Fast Forward</A
  72 ></TD
  73 ><TD
  74 WIDTH="10%"
  75 ALIGN="right"
  76 VALIGN="top"
  77 ><A
  78 HREF="installation.html"
  79 ACCESSKEY="N"
  80 >Next</A
  81 ></TD
  82 ></TR
  83 ></TABLE
  84 ><HR
  85 ALIGN="LEFT"
  86 WIDTH="100%"></DIV
  87 ><DIV
  88 CLASS="PART"
  89 ><A
  90 NAME="ADMIN"
  91 ></A
  92 ><DIV
  93 CLASS="TITLEPAGE"
  94 ><H1
  95 CLASS="TITLE"
  96 >III. Server Administration</H1
  97 ><DIV
  98 CLASS="PARTINTRO"
  99 ><A
 100 NAME="AEN13984"
 101 ></A
 102 ><P
 103 >    This part covers topics that are of interest to a
 104     <SPAN
 105 CLASS="PRODUCTNAME"
 106 >PostgreSQL</SPAN
 107 > database administrator.  This includes
 108     installation of the software, set up and configuration of the
 109     server, management of users and databases, and maintenance tasks.
 110     Anyone who runs a <SPAN
 111 CLASS="PRODUCTNAME"
 112 >PostgreSQL</SPAN
 113 > server, either for
 114     personal use, but especially in production, should be familiar
 115     with the topics covered in this part.
 116    </P
 117 ><P
 118 >    The information in this part is arranged approximately in the
 119     order in which a new user should read it.  But the chapters are
 120     self-contained and can be read individually as desired.  The
 121     information in this part is presented in a narrative fashion in
 122     topical units.  Readers looking for a complete description of a
 123     particular command should look into <A
 124 HREF="reference.html"
 125 >Part VI</A
 126 >.
 127    </P
 128 ><P
 129 >    The first few chapters are written so that they can be understood
 130     without prerequisite knowledge, so that new users who need to set
 131     up their own server can begin their exploration with this part.
 132     The rest of this part which is about tuning and management
 133     presupposes that the reader is familiar with the general use of
 134     the <SPAN
 135 CLASS="PRODUCTNAME"
 136 >PostgreSQL</SPAN
 137 > database system.  Readers are
 138     encouraged to look at <A
 139 HREF="tutorial.html"
 140 >Part I</A
 141 > and <A
 142 HREF="sql.html"
 143 >Part II</A
 144 > for additional information.
 145    </P
 146 ></DIV
 147 ><DIV
 148 CLASS="TOC"
 149 ><DL
 150 ><DT
 151 ><B
 152 >Table of Contents</B
 153 ></DT
 154 ><DT
 155 >14. <A
 156 HREF="installation.html"
 157 >Installation Instructions</A
 158 ></DT
 159 ><DD
 160 ><DL
 161 ><DT
 162 >14.1. <A
 163 HREF="installation.html#INSTALL-SHORT"
 164 >Short Version</A
 165 ></DT
 166 ><DT
 167 >14.2. <A
 168 HREF="install-requirements.html"
 169 >Requirements</A
 170 ></DT
 171 ><DT
 172 >14.3. <A
 173 HREF="install-getsource.html"
 174 >Getting The Source</A
 175 ></DT
 176 ><DT
 177 >14.4. <A
 178 HREF="install-upgrading.html"
 179 >If You Are Upgrading</A
 180 ></DT
 181 ><DT
 182 >14.5. <A
 183 HREF="install-procedure.html"
 184 >Installation Procedure</A
 185 ></DT
 186 ><DT
 187 >14.6. <A
 188 HREF="install-post.html"
 189 >Post-Installation Setup</A
 190 ></DT
 191 ><DT
 192 >14.7. <A
 193 HREF="supported-platforms.html"
 194 >Supported Platforms</A
 195 ></DT
 196 ></DL
 197 ></DD
 198 ><DT
 199 >15. <A
 200 HREF="install-win32.html"
 201 >Installation on <SPAN
 202 CLASS="PRODUCTNAME"
 203 >Windows</SPAN
 204 ></A
 205 ></DT
 206 ><DT
 207 >16. <A
 208 HREF="runtime.html"
 209 >Server Run-time Environment</A
 210 ></DT
 211 ><DD
 212 ><DL
 213 ><DT
 214 >16.1. <A
 215 HREF="runtime.html#POSTGRES-USER"
 216 >The <SPAN
 217 CLASS="PRODUCTNAME"
 218 >PostgreSQL</SPAN
 219 > User Account</A
 220 ></DT
 221 ><DT
 222 >16.2. <A
 223 HREF="creating-cluster.html"
 224 >Creating a Database Cluster</A
 225 ></DT
 226 ><DT
 227 >16.3. <A
 228 HREF="postmaster-start.html"
 229 >Starting the Database Server</A
 230 ></DT
 231 ><DT
 232 >16.4. <A
 233 HREF="runtime-config.html"
 234 >Run-time Configuration</A
 235 ></DT
 236 ><DT
 237 >16.5. <A
 238 HREF="kernel-resources.html"
 239 >Managing Kernel Resources</A
 240 ></DT
 241 ><DT
 242 >16.6. <A
 243 HREF="postmaster-shutdown.html"
 244 >Shutting Down the Server</A
 245 ></DT
 246 ><DT
 247 >16.7. <A
 248 HREF="ssl-tcp.html"
 249 >Secure TCP/IP Connections with SSL</A
 250 ></DT
 251 ><DT
 252 >16.8. <A
 253 HREF="ssh-tunnels.html"
 254 >Secure TCP/IP Connections with <SPAN
 255 CLASS="APPLICATION"
 256 >SSH</SPAN
 257 > Tunnels</A
 258 ></DT
 259 ></DL
 260 ></DD
 261 ><DT
 262 >17. <A
 263 HREF="user-manag.html"
 264 >Database Users and Privileges</A
 265 ></DT
 266 ><DD
 267 ><DL
 268 ><DT
 269 >17.1. <A
 270 HREF="user-manag.html#DATABASE-USERS"
 271 >Database Users</A
 272 ></DT
 273 ><DT
 274 >17.2. <A
 275 HREF="user-attributes.html"
 276 >User Attributes</A
 277 ></DT
 278 ><DT
 279 >17.3. <A
 280 HREF="groups.html"
 281 >Groups</A
 282 ></DT
 283 ><DT
 284 >17.4. <A
 285 HREF="privileges.html"
 286 >Privileges</A
 287 ></DT
 288 ><DT
 289 >17.5. <A
 290 HREF="perm-functions.html"
 291 >Functions and Triggers</A
 292 ></DT
 293 ></DL
 294 ></DD
 295 ><DT
 296 >18. <A
 297 HREF="managing-databases.html"
 298 >Managing Databases</A
 299 ></DT
 300 ><DD
 301 ><DL
 302 ><DT
 303 >18.1. <A
 304 HREF="managing-databases.html#MANAGE-AG-OVERVIEW"
 305 >Overview</A
 306 ></DT
 307 ><DT
 308 >18.2. <A
 309 HREF="manage-ag-createdb.html"
 310 >Creating a Database</A
 311 ></DT
 312 ><DT
 313 >18.3. <A
 314 HREF="manage-ag-templatedbs.html"
 315 >Template Databases</A
 316 ></DT
 317 ><DT
 318 >18.4. <A
 319 HREF="manage-ag-config.html"
 320 >Database Configuration</A
 321 ></DT
 322 ><DT
 323 >18.5. <A
 324 HREF="manage-ag-alternate-locs.html"
 325 >Alternative Locations</A
 326 ></DT
 327 ><DT
 328 >18.6. <A
 329 HREF="manage-ag-dropdb.html"
 330 >Destroying a Database</A
 331 ></DT
 332 ></DL
 333 ></DD
 334 ><DT
 335 >19. <A
 336 HREF="client-authentication.html"
 337 >Client Authentication</A
 338 ></DT
 339 ><DD
 340 ><DL
 341 ><DT
 342 >19.1. <A
 343 HREF="client-authentication.html#AUTH-PG-HBA-CONF"
 344 >The <TT
 345 CLASS="FILENAME"
 346 >pg_hba.conf</TT
 347 > file</A
 348 ></DT
 349 ><DT
 350 >19.2. <A
 351 HREF="auth-methods.html"
 352 >Authentication methods</A
 353 ></DT
 354 ><DT
 355 >19.3. <A
 356 HREF="client-authentication-problems.html"
 357 >Authentication problems</A
 358 ></DT
 359 ></DL
 360 ></DD
 361 ><DT
 362 >20. <A
 363 HREF="charset.html"
 364 >Localization</A
 365 ></DT
 366 ><DD
 367 ><DL
 368 ><DT
 369 >20.1. <A
 370 HREF="charset.html#LOCALE"
 371 >Locale Support</A
 372 ></DT
 373 ><DT
 374 >20.2. <A
 375 HREF="multibyte.html"
 376 >Character Set Support</A
 377 ></DT
 378 ></DL
 379 ></DD
 380 ><DT
 381 >21. <A
 382 HREF="maintenance.html"
 383 >Routine Database Maintenance Tasks</A
 384 ></DT
 385 ><DD
 386 ><DL
 387 ><DT
 388 >21.1. <A
 389 HREF="maintenance.html#ROUTINE-VACUUMING"
 390 >Routine Vacuuming</A
 391 ></DT
 392 ><DT
 393 >21.2. <A
 394 HREF="routine-reindex.html"
 395 >Routine Reindexing</A
 396 ></DT
 397 ><DT
 398 >21.3. <A
 399 HREF="logfile-maintenance.html"
 400 >Log File Maintenance</A
 401 ></DT
 402 ></DL
 403 ></DD
 404 ><DT
 405 >22. <A
 406 HREF="backup.html"
 407 >Backup and Restore</A
 408 ></DT
 409 ><DD
 410 ><DL
 411 ><DT
 412 >22.1. <A
 413 HREF="backup.html#BACKUP-DUMP"
 414 ><ACRONYM
 415 CLASS="ACRONYM"
 416 >SQL</ACRONYM
 417 > Dump</A
 418 ></DT
 419 ><DT
 420 >22.2. <A
 421 HREF="backup-file.html"
 422 >File system level backup</A
 423 ></DT
 424 ><DT
 425 >22.3. <A
 426 HREF="migration.html"
 427 >Migration Between Releases</A
 428 ></DT
 429 ></DL
 430 ></DD
 431 ><DT
 432 >23. <A
 433 HREF="monitoring.html"
 434 >Monitoring Database Activity</A
 435 ></DT
 436 ><DD
 437 ><DL
 438 ><DT
 439 >23.1. <A
 440 HREF="monitoring.html#MONITORING-PS"
 441 >Standard Unix Tools</A
 442 ></DT
 443 ><DT
 444 >23.2. <A
 445 HREF="monitoring-stats.html"
 446 >The Statistics Collector</A
 447 ></DT
 448 ><DT
 449 >23.3. <A
 450 HREF="monitoring-locks.html"
 451 >Viewing Locks</A
 452 ></DT
 453 ></DL
 454 ></DD
 455 ><DT
 456 >24. <A
 457 HREF="diskusage.html"
 458 >Monitoring Disk Usage</A
 459 ></DT
 460 ><DD
 461 ><DL
 462 ><DT
 463 >24.1. <A
 464 HREF="diskusage.html#DISK-USAGE"
 465 >Determining Disk Usage</A
 466 ></DT
 467 ><DT
 468 >24.2. <A
 469 HREF="disk-full.html"
 470 >Disk Full Failure</A
 471 ></DT
 472 ></DL
 473 ></DD
 474 ><DT
 475 >25. <A
 476 HREF="wal.html"
 477 >Write-Ahead Logging (<ACRONYM
 478 CLASS="ACRONYM"
 479 >WAL</ACRONYM
 480 >)</A
 481 ></DT
 482 ><DD
 483 ><DL
 484 ><DT
 485 >25.1. <A
 486 HREF="wal.html#WAL-BENEFITS-NOW"
 487 >Benefits of <ACRONYM
 488 CLASS="ACRONYM"
 489 >WAL</ACRONYM
 490 ></A
 491 ></DT
 492 ><DT
 493 >25.2. <A
 494 HREF="wal-benefits-later.html"
 495 >Future Benefits</A
 496 ></DT
 497 ><DT
 498 >25.3. <A
 499 HREF="wal-configuration.html"
 500 ><ACRONYM
 501 CLASS="ACRONYM"
 502 >WAL</ACRONYM
 503 > Configuration</A
 504 ></DT
 505 ><DT
 506 >25.4. <A
 507 HREF="wal-internals.html"
 508 >Internals</A
 509 ></DT
 510 ></DL
 511 ></DD
 512 ><DT
 513 >26. <A
 514 HREF="regress.html"
 515 >Regression Tests</A
 516 ></DT
 517 ><DD
 518 ><DL
 519 ><DT
 520 >26.1. <A
 521 HREF="regress.html#REGRESS-RUN"
 522 >Running the Tests</A
 523 ></DT
 524 ><DT
 525 >26.2. <A
 526 HREF="regress-evaluation.html"
 527 >Test Evaluation</A
 528 ></DT
 529 ><DT
 530 >26.3. <A
 531 HREF="regress-platform.html"
 532 >Platform-specific comparison files</A
 533 ></DT
 534 ></DL
 535 ></DD
 536 ></DL
 537 ></DIV
 538 ></DIV
 539 ></DIV
 540 ><DIV
 541 CLASS="NAVFOOTER"
 542 ><HR
 543 ALIGN="LEFT"
 544 WIDTH="100%"><TABLE
 545 SUMMARY="Footer navigation table"
 546 WIDTH="100%"
 547 BORDER="0"
 548 CELLPADDING="0"
 549 CELLSPACING="0"
 550 ><TR
 551 ><TD
 552 WIDTH="33%"
 553 ALIGN="left"
 554 VALIGN="top"
 555 ><A
 556 HREF="populate.html"
 557 ACCESSKEY="P"
 558 >Prev</A
 559 ></TD
 560 ><TD
 561 WIDTH="34%"
 562 ALIGN="center"
 563 VALIGN="top"
 564 ><A
 565 HREF="index.html"
 566 ACCESSKEY="H"
 567 >Home</A
 568 ></TD
 569 ><TD
 570 WIDTH="33%"
 571 ALIGN="right"
 572 VALIGN="top"
 573 ><A
 574 HREF="installation.html"
 575 ACCESSKEY="N"
 576 >Next</A
 577 ></TD
 578 ></TR
 579 ><TR
 580 ><TD
 581 WIDTH="33%"
 582 ALIGN="left"
 583 VALIGN="top"
 584 >Populating a Database</TD
 585 ><TD
 586 WIDTH="34%"
 587 ALIGN="center"
 588 VALIGN="top"
 589 >&nbsp;</TD
 590 ><TD
 591 WIDTH="33%"
 592 ALIGN="right"
 593 VALIGN="top"
 594 >Installation Instructions</TD
 595 ></TR
 596 ></TABLE
 597 ></DIV
 598 ></BODY
 599 ></HTML
 600 >