PDA

View Full Version : postgres problem where the hell is my database?



mikeyb182
06-02-2011, 09:35 PM
when starting HM i get this

Failed to establish a connection to '127.0.0.1'.

i have no idea why this has come about, i have tried the steps suggested to another user

stop and starting service

and deleting .pid file.

neither of these have helped!

iv now tried the fix posted in the stickys by morny, that has not fixed the problem either

what can i do!!!!!!!!

Patvs
06-02-2011, 10:53 PM
Which Operating System, Firewall, and Anti-Virus are you using?

For W7 and Vista you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select properties... then select "Run as admin" from the compatibility tab.

Turn off UAC and reboot: How to Disable and Turn Off UAC in Windows 7 « My Digital Life (http://www.mydigitallife.info/2008/12/30/how-to-disable-and-turn-off-uac-in-windows-7/)

Add exceptions to the windows firewall for those files, even if the firewall is turned off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily.

Do the same for pg_ctl.exe (responsible for starting the PostgreSQL server) and postgres.exe. Both files are in the PostgreSQL/8.4/bin folder.


----

And reinstall PostgreSQL using the installer from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

mikeyb182
06-04-2011, 09:19 PM
OS is windows 7 ultimate

they are set as you asked

problem still persists

Patvs
06-04-2011, 10:00 PM
Turn on secondary logon: The secondary logon service 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. Starting it once should insure it works in the future also.

Turn off User Account Control: How to Disable and Turn Off UAC in Windows 7 « My Digital Life (http://www.mydigitallife.info/2008/12/30/how-to-disable-and-turn-off-uac-in-windows-7/)

Run a manual Windows Update and install ALL updates. (make sure Windows 7 is updated to Service Pack 1)



If you can't connect to the old database (I'm assuming you were using SQL 8.4 on port 5432).... try installing a different version of PostgreSQL on a different port to see if that will run.

Try installing PostgreSQL 9.0.4 to port 5433 from PostgreSQL: The world's most advanced open source database (http://www.postgresql.org)

Password during installation is: "postgrespass"
If it doesn't accept that, delete the postgres user first.

click on Start and go to Programs -> Accessories -> Command Prompt

* If you are on Vista, rightclick and choose "Run as Administrator".


A black box should appear. Type 'net user postgres /delete' (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.