I386LINUX/util/I386LINUX/doc/postgresql/html/app-ipcclean.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >ipcclean</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="PostgreSQL Server Applications"
  16 HREF="reference-server.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="initlocation"
  19 HREF="app-initlocation.html"><LINK
  20 REL="NEXT"
  21 TITLE="pg_controldata"
  22 HREF="app-pgcontroldata.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="REFENTRY"
  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="app-initlocation.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="app-initlocation.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="app-pgcontroldata.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="app-pgcontroldata.html"
  82 ACCESSKEY="N"
  83 >Next</A
  84 ></TD
  85 ></TR
  86 ></TABLE
  87 ><HR
  88 ALIGN="LEFT"
  89 WIDTH="100%"></DIV
  90 ><H1
  91 ><A
  92 NAME="APP-IPCCLEAN"
  93 ></A
  94 ><SPAN
  95 CLASS="APPLICATION"
  96 >ipcclean</SPAN
  97 ></H1
  98 ><DIV
  99 CLASS="REFNAMEDIV"
 100 ><A
 101 NAME="AEN47397"
 102 ></A
 103 ><H2
 104 >Name</H2
 105 >ipcclean&nbsp;--&nbsp;remove shared memory and semaphores from an aborted <SPAN
 106 CLASS="PRODUCTNAME"
 107 >PostgreSQL</SPAN
 108 > server</DIV
 109 ><A
 110 NAME="AEN47401"
 111 ></A
 112 ><DIV
 113 CLASS="REFSYNOPSISDIV"
 114 ><A
 115 NAME="AEN47403"
 116 ></A
 117 ><H2
 118 >Synopsis</H2
 119 ><P
 120 ><TT
 121 CLASS="COMMAND"
 122 >ipcclean</TT
 123 ></P
 124 ></DIV
 125 ><DIV
 126 CLASS="REFSECT1"
 127 ><A
 128 NAME="R1-APP-IPCCLEAN-1"
 129 ></A
 130 ><H2
 131 >Description</H2
 132 ><P
 133 >   <TT
 134 CLASS="COMMAND"
 135 >ipcclean</TT
 136 > removes all shared memory segments and
 137    semaphore sets owned by the current user.  It is intended to be
 138    used for cleaning up after a crashed
 139    <SPAN
 140 CLASS="PRODUCTNAME"
 141 >PostgreSQL</SPAN
 142 > server (<A
 143 HREF="app-postmaster.html"
 144 ><SPAN
 145 CLASS="APPLICATION"
 146 >postmaster</SPAN
 147 ></A
 148 >).  Note that immediately restarting the
 149    server will also clean up shared memory and semaphores, so this
 150    command is of little real utility.
 151   </P
 152 ><P
 153 >   Only the database administrator should execute this program as it
 154    can cause bizarre behavior (i.e., crashes) if run during multiuser
 155    execution.  If this command is executed while a server is running,
 156    the shared memory and semaphores allocated by that server will be
 157    deleted, which would have rather severe consequences for that
 158    server.
 159   </P
 160 ></DIV
 161 ><DIV
 162 CLASS="REFSECT1"
 163 ><A
 164 NAME="AEN47413"
 165 ></A
 166 ><H2
 167 >Notes</H2
 168 ><P
 169 >   This script is a hack, but in the many years since it was written,
 170    no one has come up with an equally effective and portable solution.
 171    Since the <TT
 172 CLASS="COMMAND"
 173 >postmaster</TT
 174 > can now clean up by
 175    itself, it is unlikely that <TT
 176 CLASS="COMMAND"
 177 >ipcclean</TT
 178 > will be
 179    improved upon in the future.
 180   </P
 181 ><P
 182 >   The script makes assumption about the format of output of the
 183    <TT
 184 CLASS="COMMAND"
 185 >ipcs</TT
 186 >
 187    utility which may not be true across different operating systems.
 188    Therefore, it may not work on your particular OS.
 189   </P
 190 ></DIV
 191 ><DIV
 192 CLASS="NAVFOOTER"
 193 ><HR
 194 ALIGN="LEFT"
 195 WIDTH="100%"><TABLE
 196 SUMMARY="Footer navigation table"
 197 WIDTH="100%"
 198 BORDER="0"
 199 CELLPADDING="0"
 200 CELLSPACING="0"
 201 ><TR
 202 ><TD
 203 WIDTH="33%"
 204 ALIGN="left"
 205 VALIGN="top"
 206 ><A
 207 HREF="app-initlocation.html"
 208 ACCESSKEY="P"
 209 >Prev</A
 210 ></TD
 211 ><TD
 212 WIDTH="34%"
 213 ALIGN="center"
 214 VALIGN="top"
 215 ><A
 216 HREF="index.html"
 217 ACCESSKEY="H"
 218 >Home</A
 219 ></TD
 220 ><TD
 221 WIDTH="33%"
 222 ALIGN="right"
 223 VALIGN="top"
 224 ><A
 225 HREF="app-pgcontroldata.html"
 226 ACCESSKEY="N"
 227 >Next</A
 228 ></TD
 229 ></TR
 230 ><TR
 231 ><TD
 232 WIDTH="33%"
 233 ALIGN="left"
 234 VALIGN="top"
 235 ><SPAN
 236 CLASS="APPLICATION"
 237 >initlocation</SPAN
 238 ></TD
 239 ><TD
 240 WIDTH="34%"
 241 ALIGN="center"
 242 VALIGN="top"
 243 ><A
 244 HREF="reference-server.html"
 245 ACCESSKEY="U"
 246 >Up</A
 247 ></TD
 248 ><TD
 249 WIDTH="33%"
 250 ALIGN="right"
 251 VALIGN="top"
 252 ><SPAN
 253 CLASS="APPLICATION"
 254 >pg_controldata</SPAN
 255 ></TD
 256 ></TR
 257 ></TABLE
 258 ></DIV
 259 ></BODY
 260 ></HTML
 261 >