Re: Tablespaces in the data directory

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Tablespaces in the data directory
Дата
Msg-id 20121204030611.GD7675@momjian.us
обсуждение исходный текст
Ответ на Re: Tablespaces in the data directory  ("Greg Sabino Mullane" <greg@turnstep.com>)
Ответы Re: Tablespaces in the data directory
Список 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 по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: json accessors
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Proposal for Allow postgresql.conf values to be changed via SQL