Can't do manual vacuum w/ PostgreSQL

[vlee]

PostgreSQL is a pain in the butt for me.

I don't know my password for it, I've tried postgrespass, dbpass (the recommended from PT3), password, pass, all the basic stuff and the caps version of it.

So I look in the FAQ and it says I can edit a file to change md5 to "trust" which I do for both lines.

Now I am on pgAdmin III and when I try to open my database and type any password, I get this error message:

FATAL: role "postgres" does not exist

When I try typing a password with md5 instead of trust as the line values, I believe I get the standard:

FATAL: password authentication failed for user "postgres"

Can someone help me here?

[morny]

Please update to this version http://www.holdemmanager.com/downloads/Hm1.08Beta.exe and then when you try to enter the password at the database control panel stage HM will ask do you want to configure it to use any password, select yes for this and try it again.

Also make sure UAC is disabled first http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=73

[vlee]

I think I found the problem. I'm logging into the HM as postgresuser, but when I try to do a manual vacuum I only see a database for the login name postgres.

So I tried changing my HM database to the login postgres but I don't know the password. It asks if it wants me to accept any password, I choose yes but I still cannot login from HM.

[morny]

Are you sure UAC is disabled?

If it definetely is then please uninstall and reinstall postgreSQL http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177 and make sure you write down the username and password

btw postgres is there for everyone in PGAdmin so dont worry about that