[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Phpgroupware-users] Re: 9.16preRC slow
From: |
Guillaume Courtois |
Subject: |
Re: [Phpgroupware-users] Re: 9.16preRC slow |
Date: |
Wed, 02 Jul 2003 20:22:49 +0000 |
>yes, I run a daily cronjob script (the vacuum is after the dump in case
>something
>gets screwed up I have a day to fix it)
>
>#!/bin/sh
>pg_dumpall -c > /mnt2/hdd4/pgsql.master.dump
>vacuumdb -av
>
>
>and a weekly cronjob (I actually also do a weekly backup of this dump file,
>and as
>you can see, it gets synced via unison to my laptop on a semi regular basis ..
>so I
>have as many as three copies of my weekly dump in case everything goes to hell)
>
>#!/bin/sh
>pg_dumpall -c > /home/bjohnson/laptopsync/pgsql.master.dump
>vacuumdb -av
Ok, I've put vacuumdb in crontab.
I just keep lots of versions of dump, well my db is not very important ;)
- [Phpgroupware-users] Re: 9.16preRC slow, Kevin Scott, 2003/07/02
- Re: [Phpgroupware-users] Re: 9.16preRC slow, Bob Crandell, 2003/07/02
- Re: [Phpgroupware-users] Re: 9.16preRC slow, Brian Johnson, 2003/07/02
- Re: [Phpgroupware-users] Re: 9.16preRC slow, Chris Weiss, 2003/07/02
- Re: [Phpgroupware-users] Re: 9.16preRC slow, Guillaume Courtois, 2003/07/02
- Re: [Phpgroupware-users] Re: 9.16preRC slow, Brian Johnson, 2003/07/02
- Re: [Phpgroupware-users] Re: 9.16preRC slow,
Guillaume Courtois <=