i figured out in launching strace postmaster :)
and seeing some open failing, causing the master postmaster to crash and
with it all it's sons. It was with a PG 6.5.3, and I haven't seen it happen
again since a added an
echo 16384 > /proc/sys/fs/file-max
in my rc.local.
Mike Field wrote:
>
> 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
> >
> >
--
Mathieu Arnold