Re: Strange Postgresql crash - Mailing list pgsql-general

From Eric Rousse
Subject Re: Strange Postgresql crash
Date
Msg-id 455CBBFB.6050607@telmatik.com
Whole thread Raw
In response to Re: Strange Postgresql crash  (brian <brian@zijn-digital.com>)
List pgsql-general
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@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



pgsql-general by date:

Previous
From: "Ardian Xharra"
Date:
Subject: Re: Why the data changes it's value by itself!
Next
From: Eric Rousse
Date:
Subject: Re: Strange Postgresql crash