summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFujii Masao2013-07-31 13:37:11 +0000
committerFujii Masao2013-07-31 13:37:11 +0000
commite73357c10b8ca7f38e83e73e57f09d774a83db2f (patch)
tree21c4ba9614a4672a663b6cdb377e972daef3037a
parentb3ddd1063567de4a4af8dae6cc96cb33466cf954 (diff)
Fix inaccurate description of tablespace.
Currently we don't need to update the pg_tablespace catalog after redefining the symbolic links to the tablespaces because pg_tablespace.spclocation column was removed in PostgreSQL 9.2. Back patch to 9.2 where pg_tablespace.spclocation was removed. Ian Barwick, with minor change by me.
-rw-r--r--doc/src/sgml/manage-ag.sgml13
1 files changed, 7 insertions, 6 deletions
diff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgml
index e5a5947ef28..b44d521ba69 100644
--- a/doc/src/sgml/manage-ag.sgml
+++ b/doc/src/sgml/manage-ag.sgml
@@ -479,7 +479,8 @@ CREATE TABLE foo(i int);
<para>
To determine the set of existing tablespaces, examine the
- <structname>pg_tablespace</> system catalog, for example
+ <link linkend="catalog-pg-tablespace"><structname>pg_tablespace</structname>
+ </link> system catalog, for example
<synopsis>
SELECT spcname FROM pg_tablespace;
</synopsis>
@@ -498,11 +499,11 @@ SELECT spcname FROM pg_tablespace;
The directory <filename>$PGDATA/pg_tblspc</> contains symbolic links that
point to each of the non-built-in tablespaces defined in the cluster.
Although not recommended, it is possible to adjust the tablespace
- layout by hand by redefining these links. Two warnings: do not do so
- while the server is running; and after you restart the server,
- update the <structname>pg_tablespace</> catalog with the new
- locations. (If you do not, <literal>pg_dump</> will continue to output
- the old tablespace locations.)
+ layout by hand by redefining these links. Under no circumstances perform
+ this operation while the server is running. Note that in PostgreSQL 9.1
+ and earlier you will also need to update the <structname>pg_tablespace</>
+ catalog with the new locations. (If you do not, <literal>pg_dump</> will
+ continue to output the old tablespace locations.)
</para>
</sect1>