PDA

View Full Version : Unable to instal potgressQl



frenzy2003
06-21-2013, 11:11 AM
I just bought a new laptop and tried installing HM1 again. When using the initial installer, the erro of postgress not being able to install keeps occurring. I am using Windows 8 and google chrome as a browser.

frenzy2003
06-21-2013, 11:30 AM
in addition, I read advice on another forum to install postgress seperately using this link: http://ftp.postgresql.org/pub/binary/v8.2.22/win32/postgresql-8.2.22-1.zip

That doesn't work either. It cannot make an internal connection on m computer it says.

udbrky
06-21-2013, 06:18 PM
Here is a guide to help with issues with Windows 8 and HM.

http://forums.holdemmanager.com/general-support/346061-windows-8-upgrade-guide.html

- Please see these steps to fix postgresql installation issues:

- Please update windows fully. Please keep checking until it shows twice five minutes apart that there are no more updates.

If you have Win7 or 8 (or Vista), consider the following:
1) PC name must be in English and "in one word" - requires reboot after changing.
2) The same for Windows user name. If not - create new Win user with EN name and reboot PC for this user when install Postgres. And he must have admin rights. After installation you can kill this new user - his mission is completed.
3) Secondary logon service must be set to "Autostart".
This is a standard windows service which is available on every windows computer. In the latest versions it is not started automatically. You need to start it via control panel > administrative tools > services.
4) UAC = OFF ( How to Disable and Turn Off UAC in Windows 7 « My Digital Life )
5) Disable firewall and antivirus when installing Postgres and HM. Or uninstall them at all.
6) All installations must run "as admin" (by right-click on file). And do them as first thing after PC reboot.
7) If you want to change install path for Postgres (or to set non-default folder for database cluster) - download "standalone" installation file from Download PostgreSQL | EnterpriseDB
8) If your Windows is not in English - you have to install Postgres not in default folder in Program_Files. Create new (example: c:\postgresql) first and select it when install.
9) Install Postgres and HM separarelly, one after one. As admin. If HM (when runs for the 1st time) says "no database" - simply create it via DBControlpanel.
10) If Postgres install fails - after uninstalling don't forget to kill windows user named "postgres":
Go to Start > Programs > Accessories > Command Prompt > Right-Click > Run As Administrator
In the window that appears please type the following and press enter:
net user postgres /del
exactly as shown. You should get a confirmation if it was successful.
11) Run all pokerclients "as admin" too.


- Please update your network adapter. Open device manager and find the model #. Search google for the model # drivers to download.

- Please run the windows repair on your winsock:

How to determine and to recover from Winsock2 corruption in Windows Server 2003, in Windows XP, and in Windows Vista (http://support.microsoft.com/kb/811259)

If you are using Mcafee, Norton, Comodo or AVG for security, they have been causing a lot of issues with postgres lately. We recommend using a different program, such as Microsoft's firewall and Microsoft Security Essential. If you do feel that you need Comodo or AVG, uninstall first, install postgres, then reinstall after it is working. See this guide for Windows Firewall:

http://hm2faq.holdemmanager.com/questions/1052/Windows+Firewall+%7B47%7D+Defender+Problems

Download from Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows) - do not use 9.1 or 9.3.

Right click the setup file, click properties. Click the unblock button at the bottom.

Empty the c:\temp and/or c:\Users\Username\AppData\Local\Temp folders.

If there is still an issue, we need to know the error - it is in the temp folder - bitrockinstaller.txt file.


There's a 95% chance this is solved by giving permissions on the postgres folder.

frenzy2003
06-22-2013, 04:50 AM
When using the installer from postgresql.org I get the following error:

problem running post-install step. Installation may not complete correctly. The database cluster initialisation failed.

frenzy2003
06-22-2013, 06:21 AM
Problem solved. I installed the trial version of HM2 with postgres as a mandatory install. For some reason HM2 could install it where HM1 could not. HM1 auto uses the installed postgress, all I had to do was name my database.

udbrky
06-22-2013, 02:15 PM
Thank you for letting us know this is resolved.

Good luck at the tables,

Please let us know if we can help with anything else.