View Full Version : Scheduling vacuum?
Rivers
12-03-2009, 10:11 PM
Does anyone have any idea how I can get schedule a vacuum every other day or week at a specified timing?
Thanks.
fozzy71
12-04-2009, 12:46 AM
This is probably better asked on a PostgreSQL specific forum, but I don't think it is possible.
Rivers
12-04-2009, 01:05 AM
Ok just did abit of research..
psql -h localhost -d yourdatabasename -U postgres -c "vacuum full"
then just schedule to run that command via a .bat in scheduled tasks however often you like..
Patvs
12-04-2009, 01:14 AM
BACKUP SCRIPT
Open notepad and add text: (save file as .bat and add it to system tools/task scheduler)
c:
cd "C:\Program Files\PostgreSQL\8.3\bin\"
pg_dump -U postgres -E sql_ascii -f "C:\%date%" -Fc HoldemManager
8.3 / 8.4
ascii / uft8 = encoding
HoldemManager = the name of your database
Powered by vBulletin® Version 4.2.3 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.