Re: [HACKERS] Creating a tablespace directory in recovery

2009-05-01 Thread Tom Lane
Fujii Masao writes: > ISTM that there is currently no unified policy of whether to > automatically create the directory specified by an user. I think it's reasonably consistent: we don't automatically recreate directories that are likely to be symlinks to someplace outside PGDATA. We don't know w

Re: [HACKERS] Creating a tablespace directory in recovery

2009-05-01 Thread Flavio Henrique Araque Gurgel
- "Fujii Masao" escreveu: > IMO, it's not so dangerous that postgres creates the directories, > which doesn't overwrite or remove any existing data. So, I thought > that it's worth writing the patch to create a tablespace directory > in recovery. Is this the right direction? Or, we should

Re: [HACKERS] Creating a tablespace directory in recovery

2009-05-01 Thread Fujii Masao
Hi, On Fri, May 1, 2009 at 10:14 AM, Robert Haas wrote: > Well, there's some chance that if the directories don't exist, it's > because you haven't troubled to mount the correct partitions.  And in > that case just blindly creating the directories will possibly lead to > a series of unfortunate e

Re: [HACKERS] Creating a tablespace directory in recovery

2009-05-01 Thread Jaime Casanova
On Thu, Apr 30, 2009 at 3:50 PM, Jaime Casanova wrote: > On Thu, Apr 30, 2009 at 2:58 AM, Fujii Masao wrote: >> Hi, >> >> Does anyone know why a tablespace directory isn't automatically >> created in recovery? I think that it's troublesome to create all the >> directories before recovery. >> > >

Re: [HACKERS] Creating a tablespace directory in recovery

2009-05-01 Thread Itagaki Takahiro
Fujii Masao wrote: > Does anyone know why a tablespace directory isn't automatically > created in recovery? I think that it's troublesome to create all the > directories before recovery. I guess that's because postgres (OS user) needs a write privilege of *upper* directory of the tablespace dir

Re: [HACKERS] Creating a tablespace directory in recovery

2009-04-30 Thread Robert Haas
On Thu, Apr 30, 2009 at 3:58 AM, Fujii Masao wrote: > Does anyone know why a tablespace directory isn't automatically > created in recovery? I think that it's troublesome to create all the > directories before recovery. Well, there's some chance that if the directories don't exist, it's because y

Re: [HACKERS] Creating a tablespace directory in recovery

2009-04-30 Thread Jaime Casanova
On Thu, Apr 30, 2009 at 2:58 AM, Fujii Masao wrote: > Hi, > > Does anyone know why a tablespace directory isn't automatically > created in recovery? I think that it's troublesome to create all the > directories before recovery. > i guess it's because you need an absolute path to create tablespace

[HACKERS] Creating a tablespace directory in recovery

2009-04-30 Thread Fujii Masao
Hi, Does anyone know why a tablespace directory isn't automatically created in recovery? I think that it's troublesome to create all the directories before recovery. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers ma

[HACKERS] Creating a tablespace directory in recovery

2009-04-30 Thread Fujii Masao
Hi, Does anyone know why a tablespace directory isn't automatically created in recovery? I think that it's troublesome to create all the directories before recovery. Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers ma