aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFujii Masao <fujii@postgresql.org>2013-07-31 22:36:39 +0900
committerFujii Masao <fujii@postgresql.org>2013-07-31 22:36:39 +0900
commitfe136ba6fc31760efe7ac53e662395a71a92dc03 (patch)
treeb9627755b749ab5b74b1f2ae404eb433bed780c8
parent9a78f66fdccbc85442f992f2928b4a58ae451208 (diff)
downloadpostgresql-fe136ba6fc31760efe7ac53e662395a71a92dc03.tar.gz
postgresql-fe136ba6fc31760efe7ac53e662395a71a92dc03.zip
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>