aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorFujii Masao <fujii@postgresql.org>2013-07-31 22:35:12 +0900
committerFujii Masao <fujii@postgresql.org>2013-07-31 22:35:12 +0900
commitee08a78a8104ce4e98ce67dc404b9d6ee3a1425a (patch)
tree2401037809b1b71f21a586fb490efb4b4718d84e
parent16f38f72ab2b8a3b2d45ba727d213bb31111cea4 (diff)
downloadpostgresql-ee08a78a8104ce4e98ce67dc404b9d6ee3a1425a.tar.gz
postgresql-ee08a78a8104ce4e98ce67dc404b9d6ee3a1425a.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>