Permalink
Browse files

Update docs for PG 8.2.23.

  • Loading branch information...
1 parent 7c67865 commit 2f0fc55e80af349456dbb9a7131906c099a23775 @dpage dpage committed Dec 2, 2011
Showing 788 changed files with 12,609 additions and 12,018 deletions.
View
@@ -2,18 +2,18 @@
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Part III. Server Administration</title>
-<link rel="stylesheet" type="text/css" href="stylesheet.css">
+<link rel="stylesheet" href="stylesheet.css" type="text/css">
<link rev="made" href="pgsql-docs@postgresql.org">
-<meta name="generator" content="DocBook XSL Stylesheets V1.76.1">
-<link rel="home" href="index.html" title="PostgreSQL 8.2.21 Documentation">
-<link rel="up" href="index.html" title="PostgreSQL 8.2.21 Documentation">
+<meta name="generator" content="DocBook XSL Stylesheets V1.75.2">
+<link rel="home" href="index.html" title="PostgreSQL 8.2.23 Documentation">
+<link rel="up" href="index.html" title="PostgreSQL 8.2.23 Documentation">
<link rel="prev" href="populate.html" title="13.4. Populating a Database">
<link rel="next" href="installation.html" title="Chapter 14.  Installation Instructions">
<link rel="copyright" href="legalnotice.html" title="Legal Notice">
</head>
<body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="part" title="Part III. Server Administration" id="admin">
<div class="titlepage"><div><div><h1 class="title">Part III. Server Administration</h1></div></div></div>
-<div class="partintro" title="Server Administration" id="id2660702">
+<div class="partintro" title="Server Administration" id="id496032">
<div></div>
<p> This part covers topics that are of interest to a
<span class="productname">PostgreSQL</span> database administrator. This includes
@@ -50,8 +50,8 @@
<dt><span class="sect1"><a href="install-procedure.html">14.5. Installation Procedure</a></span></dt>
<dt><span class="sect1"><a href="install-post.html">14.6. Post-Installation Setup</a></span></dt>
<dd><dl>
-<dt><span class="sect2"><a href="install-post.html#id2663829">14.6.1. Shared Libraries</a></span></dt>
-<dt><span class="sect2"><a href="install-post.html#id2664170">14.6.2. Environment Variables</a></span></dt>
+<dt><span class="sect2"><a href="install-post.html#id498892">14.6.1. Shared Libraries</a></span></dt>
+<dt><span class="sect2"><a href="install-post.html#id499218">14.6.2. Environment Variables</a></span></dt>
</dl></dd>
<dt><span class="sect1"><a href="supported-platforms.html">14.7. Supported Platforms</a></span></dt>
</dl></dd>
@@ -68,8 +68,8 @@
<dt><span class="sect1"><a href="kernel-resources.html">16.4. Managing Kernel Resources</a></span></dt>
<dd><dl>
<dt><span class="sect2"><a href="kernel-resources.html#sysvipc">16.4.1. Shared Memory and Semaphores</a></span></dt>
-<dt><span class="sect2"><a href="kernel-resources.html#id2669922">16.4.2. Resource Limits</a></span></dt>
-<dt><span class="sect2"><a href="kernel-resources.html#id2670107">16.4.3. Linux Memory Overcommit</a></span></dt>
+<dt><span class="sect2"><a href="kernel-resources.html#id504714">16.4.2. Resource Limits</a></span></dt>
+<dt><span class="sect2"><a href="kernel-resources.html#id504872">16.4.3. Linux Memory Overcommit</a></span></dt>
</dl></dd>
<dt><span class="sect1"><a href="server-shutdown.html">16.5. Shutting Down the Server</a></span></dt>
<dt><span class="sect1"><a href="encryption-options.html">16.6. Encryption Options</a></span></dt>
@@ -172,16 +172,16 @@
<dd><dl>
<dt><span class="sect1"><a href="charset.html#locale">21.1. Locale Support</a></span></dt>
<dd><dl>
-<dt><span class="sect2"><a href="charset.html#id2688903">21.1.1. Overview</a></span></dt>
-<dt><span class="sect2"><a href="charset.html#id2689225">21.1.2. Behavior</a></span></dt>
-<dt><span class="sect2"><a href="charset.html#id2689387">21.1.3. Problems</a></span></dt>
+<dt><span class="sect2"><a href="charset.html#id521933">21.1.1. Overview</a></span></dt>
+<dt><span class="sect2"><a href="charset.html#id522219">21.1.2. Behavior</a></span></dt>
+<dt><span class="sect2"><a href="charset.html#id522374">21.1.3. Problems</a></span></dt>
</dl></dd>
<dt><span class="sect1"><a href="multibyte.html">21.2. Character Set Support</a></span></dt>
<dd><dl>
<dt><span class="sect2"><a href="multibyte.html#multibyte-charset-supported">21.2.1. Supported Character Sets</a></span></dt>
-<dt><span class="sect2"><a href="multibyte.html#id2690531">21.2.2. Setting the Character Set</a></span></dt>
-<dt><span class="sect2"><a href="multibyte.html#id2690721">21.2.3. Automatic Character Set Conversion Between Server and Client</a></span></dt>
-<dt><span class="sect2"><a href="multibyte.html#id2691923">21.2.4. Further Reading</a></span></dt>
+<dt><span class="sect2"><a href="multibyte.html#id523486">21.2.2. Setting the Character Set</a></span></dt>
+<dt><span class="sect2"><a href="multibyte.html#id523659">21.2.3. Automatic Character Set Conversion Between Server and Client</a></span></dt>
+<dt><span class="sect2"><a href="multibyte.html#id524827">21.2.4. Further Reading</a></span></dt>
</dl></dd>
</dl></dd>
<dt><span class="chapter"><a href="maintenance.html">22. Routine Database Maintenance Tasks</a></span></dt>
@@ -258,13 +258,13 @@
<dt><span class="sect1"><a href="regress.html#regress-run">28.1. Running the Tests</a></span></dt>
<dt><span class="sect1"><a href="regress-evaluation.html">28.2. Test Evaluation</a></span></dt>
<dd><dl>
-<dt><span class="sect2"><a href="regress-evaluation.html#id2701507">28.2.1. Error message differences</a></span></dt>
-<dt><span class="sect2"><a href="regress-evaluation.html#id2701529">28.2.2. Locale differences</a></span></dt>
-<dt><span class="sect2"><a href="regress-evaluation.html#id2701548">28.2.3. Date and time differences</a></span></dt>
-<dt><span class="sect2"><a href="regress-evaluation.html#id2701576">28.2.4. Floating-point differences</a></span></dt>
-<dt><span class="sect2"><a href="regress-evaluation.html#id2701647">28.2.5. Row ordering differences</a></span></dt>
-<dt><span class="sect2"><a href="regress-evaluation.html#id2701718">28.2.6. Insufficient stack depth</a></span></dt>
-<dt><span class="sect2"><a href="regress-evaluation.html#id2701757">28.2.7. The <span class="quote">&#8220;<span class="quote">random</span>&#8221;</span> test</a></span></dt>
+<dt><span class="sect2"><a href="regress-evaluation.html#id533134">28.2.1. Error message differences</a></span></dt>
+<dt><span class="sect2"><a href="regress-evaluation.html#id533153">28.2.2. Locale differences</a></span></dt>
+<dt><span class="sect2"><a href="regress-evaluation.html#id533162">28.2.3. Date and time differences</a></span></dt>
+<dt><span class="sect2"><a href="regress-evaluation.html#id533186">28.2.4. Floating-point differences</a></span></dt>
+<dt><span class="sect2"><a href="regress-evaluation.html#id533251">28.2.5. Row ordering differences</a></span></dt>
+<dt><span class="sect2"><a href="regress-evaluation.html#id533310">28.2.6. Insufficient stack depth</a></span></dt>
+<dt><span class="sect2"><a href="regress-evaluation.html#id533345">28.2.7. The <span class="quote">&#8220;<span class="quote">random</span>&#8221;</span> test</a></span></dt>
</dl></dd>
<dt><span class="sect1"><a href="regress-variant.html">28.3. Variant Comparison Files</a></span></dt>
</dl></dd>
@@ -2,10 +2,10 @@
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>clusterdb</title>
-<link rel="stylesheet" type="text/css" href="stylesheet.css">
+<link rel="stylesheet" href="stylesheet.css" type="text/css">
<link rev="made" href="pgsql-docs@postgresql.org">
-<meta name="generator" content="DocBook XSL Stylesheets V1.76.1">
-<link rel="home" href="index.html" title="PostgreSQL 8.2.21 Documentation">
+<meta name="generator" content="DocBook XSL Stylesheets V1.75.2">
+<link rel="home" href="index.html" title="PostgreSQL 8.2.23 Documentation">
<link rel="up" href="reference-client.html" title="PostgreSQL Client Applications">
<link rel="prev" href="reference-client.html" title="PostgreSQL Client Applications">
<link rel="next" href="app-createdb.html" title="createdb">
@@ -17,12 +17,12 @@
<h2>Name</h2>
<p>clusterdb &#8212; cluster a <span class="productname">PostgreSQL</span> database</p>
</div>
-<a name="id2823403"></a><div class="refsynopsisdiv" title="Synopsis">
+<a name="id644426"></a><div class="refsynopsisdiv" title="Synopsis">
<h2>Synopsis</h2>
<div class="cmdsynopsis"><p><code class="command">clusterdb</code> [<em class="replaceable"><code>connection-option</code></em>...] [--table | -t <em class="replaceable"><code>table</code></em> ] [<em class="replaceable"><code>dbname</code></em>]<br><code class="command">clusterdb</code> [<em class="replaceable"><code>connection-option</code></em>...] [[--all] | [-a]]</p></div>
</div>
<div class="refsect1" title="Description">
-<a name="id2823479"></a><h2>Description</h2>
+<a name="id644501"></a><h2>Description</h2>
<p> <span class="application">clusterdb</span> is a utility for reclustering tables
in a <span class="productname">PostgreSQL</span> database. It finds tables
that have previously been clustered, and clusters them again on the same
@@ -36,7 +36,7 @@
</p>
</div>
<div class="refsect1" title="Options">
-<a name="id2823520"></a><h2>Options</h2>
+<a name="id644539"></a><h2>Options</h2>
<p> <span class="application">clusterdb</span> accepts the following command-line arguments:
</p>
@@ -109,7 +109,7 @@
</p>
</div>
<div class="refsect1" title="Environment">
-<a name="id2823733"></a><h2>Environment</h2>
+<a name="id644745"></a><h2>Environment</h2>
<div class="variablelist"><dl>
<dt>
<span xmlns="http://www.w3.org/TR/xhtml1/transitional" class="term"><code xmlns="" class="envar">PGDATABASE</code></span><br xmlns="http://www.w3.org/TR/xhtml1/transitional"></br><span xmlns="http://www.w3.org/TR/xhtml1/transitional" class="term"><code xmlns="" class="envar">PGHOST</code></span><br xmlns="http://www.w3.org/TR/xhtml1/transitional"></br><span xmlns="http://www.w3.org/TR/xhtml1/transitional" class="term"><code xmlns="" class="envar">PGPORT</code></span><br xmlns="http://www.w3.org/TR/xhtml1/transitional"></br><span class="term"><code class="envar">PGUSER</code></span>
@@ -123,7 +123,7 @@
</p>
</div>
<div class="refsect1" title="Diagnostics">
-<a name="id2823778"></a><h2>Diagnostics</h2>
+<a name="id644789"></a><h2>Diagnostics</h2>
<p> In case of difficulty, see <a class="xref" href="sql-cluster.html" title="CLUSTER">CLUSTER</a> and <a class="xref" href="app-psql.html" title="psql"><span class="refentrytitle"><a name="app-psql-title"></a><span class="application">psql</span></span></a> for
discussions of potential problems and error messages.
The database server must be running at the
@@ -133,7 +133,7 @@
</p>
</div>
<div class="refsect1" title="Examples">
-<a name="id2823808"></a><h2>Examples</h2>
+<a name="id644817"></a><h2>Examples</h2>
<p> To cluster the database <code class="literal">test</code>:
</p>
<pre class="screen"><code class="prompt">$ </code><strong class="userinput"><code>clusterdb test</code></strong></pre>
@@ -148,7 +148,7 @@
</p>
</div>
<div class="refsect1" title="See Also">
-<a name="id2823863"></a><h2>See Also</h2>
+<a name="id644870"></a><h2>See Also</h2>
<span class="simplelist"><a class="xref" href="sql-cluster.html" title="CLUSTER">CLUSTER</a></span>
</div>
</div></body>
@@ -2,10 +2,10 @@
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>createdb</title>
-<link rel="stylesheet" type="text/css" href="stylesheet.css">
+<link rel="stylesheet" href="stylesheet.css" type="text/css">
<link rev="made" href="pgsql-docs@postgresql.org">
-<meta name="generator" content="DocBook XSL Stylesheets V1.76.1">
-<link rel="home" href="index.html" title="PostgreSQL 8.2.21 Documentation">
+<meta name="generator" content="DocBook XSL Stylesheets V1.75.2">
+<link rel="home" href="index.html" title="PostgreSQL 8.2.23 Documentation">
<link rel="up" href="reference-client.html" title="PostgreSQL Client Applications">
<link rel="prev" href="app-clusterdb.html" title="clusterdb">
<link rel="next" href="app-createlang.html" title="createlang">
@@ -17,7 +17,7 @@
<h2>Name</h2>
<p>createdb &#8212; create a new <span class="productname">PostgreSQL</span> database</p>
</div>
-<a name="id2823910"></a><div class="refsynopsisdiv" title="Synopsis">
+<a name="id644916"></a><div class="refsynopsisdiv" title="Synopsis">
<h2>Synopsis</h2>
<div class="cmdsynopsis"><p><code class="command">createdb</code> [<em class="replaceable"><code>option</code></em>...] [<em class="replaceable"><code>dbname</code></em>] [<em class="replaceable"><code>description</code></em>]</p></div>
</div>
@@ -39,7 +39,7 @@
</p>
</div>
<div class="refsect1" title="Options">
-<a name="id2824007"></a><h2>Options</h2>
+<a name="id645008"></a><h2>Options</h2>
<p> <span class="application">createdb</span> accepts the following command-line arguments:
</p>
@@ -130,7 +130,7 @@
</p>
</div>
<div class="refsect1" title="Environment">
-<a name="id2824303"></a><h2>Environment</h2>
+<a name="id645290"></a><h2>Environment</h2>
<div class="variablelist"><dl>
<dt><span class="term"><code class="envar">PGDATABASE</code></span></dt>
<dd><p> If set, the name of the database to create, unless overridden on
@@ -150,7 +150,7 @@
</p>
</div>
<div class="refsect1" title="Diagnostics">
-<a name="id2824363"></a><h2>Diagnostics</h2>
+<a name="id645347"></a><h2>Diagnostics</h2>
<p> In case of difficulty, see <a class="xref" href="sql-createdatabase.html" title="CREATE DATABASE">CREATE DATABASE</a> and <a class="xref" href="app-psql.html" title="psql"><span class="refentrytitle"><a name="app-psql-title"></a><span class="application">psql</span></span></a> for
discussions of potential problems and error messages.
The database server must be running at the
@@ -160,7 +160,7 @@
</p>
</div>
<div class="refsect1" title="Examples">
-<a name="id2824394"></a><h2>Examples</h2>
+<a name="id645376"></a><h2>Examples</h2>
<p> To create the database <code class="literal">demo</code> using the default
database server:
</p>
@@ -182,7 +182,7 @@
</p>
</div>
<div class="refsect1" title="See Also">
-<a name="id2824485"></a><h2>See Also</h2>
+<a name="id645464"></a><h2>See Also</h2>
<span class="simplelist"><a class="xref" href="app-dropdb.html" title="dropdb"><span class="refentrytitle"><a name="app-dropdb-title"></a><span class="application">dropdb</span></span></a>, <a class="xref" href="sql-createdatabase.html" title="CREATE DATABASE">CREATE DATABASE</a></span>
</div>
</div></body>
@@ -2,10 +2,10 @@
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>createlang</title>
-<link rel="stylesheet" type="text/css" href="stylesheet.css">
+<link rel="stylesheet" href="stylesheet.css" type="text/css">
<link rev="made" href="pgsql-docs@postgresql.org">
-<meta name="generator" content="DocBook XSL Stylesheets V1.76.1">
-<link rel="home" href="index.html" title="PostgreSQL 8.2.21 Documentation">
+<meta name="generator" content="DocBook XSL Stylesheets V1.75.2">
+<link rel="home" href="index.html" title="PostgreSQL 8.2.23 Documentation">
<link rel="up" href="reference-client.html" title="PostgreSQL Client Applications">
<link rel="prev" href="app-createdb.html" title="createdb">
<link rel="next" href="app-createuser.html" title="createuser">
@@ -17,12 +17,12 @@
<h2>Name</h2>
<p>createlang &#8212; define a new <span class="productname">PostgreSQL</span> procedural language</p>
</div>
-<a name="id2824539"></a><div class="refsynopsisdiv" title="Synopsis">
+<a name="id645516"></a><div class="refsynopsisdiv" title="Synopsis">
<h2>Synopsis</h2>
<div class="cmdsynopsis"><p><code class="command">createlang</code> [<em class="replaceable"><code>connection-option</code></em>...] <em class="replaceable"><code>langname</code></em> [<em class="replaceable"><code>dbname</code></em>]<br><code class="command">createlang</code> [<em class="replaceable"><code>connection-option</code></em>...] [--list] | [-l] <em class="replaceable"><code>dbname</code></em> </p></div>
</div>
<div class="refsect1" title="Description">
-<a name="id2824621"></a><h2>Description</h2>
+<a name="id645597"></a><h2>Description</h2>
<p> <span class="application">createlang</span> is a utility for adding a new
programming language to a <span class="productname">PostgreSQL</span> database.
<span class="application">createlang</span> is just a wrapper around the
@@ -31,7 +31,7 @@
</p>
</div>
<div class="refsect1" title="Options">
-<a name="id2824656"></a><h2>Options</h2>
+<a name="id645630"></a><h2>Options</h2>
<p> <span class="application">createlang</span> accepts the following command-line arguments:
</p>
@@ -95,7 +95,7 @@
</p>
</div>
<div class="refsect1" title="Environment">
-<a name="id2824825"></a><h2>Environment</h2>
+<a name="id645792"></a><h2>Environment</h2>
<div class="variablelist"><dl>
<dt>
<span xmlns="http://www.w3.org/TR/xhtml1/transitional" class="term"><code xmlns="" class="envar">PGDATABASE</code></span><br xmlns="http://www.w3.org/TR/xhtml1/transitional"></br><span xmlns="http://www.w3.org/TR/xhtml1/transitional" class="term"><code xmlns="" class="envar">PGHOST</code></span><br xmlns="http://www.w3.org/TR/xhtml1/transitional"></br><span xmlns="http://www.w3.org/TR/xhtml1/transitional" class="term"><code xmlns="" class="envar">PGPORT</code></span><br xmlns="http://www.w3.org/TR/xhtml1/transitional"></br><span class="term"><code class="envar">PGUSER</code></span>
@@ -109,7 +109,7 @@
</p>
</div>
<div class="refsect1" title="Diagnostics">
-<a name="id2824871"></a><h2>Diagnostics</h2>
+<a name="id645835"></a><h2>Diagnostics</h2>
<p> Most error messages are self-explanatory. If not, run
<span class="application">createlang</span> with the <code class="option">--echo</code>
option and see under the respective <acronym class="acronym">SQL</acronym> command
@@ -119,12 +119,12 @@
</p>
</div>
<div class="refsect1" title="Notes">
-<a name="id2824900"></a><h2>Notes</h2>
+<a name="id645862"></a><h2>Notes</h2>
<p> Use <a class="xref" href="app-droplang.html" title="droplang"><span class="refentrytitle"><a name="app-droplang-title"></a><span class="application">droplang</span></span></a> to remove a language.
</p>
</div>
<div class="refsect1" title="Examples">
-<a name="id2824911"></a><h2>Examples</h2>
+<a name="id645874"></a><h2>Examples</h2>
<p> To install the language <code class="literal">pltcl</code> into the database
<code class="literal">template1</code>:
</p>
@@ -136,7 +136,7 @@
</p>
</div>
<div class="refsect1" title="See Also">
-<a name="id2824951"></a><h2>See Also</h2>
+<a name="id645912"></a><h2>See Also</h2>
<span class="simplelist"><a class="xref" href="app-droplang.html" title="droplang"><span class="refentrytitle"><a name="app-droplang-title"></a><span class="application">droplang</span></span></a>, <a class="xref" href="sql-createlanguage.html" title="CREATE LANGUAGE">CREATE LANGUAGE</a></span>
</div>
</div></body>
Oops, something went wrong.

0 comments on commit 2f0fc55

Please sign in to comment.