| From: | "Chad R(dot) Larson" <chad(at)eldocomp(dot)com> |
|---|---|
| To: | Chris Miles <chris_pg002(at)psychofx(dot)com>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Multiple backends on a single physical database |
| Date: | 2002-10-14 06:15:15 |
| Message-ID: | 4.2.2.20021013231029.00aecef0@smtp.eldocomp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
At 04:19 PM 10/12/02 +0100, Chris Miles wrote:
>If anybody has any horror stories with postgresql over NFS, please share
>them.
I have no horror stories, as we aren't doing such a thing. But it might be
in our future.
I think the version of the NFS protocol you can use is =very=
important. For example, regarding file locking: V1 didn't do it at all
(every transaction was supposed to be stateless, which means persistent
requests were just an error. In V2, support for locking was defined, but
many implementations always returned successful and didn't actually do
anything. I believe that V3 gets locking right, but I don't know about fsync.
You're gonna have to test your environment...
-crl
--
Chad R. Larson (CRL22) chad(at)eldocomp(dot)com
Eldorado Computing, Inc. 602-604-3100
5353 North 16th Street, Suite 400
Phoenix, Arizona 85016-3228
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benny | 2002-10-14 08:55:06 | Opening 5432 port |
| Previous Message | jonerf1 | 2002-10-13 04:29:59 | Re: psql history gone after update to 7.2.3 resolved |