Re: Why isn't stats_temp_directory automatically created? - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Why isn't stats_temp_directory automatically created?
Date
Msg-id 3f0b79eb0904210033o1c886c2et282519de65a4f071@mail.gmail.com
Whole thread Raw
In response to Re: Why isn't stats_temp_directory automatically created?  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Why isn't stats_temp_directory automatically created?  (Fujii Masao <masao.fujii@gmail.com>)
Re: Why isn't stats_temp_directory automatically created?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi,

On Mon, Apr 20, 2009 at 1:29 AM, Magnus Hagander <magnus@hagander.net> wrote:
> Sorry about the very late response - I've been out of the country and
> generally busy.

Thanks for taking the time to comment!

>> On Wed, Apr 15, 2009 at 5:37 PM, Magnus Hagander <magnus@hagander.net> wrote:
>>> This does not take into account the effect of symlinks as mentioned by
>>> Itakagi Takahiro. I haven't looked at the details, but I don't think it
>>> would be that much more work to deal with it - and as he mentions, this
>>> is a very common usecase.
>>
>> Okey, I'll revise the patch; create also the directory which is
>> referenced by symlink if not present.
>
> Great.

Here is the revised patch; If stats_temp_directory indicates the symlink,
we pursue the chain of symlinks and create the referenced directory.

>>> Also, wouldn't it be better to isolate this to the first time when we
>>> try to create the file - then we don't have to export the symbol?
>>
>> You mean having assign_pgstat_temp_directory() create the
>> directory instead of pgstat_start()? In this case, the directory is
>> created automatically not only at the beginning but also when
>> a configuration file is reloaded. This seems to be better behavior.
>
> No, I meant creating it when we open the file - in pgstat_write_statsfile().

OK, I changed the patch so. Thanks.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Attachment

pgsql-hackers by date:

Previous
From: KaiGai Kohei
Date:
Subject: Re: [PATCH] unalias of ACL_SELECT_FOR_UPDATE
Next
From: Demise Garrouste
Date:
Subject: Extend PL/pgSQL