I686LINUX/util/I686LINUX/doc/postgresql/html/runtime.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >Server Run-time Environment</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="UP"
  15 TITLE="Server Administration"
  16 HREF="admin.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="Installation on Windows"
  19 HREF="install-win32.html"><LINK
  20 REL="NEXT"
  21 TITLE="Creating a Database Cluster"
  22 HREF="creating-cluster.html"><LINK
  23 REL="STYLESHEET"
  24 TYPE="text/css"
  25 HREF="stylesheet.css"><META
  26 NAME="creation"
  27 CONTENT="2003-12-22T03:48:47"></HEAD
  28 ><BODY
  29 CLASS="CHAPTER"
  30 ><DIV
  31 CLASS="NAVHEADER"
  32 ><TABLE
  33 SUMMARY="Header navigation table"
  34 WIDTH="100%"
  35 BORDER="0"
  36 CELLPADDING="0"
  37 CELLSPACING="0"
  38 ><TR
  39 ><TH
  40 COLSPAN="5"
  41 ALIGN="center"
  42 VALIGN="bottom"
  43 >PostgreSQL 7.4.1 Documentation</TH
  44 ></TR
  45 ><TR
  46 ><TD
  47 WIDTH="10%"
  48 ALIGN="left"
  49 VALIGN="top"
  50 ><A
  51 HREF="install-win32.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="install-win32.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 ></TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="user-manag.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="creating-cluster.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><DIV
  91 CLASS="CHAPTER"
  92 ><H1
  93 ><A
  94 NAME="RUNTIME"
  95 ></A
  96 >Chapter 16. Server Run-time Environment</H1
  97 ><DIV
  98 CLASS="TOC"
  99 ><DL
 100 ><DT
 101 ><B
 102 >Table of Contents</B
 103 ></DT
 104 ><DT
 105 >16.1. <A
 106 HREF="runtime.html#POSTGRES-USER"
 107 >The <SPAN
 108 CLASS="PRODUCTNAME"
 109 >PostgreSQL</SPAN
 110 > User Account</A
 111 ></DT
 112 ><DT
 113 >16.2. <A
 114 HREF="creating-cluster.html"
 115 >Creating a Database Cluster</A
 116 ></DT
 117 ><DT
 118 >16.3. <A
 119 HREF="postmaster-start.html"
 120 >Starting the Database Server</A
 121 ></DT
 122 ><DD
 123 ><DL
 124 ><DT
 125 >16.3.1. <A
 126 HREF="postmaster-start.html#POSTMASTER-START-FAILURES"
 127 >Server Start-up Failures</A
 128 ></DT
 129 ><DT
 130 >16.3.2. <A
 131 HREF="postmaster-start.html#CLIENT-CONNECTION-PROBLEMS"
 132 >Client Connection Problems</A
 133 ></DT
 134 ></DL
 135 ></DD
 136 ><DT
 137 >16.4. <A
 138 HREF="runtime-config.html"
 139 >Run-time Configuration</A
 140 ></DT
 141 ><DD
 142 ><DL
 143 ><DT
 144 >16.4.1. <A
 145 HREF="runtime-config.html#RUNTIME-CONFIG-CONNECTION"
 146 >Connections and Authentication</A
 147 ></DT
 148 ><DT
 149 >16.4.2. <A
 150 HREF="runtime-config.html#RUNTIME-CONFIG-RESOURCE"
 151 >Resource Consumption</A
 152 ></DT
 153 ><DT
 154 >16.4.3. <A
 155 HREF="runtime-config.html#RUNTIME-CONFIG-WAL"
 156 >Write Ahead Log</A
 157 ></DT
 158 ><DT
 159 >16.4.4. <A
 160 HREF="runtime-config.html#RUNTIME-CONFIG-QUERY"
 161 >Query Planning</A
 162 ></DT
 163 ><DT
 164 >16.4.5. <A
 165 HREF="runtime-config.html#RUNTIME-CONFIG-LOGGING"
 166 >Error Reporting and Logging</A
 167 ></DT
 168 ><DT
 169 >16.4.6. <A
 170 HREF="runtime-config.html#RUNTIME-CONFIG-STATISTICS"
 171 >Runtime Statistics</A
 172 ></DT
 173 ><DT
 174 >16.4.7. <A
 175 HREF="runtime-config.html#RUNTIME-CONFIG-CLIENT"
 176 >Client Connection Defaults</A
 177 ></DT
 178 ><DT
 179 >16.4.8. <A
 180 HREF="runtime-config.html#RUNTIME-CONFIG-LOCKS"
 181 >Lock Management</A
 182 ></DT
 183 ><DT
 184 >16.4.9. <A
 185 HREF="runtime-config.html#RUNTIME-CONFIG-COMPATIBLE"
 186 >Version and Platform Compatibility</A
 187 ></DT
 188 ><DT
 189 >16.4.10. <A
 190 HREF="runtime-config.html#RUNTIME-CONFIG-DEVELOPER"
 191 >Developer Options</A
 192 ></DT
 193 ><DT
 194 >16.4.11. <A
 195 HREF="runtime-config.html#RUNTIME-CONFIG-SHORT"
 196 >Short Options</A
 197 ></DT
 198 ></DL
 199 ></DD
 200 ><DT
 201 >16.5. <A
 202 HREF="kernel-resources.html"
 203 >Managing Kernel Resources</A
 204 ></DT
 205 ><DD
 206 ><DL
 207 ><DT
 208 >16.5.1. <A
 209 HREF="kernel-resources.html#SYSVIPC"
 210 >Shared Memory and Semaphores</A
 211 ></DT
 212 ><DT
 213 >16.5.2. <A
 214 HREF="kernel-resources.html#AEN17040"
 215 >Resource Limits</A
 216 ></DT
 217 ><DT
 218 >16.5.3. <A
 219 HREF="kernel-resources.html#AEN17072"
 220 >Linux Memory Overcommit</A
 221 ></DT
 222 ></DL
 223 ></DD
 224 ><DT
 225 >16.6. <A
 226 HREF="postmaster-shutdown.html"
 227 >Shutting Down the Server</A
 228 ></DT
 229 ><DT
 230 >16.7. <A
 231 HREF="ssl-tcp.html"
 232 >Secure TCP/IP Connections with SSL</A
 233 ></DT
 234 ><DT
 235 >16.8. <A
 236 HREF="ssh-tunnels.html"
 237 >Secure TCP/IP Connections with <SPAN
 238 CLASS="APPLICATION"
 239 >SSH</SPAN
 240 > Tunnels</A
 241 ></DT
 242 ></DL
 243 ></DIV
 244 ><P
 245 >  This chapter discusses how to set up and run the database server
 246   and the interactions with the operating system.
 247  </P
 248 ><DIV
 249 CLASS="SECT1"
 250 ><H1
 251 CLASS="SECT1"
 252 ><A
 253 NAME="POSTGRES-USER"
 254 >16.1. The <SPAN
 255 CLASS="PRODUCTNAME"
 256 >PostgreSQL</SPAN
 257 > User Account</A
 258 ></H1
 259 ><A
 260 NAME="AEN15166"
 261 ></A
 262 ><P
 263 >   As with any other server daemon that is connected to outside world,
 264    it is advisable to run <SPAN
 265 CLASS="PRODUCTNAME"
 266 >PostgreSQL</SPAN
 267 > under a
 268    separate user account. This user account should only own the data
 269    that is managed by the server, and should not be shared with other
 270    daemons. (For example, using the user <TT
 271 CLASS="LITERAL"
 272 >nobody</TT
 273 > is a bad
 274    idea.) It is not advisable to install executables owned by
 275    this user because compromised systems could then modify their own
 276    binaries.
 277   </P
 278 ><P
 279 >   To add a Unix user account to your system, look for a command
 280    <TT
 281 CLASS="COMMAND"
 282 >useradd</TT
 283 > or <TT
 284 CLASS="COMMAND"
 285 >adduser</TT
 286 >. The user
 287    name <SPAN
 288 CLASS="SYSTEMITEM"
 289 >postgres</SPAN
 290 > is often used but is by no
 291    means required.
 292   </P
 293 ></DIV
 294 ></DIV
 295 ><DIV
 296 CLASS="NAVFOOTER"
 297 ><HR
 298 ALIGN="LEFT"
 299 WIDTH="100%"><TABLE
 300 SUMMARY="Footer navigation table"
 301 WIDTH="100%"
 302 BORDER="0"
 303 CELLPADDING="0"
 304 CELLSPACING="0"
 305 ><TR
 306 ><TD
 307 WIDTH="33%"
 308 ALIGN="left"
 309 VALIGN="top"
 310 ><A
 311 HREF="install-win32.html"
 312 ACCESSKEY="P"
 313 >Prev</A
 314 ></TD
 315 ><TD
 316 WIDTH="34%"
 317 ALIGN="center"
 318 VALIGN="top"
 319 ><A
 320 HREF="index.html"
 321 ACCESSKEY="H"
 322 >Home</A
 323 ></TD
 324 ><TD
 325 WIDTH="33%"
 326 ALIGN="right"
 327 VALIGN="top"
 328 ><A
 329 HREF="creating-cluster.html"
 330 ACCESSKEY="N"
 331 >Next</A
 332 ></TD
 333 ></TR
 334 ><TR
 335 ><TD
 336 WIDTH="33%"
 337 ALIGN="left"
 338 VALIGN="top"
 339 >Installation on <SPAN
 340 CLASS="PRODUCTNAME"
 341 >Windows</SPAN
 342 ></TD
 343 ><TD
 344 WIDTH="34%"
 345 ALIGN="center"
 346 VALIGN="top"
 347 ><A
 348 HREF="admin.html"
 349 ACCESSKEY="U"
 350 >Up</A
 351 ></TD
 352 ><TD
 353 WIDTH="33%"
 354 ALIGN="right"
 355 VALIGN="top"
 356 >Creating a Database Cluster</TD
 357 ></TR
 358 ></TABLE
 359 ></DIV
 360 ></BODY
 361 ></HTML
 362 >