PDA

View Full Version : Cant vacuume DB



1968
06-25-2009, 08:15 AM
Have had trouble vacuuming for a while now (since I had a power outage a few months ago). I get an error saying 'please vacuum your db through pgadmin'.. is there any way to fix this?..

Also, when I try defraging my drive, I get a whole heap of PosgreSQL files that wont degrag.. what could be causing this?.. can any of these files be deleted?..

Report after degrag:



Fragments File Size Files that cannot be defragmented
3,284 480 MB \Program Files\PostgreSQL\8.3\data\base\16403\16471
3,149 639 MB \Program Files\PostgreSQL\8.3\data\base\16403\16510
3,714 684 MB \Program Files\PostgreSQL\8.3\data\base\16403\16503
9,118 856 MB \Program Files\PostgreSQL\8.3\data\base\16403\16430.3
5,948 965 MB \Program Files\PostgreSQL\8.3\data\base\16403\16468.1
3,440 1,019 MB \Program Files\PostgreSQL\8.3\data\base\16403\16456
8,393 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16453.1
8,410 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16430
8,456 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16453
4,657 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16468
8,842 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16430.2
4,221 1.00 GB \Program Files\PostgreSQL\8.3\data\base\16403\16430.1

netsrak
06-25-2009, 08:53 AM
For the vacuum see http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163. Many users have this issue.

For defragging: you must close all programs and stop the postgresql Windows Services before starting the defragmentation.

AND VERY IMPORTANT: don't touch any file in the postgresql data folder. It will crash your database.

If you know what i'm talking about: best is to boot with a Live CD and defrag from there.