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

[Brian Johnson]

Guillaume Courtois (address@hidden) wrote:
>
>That did the trick for me too.
>
>You run that from crontab ?
>

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



>>what options did you use?
>>
>>I use:
>>
>>vacuumdb -av
>>
>>
>>
>>Kevin Scott (address@hidden) wrote:
>>>
>>>>>To my understanding the same should be archived by useing the pgsql
>>>>>vacuum command, which finaly removes all deleted entries.
>>>
>>>>Oh yes, heard about that one not long ago. I will try tonight.
>>>
>>>>And yes, I'm on pgsql :)
>>>
>>>>>Maybe try vacuum first and if that does not help, drop the db and
>>>>>install the backup again.
>>>
>>>>... and tell us how it goes !
>>>
>>>Vacuuming did the trick, I guess my aversion to housework kept me from 
>>>thinking of
>>>that:) I'll add it to my list of chores. Thanks again - Kevin Scott
>>>
>>>
>>>
>>>_______________________________________________
>>>Phpgroupware-users mailing list
>>>address@hidden
>>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>>
>>
>>
>>
>>
>>
>>_______________________________________________
>>Phpgroupware-users mailing list
>>address@hidden
>>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>>
>
>
>
>_______________________________________________
>Phpgroupware-users mailing list
>address@hidden
>http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

--
Brian Johnson
* This is where my witty signature line would be if I bothered to edit this 
line :) *