PDA

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