Problems installing postgreSQL

[Rachelmarie0226]

I downloaded Postgre and when I go to install it and choose the language as English then click start I get an error message stating "The installation package could not be opened. Verify that the package exists and that you can access is, or contact the application vendor to verify that this is a valid Windowns Installer package."

I already downloaded HEM and when I load it, it says I need to have Postgre installed. Please help!

My computer runs on Windows XP Home Edition version 2002 service pack 2.

Thanks

[fozzy71]

If you only double clicked the postgresql.zip download, you only opened it up in a preview window of sorts.

- Right-Click > Extract All to your postgresql.zip file.
- That should create a new folder with the contents, which should allow the setup to run properly.
- If you have any issues with the windows not having an Extract menu under Right-Click, try www.7zip.org.

[netsrak]

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=69

[Rachelmarie0226]

Thank you for your reply. I installed it but messed up and put my own password in during the intstallation process. It also generated some long password for me. When I try to open HEM it says "A connection to Postgre could not be made. Would you like to have HEM attempt to start the service and when I do that it still won't work.

I have no clue how to make this work. I did install Postgre though. Is there anyone that can help? Is it possible to speak to someone on the phone?

[netsrak]

Sorry but phone is not possible.

We can set it up via remote session:

Please schedule a remote support session with our support manager. Email fabio@holdemmanager.net, with a link to this thread and your forum name, so he can setup a Teamviewer (http://www.teamviewer.com) session.

[fozzy71]

While waiting to meet with fabio, you may want to read/try this:


Thank you for your reply. I installed it but messed up and put my own password in during the intstallation process. It also generated some long password for me.


you can either try to remove the password requirement entirely.


Start > Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf

The file should open with Notepad

Scroll to the bottom where you will see this code




# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
#host all all ::1/128 md5


You need to change the first 'md5' to 'trust', like this




# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
#host all all ::1/128 md5



Save, and close the file.

Click: Start > Programs > PostgreSQL 8.3 > Reload configuration



If that doesn't work, you will probably need to do a reinstall of postgresql and pay close attention to the instructions and make sure you write down any user names and passwords to be sure.



When I try to open HEM it says "A connection to Postgre could not be made. Would you like to have HEM attempt to start the service and when I do that it still won't work.

I have no clue how to make this work. I did install Postgre though. Is there anyone that can help? Is it possible to speak to someone on the phone?

Is the long password that you cant remember, stored in HM DB control panel? So the problem here isn't that you don't know the password, but that HM is using your unknown password and is still unable to connect?


First try a simple reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If you have Vista, please verify that UAC is still off. - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73. If it is on, please turn it off and reboot.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

Please try following all of these FAQs, step by step:

1) http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
2) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help at all we may want to schedule a remote support session to assist you.