Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7983=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1WbWe8-0003jN-IL
 for pgsql-docs@arkaria.postgresql.org; Sat, 19 Apr 2014 14:53:36 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-docs-owner+M7983=pgsql+2Ddocs=arkaria.postgresql.org@postgresql.org>)
 id 1WbWe7-0006UF-Vv
 for pgsql-docs@arkaria.postgresql.org; Sat, 19 Apr 2014 14:53:36 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <bruce@momjian.us>) id 1WbWe7-0006U9-Cu
 for pgsql-docs@postgresql.org; Sat, 19 Apr 2014 14:53:35 +0000
Received: from momjian.us ([72.94.173.45])
 by magus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <bruce@momjian.us>) id 1WbWe4-0002HB-CJ
 for pgsql-docs@postgresql.org; Sat, 19 Apr 2014 14:53:35 +0000
Received: from bruce by momjian.us with local (Exim 4.72)
 (envelope-from <bruce@momjian.us>)
 id 1WbWe1-00064I-Po; Sat, 19 Apr 2014 10:53:29 -0400
Date: Sat, 19 Apr 2014 10:53:29 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Craig Ringer <craig@2ndquadrant.com>
Cc: Ian Lawrence Barwick <barwick@gmail.com>,
 PostgreSQL Developers <pgsql-docs@postgresql.org>
Subject: Re: PATCH: Warn users about tablespace abuse data loss risk
Message-ID: <20140419145329.GD31555@momjian.us>
References: <52FAEFEA.4060609@2ndquadrant.com>
 <CAB8KJ=hR+tmQAxdV8Gv3tJUN3cUp5o_x4t-mj5Ub=ZhZbYBcig@mail.gmail.com>
 <1392181593539-5791542.post@n5.nabble.com>
 <CAB8KJ=iFi6V5xRojdWeSC+CWNksRsAB9MNkjB9Th37aQg38w8Q@mail.gmail.com>
 <CAB8KJ=h5hy+1Dt-v2jK=uLtEc5iPeR1ksSXO-sOwcVAZvXVyvQ@mail.gmail.com>
 <52FC0EBF.7020300@2ndquadrant.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="lrZ03NoBR/3+SXJZ"
Content-Disposition: inline
In-Reply-To: <52FC0EBF.7020300@2ndquadrant.com>
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Pg-Spam-Score: -2.6 (--)
List-Archive: <http://archives.postgresql.org/pgsql-docs>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-docs.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@postgresql.org>
List-Post: <mailto:pgsql-docs@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-docs>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
X-Mailing-List: pgsql-docs
Precedence: bulk
Sender: pgsql-docs-owner@postgresql.org


--lrZ03NoBR/3+SXJZ
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Thu, Feb 13, 2014 at 08:15:59AM +0800, Craig Ringer wrote:
> On 02/12/2014 02:35 PM, Ian Lawrence Barwick wrote:
> > And taking a look at the page in question I see this prominent example:
> > 
> >   CREATE TABLESPACE fastspace LOCATION '/mnt/sda1/postgresql/data';
> 
> Here's an updated patch, adopting your wording for the first par and
> tweaking the example.

I have applied an adjusted version of this patch that is more compact. 
Thanks.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +

--lrZ03NoBR/3+SXJZ
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment; filename="tablespace.diff"

diff --git a/doc/src/sgml/manage-ag.sgml b/doc/src/sgml/manage-ag.sgml
new file mode 100644
index b44d521..78ec509
*** a/doc/src/sgml/manage-ag.sgml
--- b/doc/src/sgml/manage-ag.sgml
*************** dropdb <replaceable class="parameter">db
*** 379,395 ****
     expensive, slower disk system.
    </para>
  
    <para>
     To define a tablespace, use the <xref
     linkend="sql-createtablespace">
     command, for example:<indexterm><primary>CREATE TABLESPACE</></>:
  <programlisting>
! CREATE TABLESPACE fastspace LOCATION '/mnt/sda1/postgresql/data';
  </programlisting>
     The location must be an existing, empty directory that is owned by
     the <productname>PostgreSQL</> operating system user.  All objects subsequently
     created within the tablespace will be stored in files underneath this
!    directory.
    </para>
  
    <note>
--- 379,412 ----
     expensive, slower disk system.
    </para>
  
+   <warning>
+    <para>
+      Even though located outside the main PostgreSQL data directory,
+      tablespaces are an integral part of the database cluster and
+      <emphasis>cannot</emphasis> be treated as an autonomous collection
+      of data files. They are dependent on metadata contained in the main
+      data directory, and therefore cannot be attached to a different
+      database cluster or backed up individually.  Similarly, if you lose
+      a tablespace (file deletion, disk failure, etc), the database cluster
+      might become unreadable or unable to start.  Placing a tablespace
+      on a temporary file system like a ramdisk risks the reliability of
+      the entire cluster.
+    </para>
+   </warning>
+ 
    <para>
     To define a tablespace, use the <xref
     linkend="sql-createtablespace">
     command, for example:<indexterm><primary>CREATE TABLESPACE</></>:
  <programlisting>
! CREATE TABLESPACE fastspace LOCATION '/ssd1/postgresql/data';
  </programlisting>
     The location must be an existing, empty directory that is owned by
     the <productname>PostgreSQL</> operating system user.  All objects subsequently
     created within the tablespace will be stored in files underneath this
!    directory.  The location must not be on removable or transient storage,
!    as the cluster might fail to function if the tablespace is missing
!    or lost.
    </para>
  
    <note>
diff --git a/doc/src/sgml/ref/create_tablespace.sgml b/doc/src/sgml/ref/create_tablespace.sgml
new file mode 100644
index b643565..cf6215e
*** a/doc/src/sgml/ref/create_tablespace.sgml
--- b/doc/src/sgml/ref/create_tablespace.sgml
*************** CREATE TABLESPACE <replaceable class="pa
*** 50,55 ****
--- 50,63 ----
     <command>CREATE INDEX</> or <command>ADD CONSTRAINT</> to have the data
     files for these objects stored within the specified tablespace.
    </para>
+ 
+   <warning>
+    <para>
+     A tablespace cannot be used independently of the cluster in which it
+     is defined;  see <xref linkend="manage-ag-tablespaces"/>.
+    </para>
+   </warning>
+ 
   </refsect1>
  
   <refsect1>

--lrZ03NoBR/3+SXJZ
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
MIME-Version: 1.0


-- 
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs

--lrZ03NoBR/3+SXJZ--