PDA

View Full Version : postgres



La Peste
02-12-2010, 06:03 AM
I just got a new computer, that has a SSD. The main drive only has 40gb of space, and the E drive has 1tb. Anyway I am able to install HEM on the E drive, but postgres seems to be forcing itself onto the C drive and I am running out of space. Is there a way to have postgres on the E drive? If there is do I need to recreate the database if I want to move postgres?

La Peste
02-12-2010, 06:04 AM
running windows 7 and latest HEM beta

morny
02-12-2010, 02:16 PM
The easiest way is to install it on E is to follow this FAQ FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL Preserving Old Database (http://faq.holdemmanager.com/questions/71/Reinstall+PostgreSQL+Preserving+Old+Database) and when you get to step 5 you should be able to specify the directory by clicking browse, youll need to reimport your hands then

La Peste
02-12-2010, 02:46 PM
I tried to do this and get this error message:

The "Secondary Logon" service is not running. The service is required for the installer to initialize the database.
Please start the service and try again.

How do I do this?

fozzy71
02-12-2010, 04:06 PM
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 > secondary logon > right-click > start AND right-click > properties > startup type: automatic.

kidpokeher
02-15-2010, 02:12 PM
Rather than start a new thread, I just wanted to confirm 1.10.02 works on the latest version of postgres (which appears to be 8.4.2 at the time of this writing). I ask because the majority of the FAQ messages refer to 8.3.

Also is 8.4.2 inside the full install or should I install that thru Postgresql.org, then install an update patch (even though this is a new computer)

Thanks,
Derek

fozzy71
02-15-2010, 02:36 PM
Rather than start a new thread, I just wanted to confirm 1.10.02 works on the latest version of postgres (which appears to be 8.4.2 at the time of this writing). I ask because the majority of the FAQ messages refer to 8.3.

It works fine. That is the version I use. We are working on new FAQs for 8.4. We only started using it a few months ago.


Also is 8.4.2 inside the full install or should I install that thru Postgresql.org, then install an update patch (even though this is a new computer)

Thanks,
Derek

Our combo installer contains 8.4.1.1 currently. If you want to use 8.4.2.2 you can get the EnterpriseDB installer from postgresql.org. Here it is on our server - http://www.holdemmanager.com/downloads/postgresql_8.4.2.1.exe

kidpokeher
02-23-2010, 02:56 AM
Thanks Fozzy,

Ran into a snag. I'm a stud player too so I need a version of PostgreSQL that will work with the now ancient PokerTracker Stud and 8.3 is the only version that works. Since your full installer uses 8.4, how would you suggest a new install on this new system?

I also had both profiles taken but I no longer need the profile on my now broken laptop (bastard airlines!) so is it easy enough to replace the second profile during installation with my new computer or is there more to the process of opening up that second installation profile once again?

One last question - I've looked but don't see Double or Nothing SnGs supported in HEM. Are they? (Stars and FT if they have them)

fozzy71
02-23-2010, 11:02 AM
Thanks Fozzy,

Ran into a snag. I'm a stud player too so I need a version of PostgreSQL that will work with the now ancient PokerTracker Stud and 8.3 is the only version that works. Since your full installer uses 8.4, how would you suggest a new install on this new system?

1) Uninstall PostgreSQL from the Windows Control Panel.
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
4) reboot.
5) Download and UnZip this file to a new folder. http://www.holdemmanager.com/downloads/postgresql.zip
6) Then run the postgresql-8.3.msi file and follow these instructions - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL (http://faq.holdemmanager.com/questions/70/Reinstall+PostgreSQL)



I also had both profiles taken but I no longer need the profile on my now broken laptop (bastard airlines!) so is it easy enough to replace the second profile during installation with my new computer or is there more to the process of opening up that second installation profile once again?

Please try using our registration system to register your current/new license. Then you will be able to retrieve or reset your own license, as needed. Registration Home Page (http://www.holdemmanager.net/Registration/)

To get your current license from your running installation of HEM: Help > Show Serial Number

You will need to sign up, login, and then reset your code, then logout/login, to verify it was reset.



One last question - I've looked but don't see Double or Nothing SnGs supported in HEM. Are they? (Stars and FT if they have them)

Yes, HEM tracks DoN's but there aren't any DoN specific filters.

kidpokeher
02-23-2010, 01:57 PM
1) Uninstall PostgreSQL from the Windows Control Panel.
2) run the command - start > programs > accessories > command prompt > right-click > run as administrator

net user postgres /delete
4) reboot.
5) Download and UnZip this file to a new folder. http://www.holdemmanager.com/downloads/postgresql.zip
6) Then run the postgresql-8.3.msi file and follow these instructions - FAQ - Hold'em Manager Poker Tracking Software :: Reinstall PostgreSQL (http://faq.holdemmanager.com/questions/70/Reinstall+PostgreSQL)

This is an install on a new computer, never installed PSQL yet but I get your drift. I was more concerned about I can keep HEM from installing 8.4 on top of my 8.3 postgresql install if I'm installing it for the first time.



Please try using our registration system to register your current/new license. Then you will be able to retrieve or reset your own license, as needed. Registration Home Page (http://www.holdemmanager.net/Registration/)

To get your current license from your running installation of HEM: Help > Show Serial Number

You will need to sign up, login, and then reset your code, then logout/login, to verify it was reset.

Another signin account? The forum signin doesn't work.




Yes, HEM tracks DoN's but there aren't any DoN specific filters.
Strange. It seemed like the few Stars DoN's that I played weren't recorded on my other computer. I'll doublecheck once the new system is working.

Thanks again.

netsrak
02-23-2010, 03:18 PM
You need to create a new account for the registration system but you can use the same name as for the forum.

kidpokeher
02-24-2010, 05:43 AM
Thanks. How do you suggest I go about installing HEM with postgresql v8.3 vs the 8.4 that is in your current full version. It's on a new system with no existing copy of HEM or postgresql. I'd like to keep only one version of postgresql running on my system if possible.

netsrak
02-24-2010, 07:55 AM
Install Postgresql 8.3 from ruby on rails postgresql open at postgresq.org (http://www.postgresq.org) and uncheck postgresql during the holdemmanager full installation procedure

fozzy71
02-24-2010, 09:25 AM
http://www.holdemmanager.com/downloads/postgresql.zip