Re: VACUUM ANALYZE FAILS on 7.0.3

Ok, I tried setting ulimit to unlimited inside the script. This didn't help,
still no core dump
I did get logging working though:

/usr/bin/postmaster: CleanupProc: pid 20146 exited with status 139
Server process (pid 20146) exited with status 139 at Tue Jan 23 22:32:26
2001
Terminating any active server processes...
Server processes were terminated at Tue Jan 23 22:32:26 2001
Reinitializing shared memory and semaphores
010123.22:32:26.086 [19777] shmem_exit(0)


--DC--
----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Dave Cramer" <Dave@micro-automation.net>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, January 23, 2001 5:52 PM
Subject: Re: [GENERAL] VACUUM ANALYZE FAILS on 7.0.3


> "Dave Cramer" <Dave@micro-automation.net> writes:
> > No core dump but here is the message from vacuum verbose analyze;
>
> > NOTICE:  --Relation pg_rewrite--
> > pqReadData() -- backend closed the channel unexpectedly.
>
> Can't tell much from that, except that the backend crashed, which
> *should* leave a core dump.
>
> On some platforms (eg, most Linux distros), processes started from
> system boot scripts are by default started under "ulimit -c 0", which
> prevents core dumps.  To get more information about what's happening,
> I recommend restarting the postmaster with "ulimit -c unlimited" so that
> crashed backends will leave core files.  While you're at it, make sure
> you are starting the postmaster without -S, and redirect its stdout and
> stderr into some convenient logfile.  The postmaster log might also
> contain useful info about what's going wrong...
>
> regards, tom lane
>
>