Re: Creating a tablespace directory in recovery - Mailing list pgsql-hackers

From Flavio Henrique Araque Gurgel
Subject Re: Creating a tablespace directory in recovery
Date
Msg-id 7213469.01241204782148.JavaMail.flavio@presente
Whole thread Raw
In response to Re: Creating a tablespace directory in recovery  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
<div style="font-family: Times New Roman; font-size: 12pt; color: #000000">----- "Fujii Masao"
<masao.fujii@gmail.com>escreveu: <br />> IMO, it's not so dangerous that postgres creates the directories,<br
/>>which doesn't overwrite or remove any existing data. So, I thought<br />> that it's worth writing the patch to
createa tablespace directory<br />> in recovery. Is this the right direction? Or, we should completely<br />>
forbidthe auto-creation of directories outside $PGDATA?<br /><br />I don't think it's a good idea to create directories
automaticallyat all.<br />Considering that the greatest benefit of using tablespaces is to move tables and indexes that
havehigh concurrency to different disk partitions or controllers, creating directories (and mounting devices) for
tablespacesshould be a manual process.<br /><br />Flavio<br /></div> 

pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: Throw some low-level C scutwork at me
Next
From: Andrew Dunstan
Date:
Subject: Re: Table data exclusion patch for pg_dump