Re: Postmaster crashes

From: Mathieu Arnold <arn_mat(at)club-internet(dot)fr>
To: Mike Field <mike(at)fieldco(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postmaster crashes
Date: 2000-07-06 15:57:32
Message-ID: 3964AC6C.7F4E2F7@club-internet.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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(at)fieldco(dot)com
>
> ----- Original Message -----
> From: Mathieu Arnold <arn_mat(at)club-internet(dot)fr>
> To: Mike Field <mike(at)fieldco(dot)com>
> Cc: <pgsql-admin(at)postgresql(dot)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(at)fieldco(dot)com
> >
> > --
> > Mathieu Arnold
> >
> >

--
Mathieu Arnold

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Anthony E. Greene 2000-07-06 18:13:59 Re: how do I set DateStyle = European in postmaster ?
Previous Message Mike Field 2000-07-06 15:21:15 Re: Postmaster crashes