PDA

View Full Version : Installing hem/postgresql to D:drive



dan233
09-25-2011, 06:21 AM
hi
3 questions

when using the combo installer to install hem and postgresql I get to choose the location THEY are to be installed to.
When I select D:drive, hem gets installed to D:drive as I wish but postgres is put on C:drive anyway.


1.why is this and how do I get postgresql to the D:drive (which has a lot of space contrary to my C:drive)?

2. If HEM is on D:drive and the pokerrooms handstorage folder is on C:drive, will this slow down HEM when it s on?

3.After uninstalling postgresql (following these steps:http://forums.holdemmanager.com/manager-general/29419-reinstalling-postgresql.html) and reinstalling it on D:drive this ERRORmessage appears:

http://img684.imageshack.us/img684/9015/postgreserror.png (http://imageshack.us/photo/my-images/684/postgreserror.png/)

regards,

fozzy71
09-25-2011, 01:04 PM
hi
3 questions

when using the combo installer to install hem and postgresql I get to choose the location THEY are to be installed to.
When I select D:drive, hem gets installed to D:drive as I wish but postgres is put on C:drive anyway.


1.why is this and how do I get postgresql to the D:drive (which has a lot of space contrary to my C:drive)?

It was a decision made to simplify the installation for the vast majority of our users.

You will want to download and install a manual postgresql installer so you can choose the installation folder path and/or data folder path - Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows)



2. If HEM is on D:drive and the pokerrooms handstorage folder is on C:drive, will this slow down HEM when it s on?

If your C and D are both similar in terms of performance you likely won't notice any difference. If the C drive is SSD then you will get the best performance if everything (poker client, hm, postgresql) is on the C.



3.After uninstalling postgresql (following these steps:http://forums.holdemmanager.com/manager-general/29419-reinstalling-postgresql.html) and reinstalling it on D:drive this ERRORmessage appears:

http://img684.imageshack.us/img684/9015/postgreserror.png (http://imageshack.us/photo/my-images/684/postgreserror.png/)

regards,

*If your windows user name has any unique 'cyrillic characters' you will need to create a new windows user and install postgresql under that user. Then you can delete the windows user once it is working.

Create a new windows user in the Control Panel > User Accounts. Make sure it is an Administrator account and name it 'temporary'.

Log in to the new 'temporary' windows user account, and install postgresql using our combo installer:

*Please update to the latest version - http://rvgsoftware.fileburst.com/HmBetaUpdate.exe

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 install 8.4.8 - Download PostgreSQL | EnterpriseDB (http://www.enterprisedb.com/products-services-training/pgdownload#windows)


Once PostgreSQL has been installed successfully you can switch back to your normal windows user account and delete the 'temporary' user from the Control Panel > User Accounts.


*If the steps above are not the solution:

This is usually a firewall or windows update issue.

Which Operating System, Firewall, and Anti-Virus are you using?


Many of those free Norton, Mcaffee, Comodo, Zonealarm, etc, 'internet security' bundles will not work well with holdem manager.

Please do the following steps, so we can get your computer to a state that we know will work with Holdem Manager:

1) Uninstall any 3rd party security software bundles.
2) Reboot your computer
3) Please install the latest version: http://rvgsoftware.fileburst.com/HmBetaUpdate.exe
4) Enable Windows Firewall's recommended settings through your Control Panel, turn off Windows Defender, and add firewall exceptions for HM and SQL - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems
5) Install Microsoft Security Essentials for antivirus/malware protection and update it - Virus, Spyware & Malware Protection | Microsoft Security Essentials (http://www.microsoft.com/security_essentials/)

Make sure windows is fully updated until 'No New Important Updates are Found' (this may require multiple restarts), including Internet Explorer 9 (even if you use a different web browser) and change your Windows Control Panel > Regional Settings Format to English (USA).

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.


Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://faq.holdemmanager.com/questions/275/Windows+Firewall+%7B47%7D+Defender+Problems


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) Install PostgreSQL 8.3.9 from this link - http://www.holdemmanager.com/downloads/Postgres_8.3.9-v1.0.7.exe

You could also try any of the other versions from the postgresql downloads page, and I would suggest you start with 8.3 or 8.2 - PostgreSQL: File Browser (http://www.postgresql.org/ftp/binary/)

Install it to a new path such as C:\PostgreSQL\8.3 instead of the default installation path.

dan233
09-25-2011, 01:24 PM
Hi
My user account(admin) doesnt contain any cyrillic characters.
I just created a folder called 8.4 on the drive I wanted to install posgresql on (As I noticed this is how postgresql is installed when using the suggested default pathway during installation.
Otherwise the postgresql folders are just spread all over the place on the HDD.My guess is that this is what caused the problem because the error message didnt appear this time.
What do you think?
So for now the problem seems to be solved. I ll let you know how it goes..

-After the installation is complete, a "stackbuilder" installation is suggested.
What is it and do I need to install it?

-quote from your reply:'It was a decision made to simplify the installation for the vast majority of our users.'
Actually it would be easier if the comboinstaller installed both hm and postgresql to the same drive chosen by the installer.(not HM on the new, selected drive, and postgresql on C:drive regardless of the path chosen by the installer.
I might be wrong..?

-quote from your reply:"then you will get the best performance if everything (poker client, hm, postgresql) is on the C."
When I try to install my ongame pokerclient on D:drive the handstorage folder seems to go to the default C:\Users\D\AppData\Local\P5\EurosportPokerFRPlay\h andhistory anyway..
however this is the folder I might eventually want on D:drive,the same drive as HM and postgresql..
Any suggestions?

fozzy71
09-25-2011, 01:36 PM
You do not need to run stackbuilder.

dan233
09-25-2011, 02:08 PM
thank you.
I edited my post with a few additional questions.. if you dont mind...:)

fozzy71
09-25-2011, 02:46 PM
Hi
-quote from your reply:'It was a decision made to simplify the installation for the vast majority of our users.'
Actually it would be easier if the comboinstaller installed both hm and postgresql to the same drive chosen by the installer.(not HM on the new, selected drive, and postgresql on C:drive regardless of the path chosen by the installer.
I might be wrong..?

Perhaps, but 98 or 99% of our customers do not change any settings during installation and performance is generally better if the database is on the fastest drive (which is typically the C drive).



-quote from your reply:"then you will get the best performance if everything (poker client, hm, postgresql) is on the C."
When I try to install my ongame pokerclient on D:drive the handstorage folder seems to go to the default C:\Users\D\AppData\Local\P5\EurosportPokerFRPlay\h andhistory anyway..
however this is the folder I might eventually want on D:drive,the same drive as HM and postgresql..
Any suggestions?

There is no reason to have the poker clients write the hand histories to the D drive, or the poker client software for that matter. Trust me, I used to do the same thing and realized what a wast of time it was. Programs and original hand histories take very little space and the performance is best when they are installed with the OS on the faster drive.

All original hands that are auto-imported get moved to an archive for performance reasons. Your \HMArchive is likely not in your \Holdem Manager directory. We normally suggest you use C:\HMArchive, but you may have put it anywhere.

The archive should be organized by \Month\DayOfMonth (example: D:\HMArchive\2009\07\31).

dan233
09-25-2011, 03:16 PM
Ok
thanks
quoting:
"and performance is generally better if the database is on the fastest drive (which is typically the C drive)."
In another thread someone said:
"You definitely want your postgresql database (\data folder) on the non-windows drive for performance reasons,"

Patvs
09-25-2011, 11:47 PM
If you have two regular harddisks. And both have the same speed.
Then ideally you should install Windows on drive I, and the postgresql database (\data folder on drive II.

If one of those drives is an SSD, or you only have one drive, install both on the fastest drive.

fozzy71
09-26-2011, 09:49 AM
Ok
...
In another thread someone said:
"You definitely want your postgresql database (\data folder) on the non-windows drive for performance reasons,"

Yes, thank you, I had forgotten about that after using a SSD for so long.

I did do this in the past, on my old computer that did not have SSD. The difference in performance was negligible at best for me, but I did not mass-table (8 - 12 at most), my database was not huge, and I wasn't really having any major performance problems before I tried it. It may make more of a difference to those that play more tables, have large databases, and are experiencing performance issues. Just make sure your spare/slave HDD for the database is of at least equal performance (7,200rpm or better, hopefully) with your C drive.

dan233
09-26-2011, 10:44 AM
Thanks for your tips
Your help is appreciated.
I am no very good with PCs.
Actually, reading through your posts, I am starting to wonder if I didnt actually put postgresql on the same HDD as windows.. just on a seperate "partition"
I have C: D: and F: (postgresql and hem and HMarchive are on D:, win7 is on C: )
any way to check this please?
http://img685.imageshack.us/img685/1161/drivesc.png (http://imageshack.us/photo/my-images/685/drivesc.png/)

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


http://img856.imageshack.us/img856/5634/drvs.png (http://imageshack.us/photo/my-images/856/drvs.png/)

fozzy71
09-26-2011, 11:44 AM
Yes, you only have one physical HDD with multiple partitions. I used to do this also, as a means of protecting the data on the other drives if I had to reformat the C drive. There is nothing wrong with doing what you have done, for protecting the data in case of catastrophic windows problems on the C drive, but I doubt you will see/notice any performance improvements.

*Edit: If you were to buy and install a new 7,200rpm, and install postgresql there, you might notice some performance improvements. 7,200rpm drives are cheap now thanks to the SSD wars.