Re: Tablespaces in the data directory - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Tablespaces in the data directory
Date
Msg-id 20121204030611.GD7675@momjian.us
Whole thread Raw
In response to Re: Tablespaces in the data directory  ("Greg Sabino Mullane" <greg@turnstep.com>)
Responses Re: Tablespaces in the data directory  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
On Mon, Dec  3, 2012 at 02:38:20AM -0000, Greg Sabino Mullane wrote:
> 
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: RIPEMD160
> 
> 
> > As there isn't (as far as I know at least) any actual *point* in
> > creating a tablespace inside the main data directory, should we
> > perhaps disallow this in CREATE TABLESPACE? Or at least throw a
> > WARNING if one does it?
> 
> Sure there is a point - emulating some other system. Could be 
> replication, QA box, disaster recovery, etc. I'd be 
> cool with a warning, but do not think we should disallow it.

FYI, someone put their new cluster inside an existing old tablespace,
and when they ran the script to delete their old install, their new
install was deleted too.  My answer was, "Don't do that".

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + It's impossible for everything to be true. +



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: json accessors
Next
From: Amit Kapila
Date:
Subject: Re: Proposal for Allow postgresql.conf values to be changed via SQL