PDA

View Full Version : PostGres Installation error ( Secondary Logon Service )



dustin
09-30-2008, 11:15 PM
Could somebody help me get PostGres going without the default options of creating a service? My problem is that the Secondary Logon Service was stripped from my install and PostGres does not run right without it. I can get it to install by unchecking the install as service option but it still gives me the error "Secondary Logon Service unavailable..." when finishing the installation ( its trying to run under the account I am logged in as ). I cannot recreate this service, I have tried rebuilding the entries in registry and using the create service command. The service just never starts.

I run the Start command for PostGres after the installation then load HEM and it says it cannot connect to the DB. I know it can run without this service as Pokertracker 3 installs and runs fine when using their PostGres installer that is bundled with PT3.

This machine is running Windows XP sp2 nd HEM Pro whatever the latest build is.

Anyone with experience using PostGres, I would appreciate your help.

dustin
09-30-2008, 11:32 PM
I got this working by installing PokerTracker3 with PostGres then using HEM to create a new database.

For anyone with the same problem see below

Install HEM
Install PT3 with PostGres using all default options.
Open HEM and connect to PostGres using username and password of your choosing
Let HEM configure PostGres to use your username and password
Create a new database
Set as default
Start HEM
Uninstall PT3
Do not Uninstall PostGres installed by PT3


its dirty but it should work for anyone having the same problem.

AlMore
08-30-2009, 06:21 PM
Had the same problem, great solution, problem solved :D

Stoneburg
10-28-2009, 08:47 PM
Didn't work for me, once I try connecting with HEM it won't accept any password.

I'm considering getting a software that actually fucking works consistently, if there is such a thing. Switched from PT2 to HEM, payed the max amount for both and frankly, this software is really fucking high maintenance and so full of problems I'm considering playing sites that don't allow trackers.

fozzy71
10-29-2009, 12:22 AM
Didn't work for me, once I try connecting with HEM it won't accept any password.

I'm considering getting a software that actually fucking works consistently, if there is such a thing. Switched from PT2 to HEM, payed the max amount for both and frankly, this software is really fucking high maintenance and so full of problems I'm considering playing sites that don't allow trackers.

What is the problem specifically? This thread is 2 months old.

If you need to install sql, to a clean db:

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73 or else 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 "Run as admin" from the popup menu. Windows 7 you MUST set all the executables to always run as admin.

Turn off Windows Firewall for installing HM and PostgreSQL. Once you get those installed you can add exceptions to the firewall. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

For reinstalling SQL to a new/empty DB, please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
4) reboot.
5) Install PostgreSQL 8.4, with your firewall uninstalled or turned off if windows firewall - http://www.enterprisedb.com/products/pgdownload.do#windows

Stoneburg
11-02-2009, 03:21 PM
Took close to two hours but after following your instructions I finally got it to work and the importing seems to be working as well. Cheers.

mbennedsen
11-19-2009, 10:50 AM
Hi guys.

this is probably an old thread but I googled my problem and found it.

I can't install sql. Windows 7 says I need to have "Secondary Logon Service" running.

I've tried what fozzy wrote but I still get the same error. I'm not able to run the "postgresql-8.3" file as an administator (dunno why?). I've set the three files in my Holdem Manager folder to be run as administrator though. I've tried to run the "postgresql-8.3" with "run as" and then running as my administrator (even though I don't think this should be neccesary 'cause I'm already logged in from my administrator account) but I can't for some reason.

Any help would be much appreciated as I'm getting pretty desperate. I've spend several hours on this and I'm hating life, Windows and HEM right now.

fozzy71
11-19-2009, 02:47 PM
Install this version of postgresql - http://www.holdemmanager.com/downloads/pginstaller.exe

If you get an error that the user account already exists, follow these instructions - http://forums.holdemmanager.com/showthread.php?t=20755


Once you actually get postgresql installed the instructions for the secondary logon service should work.

legendus88
11-22-2009, 10:23 AM
hey i have the same problem, tried with the last solution from fozzy, but this is what I got after like 80% of the process passed:
http://img72.imageshack.us/img72/725/sorrypostgres.png

fozzy71
11-22-2009, 02:21 PM
hey i have the same problem, tried with the last solution from fozzy, but this is what I got after like 80% of the process passed:
http://img72.imageshack.us/img72/725/sorrypostgres.png

Please email me at fozzy@holdemmanager.net, with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download the Teamviewer Quick Support Module - http://www.holdemmanager.com/downloads/TeamViewerQS.exe. Please let me know what time zone you are in and what time/days are convenient for you.

I would like to run a test client on your PC to see why our installer is failing, and what I can do to get you up and running.

norin22
12-09-2009, 04:10 PM
hi fozzy i have the same problem of legendus.
if you find why is not working can u explain here to me too?
ty

RxzzKo
12-09-2009, 04:49 PM
Install this version of postgresql - http://www.holdemmanager.com/downloads/pginstaller.exe

If you get an error that the user account already exists, follow these instructions - http://forums.holdemmanager.com/showthread.php?t=20755


Once you actually get postgresql installed the instructions for the secondary logon service should work.

I am having the same problems with the "secondary logon".
I just bought a new computer and I need to install HEM and PostreSQL and also restore my database. I created the backup using postgreSQL8.3. This installer installs 8.4; therefore, I won't be able to restore my DB, correct? Or is it infact possible to restore a 8.3 DB on 8.4?

RxzzKo
12-09-2009, 05:00 PM
I am having the same problems with the "secondary logon".
I just bought a new computer and I need to install HEM and PostreSQL and also restore my database. I created the backup using postgreSQL8.3. This installer installs 8.4; therefore, I won't be able to restore my DB, correct? Or is it infact possible to restore a 8.3 DB on 8.4?

Nevermind.... I was intalling postgreSQL using the login name "postgre2" rather than the default "postgre" because that is what it was on my old database. (Just want to make sure I install everything the same b/c I have had problems with restore before)

I changed the login name on the second screen that you enter a password and verify but I forgot to change it on the first screen that you enter and verify a password. :o

Problem resolved! :D

fozzy71
12-09-2009, 07:05 PM
hi fozzy i have the same problem of legendus.
if you find why is not working can u explain here to me too?
ty

If that installer is failing, try using this installer - http://www.enterprisedb.com/products/pgdownload.do#windows

and if that one fails, use this installer - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=176

Make sure when uninstalling any previous version that you deleted the postgres user from teh command window.

rlx
12-09-2009, 09:23 PM
hi frozzy.

I tried installing all the postgres you told us to download but itīs not installing! all of them gave me error messenge.

fozzy71
12-09-2009, 10:08 PM
What errors do you get specifically?

Please email me at fozzy@holdemmanager.net, with a link to this thread, and your forum name, so we can schedule a Teamviewer session. Download the Teamviewer Quick Support Module - http://www.holdemmanager.com/downloads/TeamViewerQS.exe. Please let me know what time zone you are in and what time/days are convenient for you.

1crazyhorse
12-19-2009, 05:22 PM
I am having the same problems with the "secondary logon".
I just bought a new computer and I need to install HEM and PostreSQL and also restore my database. I created the backup using postgreSQL8.3. This installer installs 8.4; therefore, I won't be able to restore my DB, correct? Or is it infact possible to restore a 8.3 DB on 8.4?

You can start the "Secondary Logon Service" choosing Control Panel / Performance and Maintenance / Administrative Tools / Services