Open Side Menu Go to the Top
Register
Holdem Manager Support Holdem Manager Support

07-15-2007 , 02:40 PM
Quote:

I never converted PT to SQL - How do I go about installing SQL for the first time?
Just finished this:
Postgres Installation Instructions

If you know a lot about postgreSQL or never heard of it or anything in between, could you check out the link and let me know if it is easy to follow?

Thanks,

rvg
Holdem Manager Support Quote
07-15-2007 , 03:54 PM
gogogogogogoggogogog
Holdem Manager Support Quote
07-15-2007 , 04:25 PM

Postgres Installation Instruction CHECK


Now.. Its only one thing missing!
Holdem Manager Support Quote
07-15-2007 , 04:30 PM
Quote:

Postgres Installation Instruction CHECK


Now.. Its only one thing missing!
I just tried - using the step by step by rvg, and got this:



WTF is this, and how do I fix it?
Holdem Manager Support Quote
07-15-2007 , 04:51 PM
Looks like a PostgreSQL issue with installing on Vista. There are a couple of work arounds

1) Log in as adminstrator and install postgreSQL

or

2) In the Control Panel - User Account management disable User Account Control (UAC)

or

3)
1. Start/All Programs/Accessories
2. Right-click on Command Prompt
3. Select "Run as Administrator"
4. Click OK on the dialog that appears
5. cd \[The directory where you put the install files]
6. Run the installer .msi from the command line.

Let me know what works - I'll need to update the setup guide for Postgres. Apparently version 8.3 of Postgres already has a fix for this.

rvg
Holdem Manager Support Quote
07-15-2007 , 05:00 PM
I am on XP - and

1 - I seem to be logged in as admin.


2- I dont see " disable User Account Control (UAC)" when i got to - Control Panel> User Accounts

3 - When I click Run as I get this, and pick Admin at the bottom:


I leave the password blank and then get this:
Holdem Manager Support Quote
07-15-2007 , 05:11 PM
Quote:
I am on XP
Ok, how about this:

To start the Secondary Logon service

1. Open Services from Control Panel - Administrative Tools

2. In the Name column, click Secondary Logon.

3. On the Action menu, click Start.

If the Secondary Logon service is not there then did you happen to install XP Lite or run some other program that trims down on what is running within Windows?

Thanks,

Roy
Holdem Manager Support Quote
07-15-2007 , 05:17 PM
FWIW;

Although the postgres install was manual for your program, it's not like Pokertracker's was all that easy either..you had to have some idea of what to do before you could get it to work so the same could be expected for your program.

ETA on release candidate? I want to give you some feedback but my girl gets off work in like 3 hrs so I am trying to test it soon.
Holdem Manager Support Quote
07-15-2007 , 05:22 PM
This is getting ridiculous. I think I know why I never installed SQL for PT now.

Holdem Manager Support Quote
07-15-2007 , 05:23 PM
I think that for most people getting PostgreSQL installed will be pretty easy and for everyone else we'll just have to work through it and when we get it working I'll update the PostgreSQL install page. I did look into some embedded, zero install database options but none compared to PostgreSQL in terms of power.

Release candidate for private beta testers is about 30 minutes away

rvg
Holdem Manager Support Quote
07-15-2007 , 05:30 PM
postgresql is ez to install....it really doesn't require a lot of skill/expertise
Holdem Manager Support Quote
07-15-2007 , 05:31 PM
Quote:
This is getting ridiculous. I think I know why I never installed SQL for PT now.


If you go to Properties under Action can you set the Start Type to Automatic and then click Start from there?

If that does not work then can you try typing this into a command line:

sc create seclogon binPath= "C:\WINDOWS\System32\svchost.exe -k netsvcs" start= auto DisplayName= "Seconday Logon"


Thanks!

rvg
Holdem Manager Support Quote
07-15-2007 , 05:34 PM
Very good to hear.

Once this is done you def. need to send everyone to your site forums and then def. start a new beta testers thread here as to not deal with all the clutter in this thread..

Obviously just suggestions to make your life easier and to find bug reports and stuff ..Just shoot me an e-mail if you want me to help with any of that as I said I would try my best to help.
Holdem Manager Support Quote
07-15-2007 , 05:37 PM
Quote:
postgresql is ez to install....it really doesn't require a lot of skill/expertise
Thanks for the useful post.
Holdem Manager Support Quote
07-15-2007 , 05:42 PM
Quote:
If you go to Properties under Action can you set the Start Type to Automatic and then click Start from there?
That seemed to do it.
Holdem Manager Support Quote
07-15-2007 , 06:30 PM
Here's a getting started flash video. It walks you through what will happen when you run it the first time and then you start importing, select a player, run some reports etc. Nothing really new but you'll be able to see it in action:

I'm not sure why but you might need to right click it, uncheck play and then recheck play if it doesn't start on its own.

Flash Holdem Manager Getting Started Video

rvg
Holdem Manager Support Quote
07-15-2007 , 06:49 PM
Would it be possible to choose the name (or location) or the PGSQL database(s), and would it be possible to have more than 1 database? I don't like keeping my datamined hands with my played hands. It makes it take much longer to back up.
Holdem Manager Support Quote
07-15-2007 , 06:59 PM
Quote:
Would it be possible to choose the name (or location) or the PGSQL database(s), and would it be possible to have more than 1 database? I don't like keeping my datamined hands with my played hands. It makes it take much longer to back up.
Right now there is only support for one database at a time. I have had my database over 10 million hands and it still ran well but I will consider allowing multiple DB's if it becomes an issue for people.

Thanks,

rvg
Holdem Manager Support Quote
07-15-2007 , 07:00 PM
that video is so sexy...
Holdem Manager Support Quote
07-15-2007 , 07:28 PM
Is the postgreSQL I installed several years ago for PT fine for HM?

Really looking forward to diving into your program.
Holdem Manager Support Quote
07-15-2007 , 07:36 PM
Quote:
Is the postgreSQL I installed several years ago for PT fine for HM?

Really looking forward to diving into your program.
I have tried using a PostgreSQL 8.0 DB and it was fine so it should be ok... Let me know if you have any problems using the old one and I'll add it to the Postgre Installation doc.

rvg
Holdem Manager Support Quote
07-15-2007 , 07:37 PM
Postgres install help looks foolproof - but of course you're sure to meet a better fool very shortly. (try shouting every now and then - this is NOT the password for holdem manager connections. this one IS THE PASSWORD for HOLDEM MANAGER)

The video is good - and you're right, you're a much better programmer than poker player
Holdem Manager Support Quote
07-15-2007 , 07:40 PM
Why was it taking so long to import 600 hand histories? I am really exited about your new program but with poker office which is what I use now I can import like 600 hh's in a few minutes. When do you plan on releasing this to the public.
Holdem Manager Support Quote
07-15-2007 , 07:44 PM
Quote:
Why was it taking so long to import 600 hand histories? I am really exited about your new program but with poker office which is what I use now I can import like 600 hh's in a few minutes. When do you plan on releasing this to the public.
That was 600 hand history files not 600 hands (unless that is what you meant). I think I was averaging 20-something hands/second in the video mainly because my computer was choking on the video recording software and the Dev IDE being open. Normally I get about 35ish a second which is 120K+/hr

rvg
Holdem Manager Support Quote
07-15-2007 , 08:23 PM
turn off your antivirus before installing postgres
Holdem Manager Support Quote

      
m