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 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
