PDA

View Full Version : export hands to .txt by manager console



simon_cph
09-12-2009, 01:45 PM
Hi,

just exported my DB as im about to make a clean install. It all looks fine. Just one question:

The export have generated 256 .txt of total 379 MB (db in postgres was about 2-3 GB) in the folder i setup. Should i be worried about not all hands being there? 256 sounds like a std limit binary number or is this the normal procedure?

Thanks alot, Simon

fozzy71
09-12-2009, 06:24 PM
That is about the proper ratio of text file size to postgresql database size, especially if you never turned off the default logging in postgresql.


Are you doing a clean postgresql installation or HM isntallation?

HM:


Before you uninstall HM:

I want to re-install Holdem Manger without losing all of my settings and preferences. Can this be done? - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=98

You want to make sure you backup your Processed/Archived hand histories, your entire \config folder, and your exportednotes file. http://www.holdemmanager.net/faq/?f=119. I usually just copy my entire \Holdem Manager directory.

I would also make sure you manually export the database to hand history text files:

HM > Options > Database Management > Connect > Export Hands

How do I export or import hands into and from Holdem Manager? - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

Make sure you copy that folder as well as the other stuff I mentioned.

This helps to insure that if anything goes wrong with the backup/restore, you can manually import the exported files to rebuild.



If you have Vista, please verify that UAC is still off. - http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73. If it is on, please turn it off and reboot.

Turn off Windows Firewall for installing HM and PostgreSQL. You must also add exceptions to the Windows firewall, even if it is off. If you have a 3rd party firewall, uninstall it completely before installing HM/SQL - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

1) Make a backup of your C:\Program Files\RVG Software\Holdem Manager\Config folder, and any other important files mentioned earlier.
2) Uninstall HM with www.revouninstaller.com using the Deep setting.
3) If given the option, on the 2 following screens of Revo, choose the Select All > Delete buttons to remove any registry entries and leftover files.
4) Reboot your computer
5) Install the complete setup of HM: http://www.holdemmanager.com/downloads/holdemmanager.zip
6) Download the latest patch HM: http://www.holdemmanager.com/downloads/HmBetaUpdate.exe
7) Test if it for a while and see if it work
8) Close down Holdem Manager and rename the current, working \config folder to \config_original. Now copy your \config folder from step 1 and paste it to your C:\Program Files\RVG Software\Holdem Manager\ fodler, to replace the one you just renamed.
9) Test if it works again for a while
10) If your old config folder causes problems, you can paste the contents of the \config_original folder back in.
11) Now you can import any notes and hud configs.




Postgresql reinstall:


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

Vista: Turn off UAC - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=73

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 uninstalling SQL please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete the Program Files\Postgresql folders
3) run the command - start > run > cmd >

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





Logging:

I would suggest you turn off logging on your new SQL installation as well as these other performance improvements - Top 10: HEM performance increase tips
(http://208.109.95.123/forum/showthread.php?p=62613&posted=1#post62613)

To turn off logging, follow these instructions. This is the first thing I do anytime I install SQL for someone.

- Start > My Computer > Tools > Folder Options > View > UnCheck 'Hide Extensions for known file types' > OK

- C:\Program Files\PostgreSQL\data\postgresql.conf > Right-Click > Open With.. > NotePad > Check 'Always use this program'

- Scroll about half way down to ~Lines 245 - 260:

- The last line of this block of code, for the 'logging_collector', must be changed from On to Off.


------------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#------------------------------------------------------------------------------

# - Where to Log -

log_destination = 'stderr' # Valid values are combinations of
# stderr, csvlog, syslog and eventlog,
# depending on platform. csvlog
# requires logging_collector to be on.

# This is used when logging to stderr:
logging_collector = off # Enable capturing of stderr and csvlog

File > Save; File > Close

Start > Programs > PostgreSQL 8.3 > Reload Configuration.

*edit:
- Start > My Computer > C:\Program Files\PostgreSQL\data\pg_log, or C:\Program Files (x86)\PostgreSQL\data\pg_log, if you have 64 bit Vista. Delete all files in that folder. And it might be a good idea to empty your recycle bin at that point, or use a 3rd party utility like CCleaner to clean up all your junk/temporary files. You want to do this before you get to the vacuum and defrag process.


Now you should be ready to do a bulk Import From Folder

simon_cph
09-15-2009, 11:16 PM
Im doing a clean install windows xp install, hence also HEM and postgre.

Very helpfull reply, thanks alot. Will definately turn off logging in future. Regarding the Top 10: HEM performance increase tips - The link in 7.1 on Advanced postgreSQL tuning leads to the general HEM FAQ where i dont find anything on that topic..

Will running the DB on a removable HD (WD MyPassport 500G) by Firewire work? Im on a MacBook Pro notebook with somewhat limited space plus the coolness of having a portable DB for obv reasons. Is performance a concern in this setup and is it at all possible with postgres to run db a removable disc?

EDIT: to clarify; Im running XP by bootcamp

netsrak
09-16-2009, 03:34 AM
You need to check whether you can access the external harddisk in the bootcamp XP and make sure that it always has the same drive letter and is connected during the boot process.

The performance should be ok (i dont know whether Bootcamp slows down the access)

fozzy71
09-16-2009, 09:21 AM
...

Very helpfull reply, thanks alot. Will definately turn off logging in future. Regarding the Top 10: HEM performance increase tips - The link in 7.1 on Advanced postgreSQL tuning leads to the general HEM FAQ where i dont find anything on that topic.........

Start > Programs > Postgresql 8.x > Select SQL Server/Port > Registration Required Addons > Enterprise DB Tuning Wizard

They just updated stackbuilder to 2.0 and this now requires a registration for the first time. I havent yet had to register, but I will when I get my new PC later today. Once you install the tuning wizard, it has to be run from the start menu. Choose the 'Mixed' option during installation.