Skip to content

Commit 6122849

Browse files
committed
In pg_upgrade, document that link mode has to have data directories on
the same file system, and that authentication should lock out normal users. Per suggestsion from #postgresql irc channel. Backpatch to 9.0.
1 parent 5246386 commit 6122849

File tree

1 file changed

+7
-4
lines changed

1 file changed

+7
-4
lines changed

doc/src/sgml/pgupgrade.sgml

Lines changed: 7 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -239,7 +239,8 @@ gmake prefix=/usr/local/pgsql.new install
239239
so you might want to set authentication to <literal>trust</> in
240240
<filename>pg_hba.conf</>, or if using <literal>md5</> authentication,
241241
use a <filename>~/.pgpass</> file (see <xref linkend="libpq-pgpass">)
242-
to avoid being prompted repeatedly for a password.
242+
to avoid being prompted repeatedly for a password. Also make sure
243+
pg_upgrade is the only program that can connect to the clusters.
243244
</para>
244245
</step>
245246

@@ -278,9 +279,11 @@ NET STOP pgsql-8.3 (<productname>PostgreSQL</> 8.3 and older used a different s
278279
data and executable (<filename>bin</>) directories. You can also specify separate
279280
user and port values, and whether you want the data linked instead of
280281
copied (the default). If you use linking, the migration will be much
281-
faster (no data copying), but you will no longer be able to access your
282-
old cluster once you start the new cluster after the upgrade. See
283-
<literal>pg_upgrade --help</> for a full list of options.
282+
faster (hard link data files rather than copying them), but you
283+
will no longer be able to access your old cluster once you start
284+
the new cluster after the upgrade. Link mode also requires that the
285+
old and new cluster data directories be in the same file system.
286+
See <literal>pg_upgrade --help</> for a full list of options.
284287
</para>
285288

286289
<para>

0 commit comments

Comments
 (0)