Re: PostgreSQL, NetBSD and NFS

That was going to be my question too.

I thought NFS didn't have some of the requisite file system behaviors
(locking, flushing, etc. IIRC) for PostgreSQL to function correctly or
reliably.

Please correct as needed.

Regards,

Greg

On Thu, 2003-01-30 at 13:02, mlw wrote:
> Forgive my stupidity, are you running PostgreSQL with the data on an NFS
> share?
>
>
> D'Arcy J.M. Cain wrote:
>
> >I have posted before about this but I am now posting to both NetBSD and
> >PostgreSQL since it seems to be some sort of interaction between the two. I
> >have a NetAPP filer on which I am putting a PostgreSQL database. I run
> >PostgreSQL on a NetBSD box. I used rsync to get the database onto the filer
> >with no problem whatsoever but as soon as I try to open the database the NFS
> >mount hangs and I can't do any operations on that mounted drive without
> >hanging. Other things continue to run but the minute I do a df or an ls on
> >that drive that terminal is lost.
> >
> >On the NetBSD side I get a "server not responding" error. On the filer I see
> >no problems at all. A reboot of the filer doesn't correct anything.
> >
> >Since NetBSD works just fine with this until I start PostgreSQL and
> >PostgreSQL, from all reports, works well with the NetApp filer, I assume that
> >there is something out of the ordinary about PostgreSQL's disk access that is
> >triggering some subtle bug in NetBSD. Does the shared memory stuff use disk
> >at all? Perhaps that's the difference between PostgreSQL and other
> >applications.
> >
> >The NetApp people are being very helpful and are willing to follow up any
> >leads people might have and may even suggest fixes if necessary. I have
> >Bcc'd the engineer on this message and will send anything I get to them.
> >
> >
> >
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
--
Greg Copeland <greg(at)copelandconsulting(dot)net>
Copeland Computer Consulting