94
94
<td><code>/etc/postgresql/<i>version</i>/<i>clustername</i></code></td>
95
<td>Cluster-specific configuration files: <code>postgresql.conf</code>,
96
<code>pg_hba.conf</code>, <code>pg_ident.conf</code>, a symbolic link
97
<code>pgdata</code> which points to the actual data directory, a symbolic
98
link <code>log</code> which points to the postmaster log file, and a symbolic link
99
<code>autovacuum_log</code> which points to the log file of the autovacuum
100
daemon (started if <code>postgresql-contrib-</code><i>version</i> is
101
installed). If this directory contains <code>autovacuum.conf</code>, this is
102
used as the cluster specific autovacuum daemon configuration; if it does not
103
exist, <code>/etc/postgresql-common/autovacuum.conf</code> is used as a
104
fallback. If this directory contains <code>start.conf</code>, that file
105
configures the startup mode of the cluster: <i>auto</i> (start/stop in init
106
script), <i>manual</i> (do not start/stop in init script, but manual control
107
with <code>pg_ctlcluster</code> is possible), <i>disabled</i>
108
(<code>pg_ctlcluster</code> is not allowed).</td>
95
<td>Cluster-specific configuration files:
97
<li><code>postgresql.conf</code>, <code>pg_hba.conf</code>, <code>pg_ident.conf</code></li>
98
<li>optionally <code>start.conf</code>: startup mode of the
99
cluster: <code>auto</code> (start/stop in init script),
100
<code>manual</code> (do not start/stop in init script, but manual
101
control with <code>pg_ctlcluster</code> is possible), <i>disabled</i>
102
(<code>pg_ctlcluster</code> is not allowed).</li>
103
<li>optionally a symbolic link <code>log</code> which points to
104
the postmaster log file. Defaults to
105
<code>/var/log/postgresql/postgresql-</code><i>version</i><code>-</code><i>cluster</i><code>.conf</code>.
106
Explicitly setting <code>log_directory</code> and/or
107
<code>log_filename</code> in <code>postgresql.conf</code>
111
For PostgreSQL versions earlier than 8.1:
114
<li>a symbolic link <code>autovacuum_log</code> which points to
115
the log file of the autovacuum daemon (started if
116
<code>postgresql-contrib-</code><i>version</i> is installed). If
117
this directory contains <code>autovacuum.conf</code>, this is used
118
as the cluster specific autovacuum daemon configuration; if it
120
<code>/etc/postgresql-common/autovacuum.conf</code> is used as a
113
128
<h3>Per-version files and programs</h3>
115
<table cellpadding="6" cellspacing="0" border="0">
116
<tr><td><code>/usr/lib/postgresql/<i>version</i></code></td> <td colspan="0" rowspan="3" valign="middle">files for a specific version</td></tr>
130
<table cellpadding="6" cellspacing="0" border="1">
131
<tr><td><code>/usr/lib/postgresql/<i>version</i></code></td> <td colspan="0" rowspan="3" valign="middle">version specific program and data files</td></tr>
117
132
<tr><td><code>/usr/share/postgresql/<i>version</i></code></td></tr>
118
133
<tr><td><code>/usr/share/doc/postgresql/postgresql-doc-<i>version</i></code></td></tr>
121
136
<h3>Common programs</h3>
122
<table cellpadding="6" cellspacing="0" border="0">
137
<table cellpadding="6" cellspacing="0" border="1">
123
138
<tr><td><code>/usr/share/postgresql-common/pg_wrapper</code></td> <td>environment chooser and program selector</td></tr>
124
139
<tr><td><code>/usr/bin/<i>program</i></code></td> <td>symbolic links to pg_wrapper, for all client programs</td></tr>
125
140
<tr><td><code>/usr/bin/pg_lsclusters</code></td> <td>list all available clusters with their status and configuration</td></tr>
138
153
<code>user_clusters</code>, the default database will correspond to the user
139
154
name, thus reintroducing the default upstream behaviour.</p>
144
<p>pg_wrapper has been completely rewritten. When called a pg_default, it
145
allows a user to display his own connection choices, or to change them for
146
the current session, or for all sessions (by writing <code>~/.postgresqlrc</code>).
147
When called by root, it allows user_clusters to be changed.
149
<p>When called as pg_exec, pg_wrapper can execute code from an
150
arbitrary version in order to connect to a remote machine.</p>
152
<p>When called as a link to any other name, that name is treated as a
153
client program and a path to the appropriate version of that program is
154
constructed and executed.</p>
156
<p>See the man pages for full details of the program's operation.</p>
159
156
<h3>/etc/init.d/postgresql-<i>version</i></h3>
161
158
<p>This script now handles the postmaster server processes for each