PDA

View Full Version : Problem: Vacuum database



alexx000
10-18-2008, 08:39 AM
I click Options - Vacuum Analyze. There is a message There was error during the vacuum. Please manually vacuum your database through pgadmin
Why?

Win XP, Postgresql 8.3, TitanPoker

I compress base pgadmin, but its size does not decrease

Rvg72
10-19-2008, 07:54 PM
You need to do a full vacuum in order for it to reclaim disk space. I am aware that many people are not able to use the built in vacuum and I am working on it

Roy

Buconero
10-22-2008, 07:06 AM
I too have this problem. One thing that does occur to me is that I do not have the default password for the user postgres. Is it possible that the password has been hardcoded in that section of your code? I guess this is something you've probably checked but I thought I'd state it anyway just in case.

Apart from this HM is fantastic and I'm enjoying using it.

morny
10-22-2008, 09:50 AM
Good shout but i rememeber my password and i cant do it either so i dont think its that, thanks for the suggestion though