I386LINUX/util/I386LINUX/doc/postgresql/html/disk-full.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >Disk Full Failure</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="Monitoring Disk Usage"
  16 HREF="diskusage.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="Monitoring Disk Usage"
  19 HREF="diskusage.html"><LINK
  20 REL="NEXT"
  21 TITLE="Write-Ahead Logging (WAL)"
  22 HREF="wal.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="SECT1"
  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="diskusage.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="diskusage.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 24. Monitoring Disk Usage</TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="diskusage.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="wal.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="SECT1"
  92 ><H1
  93 CLASS="SECT1"
  94 ><A
  95 NAME="DISK-FULL"
  96 >24.2. Disk Full Failure</A
  97 ></H1
  98 ><P
  99 >   The most important disk monitoring task of a database administrator
 100    is to make sure the disk doesn't grow full.  A filled data disk may
 101    result in subsequent corruption of database indexes, but not of the
 102    tables themselves. If the WAL files are on the same disk (as
 103    is the case for a default configuration) then a filled disk during
 104    database initialization may result in corrupted or incomplete WAL
 105    files. This failure condition is detected and the database server
 106    will refuse to start up.
 107   </P
 108 ><P
 109 >   If you cannot free up additional space on the disk by deleting
 110    other things you can move some of the database files to other file
 111    systems and create a symlink from the original location.  But
 112    note that <SPAN
 113 CLASS="APPLICATION"
 114 >pg_dump</SPAN
 115 > cannot save the location layout
 116    information of such a setup; a restore would put everything back in
 117    one place.  To avoid running out of disk space, you can place the
 118    WAL files or individual databases in other locations while creating
 119    them.  See the <TT
 120 CLASS="COMMAND"
 121 >initdb</TT
 122 > documentation and <A
 123 HREF="manage-ag-alternate-locs.html"
 124 >Section 18.5</A
 125 > for more information about that.
 126   </P
 127 ><DIV
 128 CLASS="TIP"
 129 ><BLOCKQUOTE
 130 CLASS="TIP"
 131 ><P
 132 ><B
 133 >Tip: </B
 134 >    Some file systems perform badly when they are almost full, so do
 135     not wait until the disk is full to take action.
 136    </P
 137 ></BLOCKQUOTE
 138 ></DIV
 139 ></DIV
 140 ><DIV
 141 CLASS="NAVFOOTER"
 142 ><HR
 143 ALIGN="LEFT"
 144 WIDTH="100%"><TABLE
 145 SUMMARY="Footer navigation table"
 146 WIDTH="100%"
 147 BORDER="0"
 148 CELLPADDING="0"
 149 CELLSPACING="0"
 150 ><TR
 151 ><TD
 152 WIDTH="33%"
 153 ALIGN="left"
 154 VALIGN="top"
 155 ><A
 156 HREF="diskusage.html"
 157 ACCESSKEY="P"
 158 >Prev</A
 159 ></TD
 160 ><TD
 161 WIDTH="34%"
 162 ALIGN="center"
 163 VALIGN="top"
 164 ><A
 165 HREF="index.html"
 166 ACCESSKEY="H"
 167 >Home</A
 168 ></TD
 169 ><TD
 170 WIDTH="33%"
 171 ALIGN="right"
 172 VALIGN="top"
 173 ><A
 174 HREF="wal.html"
 175 ACCESSKEY="N"
 176 >Next</A
 177 ></TD
 178 ></TR
 179 ><TR
 180 ><TD
 181 WIDTH="33%"
 182 ALIGN="left"
 183 VALIGN="top"
 184 >Monitoring Disk Usage</TD
 185 ><TD
 186 WIDTH="34%"
 187 ALIGN="center"
 188 VALIGN="top"
 189 ><A
 190 HREF="diskusage.html"
 191 ACCESSKEY="U"
 192 >Up</A
 193 ></TD
 194 ><TD
 195 WIDTH="33%"
 196 ALIGN="right"
 197 VALIGN="top"
 198 >Write-Ahead Logging (<ACRONYM
 199 CLASS="ACRONYM"
 200 >WAL</ACRONYM
 201 >)</TD
 202 ></TR
 203 ></TABLE
 204 ></DIV
 205 ></BODY
 206 ></HTML
 207 >