Re: postmaster dies (was Re: Very disappointing performance)

Tom Lane writes...
>secret <secret@kearneydev.com> writes:
>>>>> PostgreSQL is also crashing 1-2 times a day on me, although I have a
>>>>> handy perl script to keep it alive now <grin>...
>
>> basically the server randomly dies with a:
>> ERROR:  postmaster: StreamConnection: accept: Invalid argument
>> pmdie 3
>> (then signals all children to drop dead)
>
>Hmm.  That shouldn't happen, especially not randomly; if the accept
>works the first time then it should work forever after, since the
>arguments being passed in never change.
>
>[snip]
>
>An alternative possibility is to run the postmaster under truss so you
>can see what arguments are passed to the kernel on every kernel call,
>but that'd generate a pretty verbose logfile.
>

FWIW...

If your (secret's) system uses strace, you can tell it to filter
just specific calls or groups of calls.  For example, 
 strace -f -s 256 -e trace=network -o /tmp/strace.log -p <postmaster pid>

Should trace all the network operations of the postmaster and
all the children.  I'm not sure if the socket reads/writes will
be included or not.  The -s sets the 'snapshot' length. 

Truss probably has similar options that can be enabled in some
baroque manner.

-- cary