Re: [GENERAL] Strange Postgresql crash

2006-11-16 Thread Eric Rousse
Hi Tom, Yeah, that's what I suspect it seems more like a hardware/os issue. Since, I really have no proof against PostgreSQL, other than my daily dump that crashes *sometimes*. I didn't know about badblocks, I'll try this one. Last time I did a full fsck check on all the volumes, and everythi

Re: [GENERAL] Strange Postgresql crash

2006-11-16 Thread Eric Rousse
duh! right. I didn't thought about this one!! but the strange thing though is that it doesn't happen frequently, only recently it started to crash regularly. here's the content of the crontab: SHELL=/bin/bash PATH=/sbin:/bin:/usr/sbin:/usr/bin MAILTO=root HOME=/ # run-parts 01 * * * * root ru

Re: [GENERAL] Strange Postgresql crash

2006-11-16 Thread Tom Lane
Eric Rousse <[EMAIL PROTECTED]> writes: > ... > 2006-11-16 04:00:39 [8763] LOG: connection received: host=10.1.1.54 > port=4894 > 2006-11-16 04:00:40 [8763] LOG: pq_recvbuf: unexpected EOF on client > connection > 2006-11-16 04:00:40 [8763] LOG: incomplete startup packet > 2006-11-16 04:

Re: [GENERAL] Strange Postgresql crash

2006-11-16 Thread brian
Eric Rousse wrote: Hello all, I've been experiencing strange crash, never really took care of it since it was happening only every 1-2 months or so. But lately, I've seen it a lot in the past week and I have no clue about it, other than the backups. So, here's some info about it and about my

[GENERAL] Strange Postgresql crash

2006-11-16 Thread Eric Rousse
Hello all, I've been experiencing strange crash, never really took care of it since it was happening only every 1-2 months or so. But lately, I've seen it a lot in the past week and I have no clue about it, other than the backups. So, here's some info about it and about my machine: When: it