Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitee08a78

Browse files
committed
Fix inaccurate description of tablespace.
Currently we don't need to update the pg_tablespace catalogafter redefining the symbolic links to the tablespacesbecause pg_tablespace.spclocation column was removed inPostgreSQL 9.2.Back patch to 9.2 where pg_tablespace.spclocation was removed.Ian Barwick, with minor change by me.
1 parent16f38f7 commitee08a78

File tree

1 file changed

+7
-6
lines changed

1 file changed

+7
-6
lines changed

‎doc/src/sgml/manage-ag.sgml

Lines changed: 7 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -479,7 +479,8 @@ CREATE TABLE foo(i int);
479479

480480
<para>
481481
To determine the set of existing tablespaces, examine the
482-
<structname>pg_tablespace</> system catalog, for example
482+
<link linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname>
483+
</link> system catalog, for example
483484
<synopsis>
484485
SELECT spcname FROM pg_tablespace;
485486
</synopsis>
@@ -498,11 +499,11 @@ SELECT spcname FROM pg_tablespace;
498499
The directory <filename>$PGDATA/pg_tblspc</> contains symbolic links that
499500
point to each of the non-built-in tablespaces defined in the cluster.
500501
Although not recommended, it is possible to adjust the tablespace
501-
layout by hand by redefining these links. Two warnings: do not do so
502-
while the server is running; and after you restart the server,
503-
update the <structname>pg_tablespace</> catalog with the new
504-
locations.(If you do not, <literal>pg_dump</> will continue to output
505-
the old tablespace locations.)
502+
layout by hand by redefining these links.Under no circumstances perform
503+
this operationwhile the server is running. Note that in PostgreSQL 9.1
504+
and earlier you will also need toupdate the <structname>pg_tablespace</>
505+
catalog with the newlocations. (If you do not, <literal>pg_dump</> will
506+
continue to outputthe old tablespace locations.)
506507
</para>
507508

508509
</sect1>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp