Quote:
Originally Posted by eastern motors
I deleted my old database using "drop/delete" in PGAdmin and created a new DB using HM that currently has no hands in it. The postgresSQL folder is still taking up >10GB on my hard drive. What do I need to do to reclaim this space? Defrag?
Logging:
I would suggest you turn off logging on your SQL installation as well as these other performance improvements -
Top 10: HEM performance increase tips
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.
[php]------------------------------------------------------------------------------
# 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[/php]
File > Save; File > Close
Start > Programs > PostgreSQL 8.3 > Reload Configuration.
- 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 can do the Full-Vaccum/Analyze, Reindex, Stop SQL Service, Defrag, and Performance Tuning.
Quote:
Originally Posted by stressed
Will try and keep this simple as possible. (I’m a PC noob sry)
Bought HEM months ago, use it on both my laptop and work pc.
Work pc breaks, now its fixed but I need to re-install HEM on it.
Have been playing on my laptop for the past month.
Question 1:
Do I key in the same purchase code when downloading and installing HEM on my work pc again?
I have my whole database on an USB portable external drive.
Question 2:
Do I still have to install postgr on my work pc? Can I just plug in my portable drive which I have it set on I-Drive and use that?
1 - email
sales@holdemmanager.net to have your license reset.
2 -
http://www.holdemmanager.net/faq/afm...aspx?faqid=154