PDA

View Full Version : vacuum analyze database



hein
05-10-2010, 10:25 AM
Hi
If i will do a vacuum analyze database,The holdemmanager site opens instead of doing the vacuum analyze(faq page of managing database).In the past it works fine(i did it many times).

Greetz

_Loki_
05-10-2010, 10:54 AM
1. Go to Start > All Programs > PostgreSQL 8.x > PG Admin III or you can navigate to the .exe file by going to C:\Program Files\PostgreSQL\8.x\bin\ and click on the elephant icon called pgAdmin3.exe 2. This should bring up the following screen:


http://faq.holdemmanager.com/images/vacuum_02.jpg


3. Double click on “PostgreSQL Database Server 8.x” in the object browser window in the top left and it will prompt you for your password. This is your password that you used when setting up PostgreSQL. When you enter the correct password you should now see a screen like this:

http://faq.holdemmanager.com/images/vacuum_03.jpg

4. You then need to expand the database folder and choose the applicable database (HoldemManager by default). It may bring up a popup window about database encoding and if so click on “don’t show this tip again" and click OK.



5. Right click on the applicable database which will bring up a pop up and choose the “Maintenance” option as seen below:



http://faq.holdemmanager.com/images/vacuum_04.jpg



6. This will bring up the maintenance screen. Make sure Vacuum, Analyze and "Full" are selected. Click OK.

http://faq.holdemmanager.com/images/vacuum_05.jpg