Re: postgres idle process and other problems

On Mon, Dec 03, 2001 at 09:59:27AM -0500, Tom Lane wrote:
> Is there a core dump file left over from that crash?  (Look in the
> $PGDATA/base/nnn subdirectories.)
>
>             regards, tom lane

No there isn't. All the directories look like this:

--<snip>--
[root@nizza base]# ls
1  18719  18720  25493
[root@nizza base]# cd 1
[root@nizza 1]# ls
1215  16567  16867  17074  17112  17139  17160  17181  17213  17261
1216  16579  16934  17086  17115  17142  17163  17184  17216  17273
1219  16600  16948  17097  17118  17145  17166  17187  17228  17276
1247  16617  16960  17100  17121  17148  17169  17190  17231  17288
1249  16642  17033  17103  17124  17151  17172  17193  17243
pg_internal.init
1255  16653  17045  17106  17133  17154  17175  17196  17246  PG_VERSION
1259  16685  17058  17109  17136  17157  17178  17201  17258
--</snip>--

Any ideas what might have happened?

Should we be worried about the idle process thing?

Regards,
Peter