Re: [Phpgroupware-users] Re: 9.16preRC slow

[Guillaume Courtois]

>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 ;)