omaha
01-11-2010, 08:31 PM
Hi all, on the competitors site, i have set postgres to ignore passwords
http://www.pokertracker.com/forums/viewtopic.php?f=45&t=4510
I need to manually vacuum hem (not sure why, but i do!)
When i load pgadmin iii, and double click on the postgrew sql database server, i get a CONNECT TO SERVER box, where i need to enter a password. I thought it would be dbpass, or something else, but nothing works!
After that, i get another bos, saying cant open file c/documents and settings////data/postgressql/pgpass.conf (error 5 access is denied)
Strangely enough, when i click on ok, i am allowed to then fiddle around with the databases (is this because i have disabled the passwords?)
Problem is, when i try to vaccuum, it 'finishes' it in a couple of seconds, which obviously nothing is done, as my hem db is 99.6 GIG! ( I have a ssd, and still get 100 hands/seconds import, even though i have not been able to do any maintenance for the entire time!)
I have tried doing everything else i can think of, but cant get a vacuum or anything done.
Is there some other way of allowing getting it done? Maybe a third party program?
All help much appreciated!
http://www.pokertracker.com/forums/viewtopic.php?f=45&t=4510
I need to manually vacuum hem (not sure why, but i do!)
When i load pgadmin iii, and double click on the postgrew sql database server, i get a CONNECT TO SERVER box, where i need to enter a password. I thought it would be dbpass, or something else, but nothing works!
After that, i get another bos, saying cant open file c/documents and settings////data/postgressql/pgpass.conf (error 5 access is denied)
Strangely enough, when i click on ok, i am allowed to then fiddle around with the databases (is this because i have disabled the passwords?)
Problem is, when i try to vaccuum, it 'finishes' it in a couple of seconds, which obviously nothing is done, as my hem db is 99.6 GIG! ( I have a ssd, and still get 100 hands/seconds import, even though i have not been able to do any maintenance for the entire time!)
I have tried doing everything else i can think of, but cant get a vacuum or anything done.
Is there some other way of allowing getting it done? Maybe a third party program?
All help much appreciated!