Re: The case of PostgreSQL on NFS Server - Mailing list pgsql-general

From Iwao Shikase
Subject Re: The case of PostgreSQL on NFS Server
Date
Msg-id 4C23173F.4060908@air.co.jp
Whole thread Raw
In response to Re: The case of PostgreSQL on NFS Server  ("Rafael Martinez" <r.m.guerrero@usit.uio.no>)
List pgsql-general
Hello,

Thank you for the information . I understood you never recommend the case.
I have another question. I also use Linux in the case.
There are NFS mount options , noac and sync  which is concerned with
caching.
Which option means the keyword 'without caching' in the manual.?
And the case you tested, which option you use when mounting.

Thank you very much.

Shikase.

(2010年06月24日 16:52), Rafael Martinez wrote:
> Craig Ringer wrote:
>
>> On 24/06/10 12:42, Iwao Shikase wrote:
>>
>>
> [.......]
>
>>> If I mount the database cluster with caching in my environment, What kind of
>>>   problem I will meet? Please give the information about the problem you met.
>>>
>> It varies so much by NFS implementation and version that it is really
>> hard to say.
>>
>> Personally, I would never, EVER run a database of any kind over nfs, but
>> perhaps I'm just scarred by Linux's NFS implementation.
>>
>>
> Hello, I agree with Craig 100%.
>
> The experience we have had with different NFS versions/configurations in Linux in
> the past , tells us that this is not a reliable solution for databases.
>
> Others will say the oposite, but running PostgreSQL via NFS in Linux is from my
> point of view, a disaster waiting to happen. I have to say too that we have not
> tried this lately and that maybe things have improved since last time we testet.
>
> regards,
>


--
株式会社エアー
システムソリューション事業部
システム開発グループ
鹿瀬 巌
email:shikase@air.co.jp
tel:06-6368-6080


pgsql-general by date:

Previous
From: "Rafael Martinez"
Date:
Subject: Re: The case of PostgreSQL on NFS Server
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: unexpected effect of FOREIGN KEY ON CASCADE DELETE