Thanks for the tips. A few questions: how does the lack of filehandles
relate to the postmaster crashing? Filehandles to what files? How did you
figure it out? (ie. did you look at logs? If so, which and how?)
Thanks in advance for the help.
Mike
mike@fieldco.com
----- Original Message -----
From: Mathieu Arnold <arn_mat@club-internet.fr>
To: Mike Field <mike@fieldco.com>
Cc: <pgsql-admin@postgresql.org>
Sent: Thursday, July 06, 2000 9:49 AM
Subject: Re: [ADMIN] Postmaster crashes
> I've had quite the same thing on a busy server, it was due to a lack of
> filehandles.
>
> Mike Field wrote:
> >
> > Hi-
> >
> > My php website interacts with a postrgres database, and every now and
then,
> > postgres just seems to crash. A simple restart of postmaster fixes the
> > problem, until it crashes again. However, I have no idea EXACTLY when
it
> > crashes (what the website users are doing at the time, if anything) and
WHY.
> > If someone has any ideas as to why it might be crashing, or how I can
find
> > out why, and what to do about it, I would appreciate the help.
> >
> > Thanks,
> >
> > Mike
> > mike@fieldco.com
>
> --
> Mathieu Arnold
>
>