I686LINUX/util/I686LINUX/doc/postgresql/html/manage-ag-config.html

   1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
   2 <HTML
   3 ><HEAD
   4 ><TITLE
   5 >Database Configuration</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="Managing Databases"
  16 HREF="managing-databases.html"><LINK
  17 REL="PREVIOUS"
  18 TITLE="Template Databases"
  19 HREF="manage-ag-templatedbs.html"><LINK
  20 REL="NEXT"
  21 TITLE="Alternative Locations"
  22 HREF="manage-ag-alternate-locs.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="manage-ag-templatedbs.html"
  52 ACCESSKEY="P"
  53 >Prev</A
  54 ></TD
  55 ><TD
  56 WIDTH="10%"
  57 ALIGN="left"
  58 VALIGN="top"
  59 ><A
  60 HREF="managing-databases.html"
  61 >Fast Backward</A
  62 ></TD
  63 ><TD
  64 WIDTH="60%"
  65 ALIGN="center"
  66 VALIGN="bottom"
  67 >Chapter 18. Managing Databases</TD
  68 ><TD
  69 WIDTH="10%"
  70 ALIGN="right"
  71 VALIGN="top"
  72 ><A
  73 HREF="managing-databases.html"
  74 >Fast Forward</A
  75 ></TD
  76 ><TD
  77 WIDTH="10%"
  78 ALIGN="right"
  79 VALIGN="top"
  80 ><A
  81 HREF="manage-ag-alternate-locs.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="MANAGE-AG-CONFIG"
  96 >18.4. Database Configuration</A
  97 ></H1
  98 ><P
  99 >   Recall from <A
 100 HREF="runtime-config.html"
 101 >Section 16.4</A
 102 > that the
 103    <SPAN
 104 CLASS="PRODUCTNAME"
 105 >PostgreSQL</SPAN
 106 > server provides a large number of
 107    run-time configuration variables.  You can set database-specific
 108    default values for many of these settings.
 109   </P
 110 ><P
 111 >   For example, if for some reason you want to disable the
 112    <ACRONYM
 113 CLASS="ACRONYM"
 114 >GEQO</ACRONYM
 115 > optimizer for a given database, you'd
 116    ordinarily have to either disable it for all databases or make sure
 117    that every connecting client is careful to issue <TT
 118 CLASS="LITERAL"
 119 >SET geqo
 120    TO off;</TT
 121 >.  To make this setting the default you can
 122    execute the command
 123 </P><PRE
 124 CLASS="PROGRAMLISTING"
 125 >ALTER DATABASE mydb SET geqo TO off;</PRE
 126 ><P>
 127    This will save the setting (but not set it immediately) and in
 128    subsequent connections it will appear as though <TT
 129 CLASS="LITERAL"
 130 >SET geqo
 131    TO off;</TT
 132 > had been called right before the session started.
 133    Note that users can still alter this setting during the session; it
 134    will only be the default.  To undo any such setting, use
 135    <TT
 136 CLASS="LITERAL"
 137 >ALTER DATABASE <VAR
 138 CLASS="REPLACEABLE"
 139 >dbname</VAR
 140 > RESET
 141    <VAR
 142 CLASS="REPLACEABLE"
 143 >varname</VAR
 144 >;</TT
 145 >.
 146   </P
 147 ></DIV
 148 ><DIV
 149 CLASS="NAVFOOTER"
 150 ><HR
 151 ALIGN="LEFT"
 152 WIDTH="100%"><TABLE
 153 SUMMARY="Footer navigation table"
 154 WIDTH="100%"
 155 BORDER="0"
 156 CELLPADDING="0"
 157 CELLSPACING="0"
 158 ><TR
 159 ><TD
 160 WIDTH="33%"
 161 ALIGN="left"
 162 VALIGN="top"
 163 ><A
 164 HREF="manage-ag-templatedbs.html"
 165 ACCESSKEY="P"
 166 >Prev</A
 167 ></TD
 168 ><TD
 169 WIDTH="34%"
 170 ALIGN="center"
 171 VALIGN="top"
 172 ><A
 173 HREF="index.html"
 174 ACCESSKEY="H"
 175 >Home</A
 176 ></TD
 177 ><TD
 178 WIDTH="33%"
 179 ALIGN="right"
 180 VALIGN="top"
 181 ><A
 182 HREF="manage-ag-alternate-locs.html"
 183 ACCESSKEY="N"
 184 >Next</A
 185 ></TD
 186 ></TR
 187 ><TR
 188 ><TD
 189 WIDTH="33%"
 190 ALIGN="left"
 191 VALIGN="top"
 192 >Template Databases</TD
 193 ><TD
 194 WIDTH="34%"
 195 ALIGN="center"
 196 VALIGN="top"
 197 ><A
 198 HREF="managing-databases.html"
 199 ACCESSKEY="U"
 200 >Up</A
 201 ></TD
 202 ><TD
 203 WIDTH="33%"
 204 ALIGN="right"
 205 VALIGN="top"
 206 >Alternative Locations</TD
 207 ></TR
 208 ></TABLE
 209 ></DIV
 210 ></BODY
 211 ></HTML
 212 >