Sometimes I'm getting LOG: unexptected EOF on client connection Alex On Thu, Mar 6, 2008 at 4:06 PM, Alex Turner <armtuk@xxxxxxxxx> wrote: > Ok - the connection closed thing is happening a lot, but not much is > going into pg_log... > > Alex > > > > On Thu, Mar 6, 2008 at 4:03 PM, Douglas McNaught <doug@xxxxxxxxxxxx> wrote: > > On 3/6/08, Alex Turner <armtuk@xxxxxxxxx> wrote: > > > Ok - lookint at the pg log, it appears that the server process is seg > > > faulting :(. This might conceivably be my fault. I have 3 stored > > > procedures written in C, but they've been on the server for months, > > > and unless I didn't deploy them correctly originally I don't think > > > it's them. > > > > > > I'm thinking I need a core file. I'm guessing I just restart > > > postgresql from a user whos core file size limit is set to non zero? > > > > Or just put a 'ulimit' statement in the script that starts PG, or edit > > /etc/security/limits.conf if you're on RedHat. > > > > -Doug > > > ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend