In Trouble...

[showtime89]

Today i was playing and my PC went off...
When i turned it on again and open HM an error appeared "Failed to establish a connection to ‘127.0.0.1’ Service 'PostgreSQL Database Server 8.x' (pgsql-8.x) failed to start. Verify that you have sufficient privileges to start system services"

This happend to me before and i solved it by deleting postgres and re installing it again.

I did it and an other error appeard " The following error ocurred when trying to open the database. holdemmanager database does not exist."

Thats my name of my DB. By that time when i clicked in conect it allowed me to create an other DB but i didn´t do it.

Then i realised that i installed an other version of postgres (newer), but i read in a forum that i should install the same that i had before...

I did it but now an other error appeared, the first line appeared when i started HM and then this when i clicked to conect.

http://img859.imageshack.us/img859/230/97841523.jpg (http://imageshack.us/photo/my-images/859/97841523.jpg/)

Uploaded with ImageShack.us (http://imageshack.us)

Now i don't have any postgres installed. Please help me!

[Patvs]

This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

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

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

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it. And reboot.


If that doesn't help you will have to reinstall PostgreSQL completely

Which SQL version did you use before?
Install it on the same port as before (and make sure no other SQL installation is using the same port)

[showtime89]

Ok. In order to do any of that i have to have the version of postgres that i had before installed.

This appeard when i tried to install postgres recently...

http://imageshack.us/m/9/7024/90935503.jpg (http://imageshack.us/photo/my-images/9/90935503.jpg/)

Uploaded with ImageShack.us (http://imageshack.us)

[Patvs]

Which SQL version are you trying to install?

You can deselect "Initialize database cluster" during installation.

---

Password during installation is: postgrespass
If it doesn't accept that as password, 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.

[showtime89]

I have W7.

Im trying to reinstall 8.3 version...

The problem may be because before i installed 8.4 version, now i erased but may be the problem is because im trying to install an older version than the one that i had installed last...Or not?

I have deleted the user name were you told me to but it rejects the pass that you gave me, it accepts the pass that i had before...But in the window of initialasing db cluster the same thing appeard...

[Patvs]

Is it crucial you can connect to your old SQL 8.3 database? (because you have notes in the database, you have no backup of?)

Otherwise try installing SQL 9.0.x (or 8.4.x) to port 5433--> connect to that---> reimport your archive folder C:/HMArchive. In other words... start with a fresh new database, then reimport all the original handhistories.


----

Errors during installation (SQL 8.3)
Double check the secondary login is running: 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.

Run a manual Windows Update, install all updates (service pack 1).. even all the .net framework updates.
Turn off User Account Control on your computer.
Please update to the latest beta - http://www.holdemmanager.com/Downloads/HmUpdate.exe

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. (or simply turn off User Account Control and reboot)

Which Firewall, and Anti-Virus are you using?
Add exceptions to the windows firewall for those files, even if the firewall is turned off. Do the same for: pg_ctl.exe (responsible for starting the PostgreSQL server) and postgres.exe


---


If you uninstalled SQL 8.4... installing an older version of SQL now shouldn't give any problems.

[showtime89]

I dont think that is crusial for me. I have the folders with the hands in de desktop. I supose i can re import from there...Or not?

If this is possible, i dont mind on creating a new DB or anything...Just tell me how to fix this in the easyest way...

Sorry but im quite unexpirenced on this and on top im writting in an other language...

[netsrak]

Yep, you can import the hands into the new database via import file or import from folder.