Re: Strange Postgresql crash

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 run-parts /etc/cron.hourly
02 4 * * * root run-parts /etc/cron.daily
22 4 * * 0 root run-parts /etc/cron.weekly
42 4 1 * * root run-parts /etc/cron.monthly

00 3 * * * root /export/dbsystem/pg_backup.sh va > /dev/null 2>&1
00 4 * * * root /export/dbsystem/pg_backup.sh b > /dev/null 2>&1
00 5 * * * root rsync --password-file=/etc/.rs_sec -Cauzbqr
/export/dbsystem/backup/ rsync://root(at)aquilon/rsync/

I'll move cron.daily to 4:30

brian a écrit :
> 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 machine:
>>
>> When: it crashes at night, at around 4AM, during the backup:
>>
>> 00 3 * * * root /export/dbsystem/pg_backup.sh va > /dev/null 2>&1
>> 00 4 * * * root /export/dbsystem/pg_backup.sh b > /dev/null 2>&1
>>
>> I move the vacuum to another time, just to make sure they are not in
>> conflict, who knows!
>>
>
> Is there anything else running at that time? What does /etc/crontab
> have? I ask because my fedora box has cron.daily scripts run at 4:02am
> by default.
>
> brian
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

--
Eric Rousse
514-655-1001

Telmatik inc.
204 Montarville, suite 250
Boucherville, QC, Canada
J4B 6S2

www.telmatik.com