PDA

View Full Version : HM taking up a lot of disk space



UBOXER
04-29-2009, 04:32 AM
Hi,

HM(25gb) plus Postsqlgres(90gb) is taking up more than 120gb of my disk space, is there any way to reduce the amount of space HM consumes? My laptop is critically low on disk space.

Thanks in advance.

SteveDaRake
04-29-2009, 08:48 AM
Hi,

HM(25gb) plus Postsqlgres(90gb) is taking up more than 120gb of my disk space, is there any way to reduce the amount of space HM consumes? My laptop is critically low on disk space.

Thanks in advance.


+1

I have the same problem

mksmipalla
04-29-2009, 09:06 AM
How big are you pg_log folders in Postgre

morny
04-29-2009, 12:46 PM
See this thread on freeing up space http://www.holdemmanager.net/forum/showthread.php?p=32648#post32648 and also clear those logs mk mentioned

UBOXER
04-29-2009, 05:15 PM
Have read the article, does any members have any recommendations as to which is the best method for someone who is clueless to postgresql? The article is quite confusing for newbies. Example, say I want to do reindexing, how do I do that?

Thanks,

Allan

UBOXER
05-03-2009, 05:42 AM
Can anyone help? My hard disk is at a critically low level. Thanks in advance.

morny
05-03-2009, 05:42 PM
Probably the easiest way (certainly will free up most space but will take longer) is to export all your hands from the database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12, then uninstall PostgreSQL via control Panel > Programs And Features then delete the PostgreSQL folder in C:\Program Files and then install PostgreSQL again http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=176 and finally import those hands

id also consider buyin an external hard drive as there quite cheap these days

UBOXER
05-08-2009, 04:50 AM
Hi,

I have a external hard disk, do I just move the whole post postgres folder to the hard disk? After that, do I need to configure HM to read from the external hard disk? If yes, how do I do that. Thanks in advance.

morny
05-08-2009, 06:36 PM
Export the hands from the database:

Uninstall PostgreSQL then reinstall PostgreSQL on the external drive and then just create a new database and import the hands. Thats all you need to do

UBOXER
05-11-2009, 06:45 PM
Hi,

I cannot export all my hands from HM because of lack of space. Is there anyway I can configure HM dbase console to export the hands to an external drive?

Thanks.

morny
05-12-2009, 12:59 PM
Youll need to uninstall HM on that drive and reinstall it on the external drive and then do the export

UBOXER
05-19-2009, 11:58 AM
Hi again,

I moved my postgresSQL to a external drive and now HM wouldn't start. It keeps going to the database screen. 2 questions:

1. How do I tell HM that the postgresSQL folder is now on another drive?

2. Does HM and postgresSQL have to be on the same drive?

Thanks again.

morny
05-19-2009, 01:01 PM
Sorry that should have read Uninstall PostgreSQL and reinstall it on the new drive.

So to clarify:

Export the hands from the old database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

Uninstall PostgreSQL

Reinstall PostgreSQL on the new drive and then start a new database and reimport the exported hands into this

You dont need to move HM its fine where it is and dosent take up much space

Instead of exporting and importing you could also backup and restore http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=12 but i recommend exporting the hands too as a backup in case the restoring gives an issues

Sorry for the confusion

UBOXER
05-19-2009, 01:23 PM
Hi, I cannot export hands because HM will not start after I reinstall postgres folder to the new drive. HM starts at the dbase control panel and says that HM needs to know where to find the dbase. When I click on connect, it says HM cannot start the service.

morny
05-19-2009, 02:03 PM
Email me to do a teamviewer session and ill fix this up, its a bit complicated to explain.

morny@holdemmanager.net and also link to this thread

SteveDaRake
06-05-2009, 03:25 PM
How much space on an external hard-drive would I need to allocate for allow PostgreSQL to run on it?

Also I take it that means I'd have to plug my external hard-drive into my laptop while playing in order for HEM to work?

Sorry I'm such a technoob

morny
06-05-2009, 05:53 PM
Depends on the database anywhere from a few GBs to a 150gb maybe

Yes the external hard drive needs to be plugged into the laptop or PC whichever you happen to be using

dedalus
07-08-2009, 03:14 AM
hi,

do you think it would be possible to store a large database on an external hard drive on a mac while running windows through vmware?

i had problems before when running HEM through vmware on my mac.

netsrak
07-08-2009, 03:40 AM
Generally it should be possible if you make sure that the external drive always gets the same drive letter and is available all the time.

But it is a very specific configuration so there can happen some unexpected problems.

HM should work in a VM without problems. I personally run it in a virtual box.

dedalus
07-08-2009, 03:46 AM
before when i ran HEM in vmware using vista, it took up a lot of space on my hard drive - so much so, that i had to remove it. i felt like there was some memory bug/memory leak or something

do you use windows xp or vista on your mac?

i am going to try running hem through vmware again soon and see how it goes

btw, what do you mean by virtual box?

/ i know this is slightly off topic..

netsrak
07-08-2009, 03:51 AM
Virtual Box is a open source solution from sun for virtual machines: www.virtualbox.org

Why would you run Vista in a VM? It uses too much resources. Take XP and you will have less problems.

dedalus
07-08-2009, 03:52 AM
yeah i think that's where i went wrong

i am tech fish :rolleyes:

thanks

aaahshoveit
08-18-2009, 08:00 AM
Hi. Due to my database taking up too much space on my laptop I followed your instructions here:

Probably the easiest way (certainly will free up most space but will take longer) is to export all your hands from the database http://www.holdemmanager.net/faq/afm....aspx?faqid=12, then uninstall PostgreSQL via control Panel > Programs And Features then delete the PostgreSQL folder in C:\Program Files and then install PostgreSQL again http://www.holdemmanager.net/faq/afm...aspx?faqid=176 and finally import those hands

I've installed PostgresSQL 8.4 on my external hard-drive (though the previous database was created in 8.3, don't know if this should make a difference) and am currently in the process of trying to restore my database but PGadmin 3 has been running for over an hour whited out with the Not responding msg over it.
Initially when backing up my database I had the same 'not responding' issue but eventually it backed it up successfully, I was just wondering if restoring a database is supposed to take upwards of an hour (the back-up database file was about 500MB if this means anything to you though I believe my actual database is about 6-7 gigs, hopefully this is ok) and/or if I should restart it?
Or uninstall postgresSQL 8.4 and go reinstall 8.3?

Any help would be appreciated

aaahshoveit
08-18-2009, 09:18 AM
Ok I'm a bit confused. I cancelled the restore and opened up Holdemmanager. It told me it could not find my old database so I selected to run a new one and all my old info from the last database was in there including stats and hand histories.
So what the hell did I actually delete when I uninstalled postgres?
It freed up about 6/7 gigs on my laptop but I have no idea what was actually deleted or if somehow the database restore was successful despite it not responding for 2 hours and then me cancelling it?

fozzy71
08-18-2009, 10:38 AM
You can not backup a DB in 8.3 and restore it to 8.4

You need to manually export the hands, and then import them.

I can't really say what you did exactly, with out having seen your process.

Are you sure you uninstalled 8.3 and the DB you are using is on the SQL 8.4 server? Or do you have an 8.3 and 8.4 server, with databases in each?

Start > Programs > PostgreSQL > PGAdmin.

Connect to all of the SQL servers, and expand the '+ Databases' for each, then post a screen shot if you are unsure about anything you see.

To attach it to a thread in the forums, look below the post reply button when you post a new reply and you'll see a manage attachments button. Click this and attach the file.

aaahshoveit
08-23-2009, 02:05 PM
Hi there thanks for the reply. Everything seemed to be running ok so I'll leave it for now, also I spilled tea all over my laptop yesterday so I couldn't check it out the problem even if I wanted to. Thanks anyhow.

Chips8
11-06-2009, 04:47 PM
Hi, I'm running PostreSQl 8.2. Will that affect anything? If I install Sql on my external drive, which version shouldI install?

Will I also have to uninstall HEM from my C: Drive and reinstall it on the external drive.

Roughly how long will this take me? I probably have a medium sized DB.

fozzy71
11-06-2009, 05:16 PM
Hi, I'm running PostreSQl 8.2. Will that affect anything? If I install Sql on my external drive, which version shouldI install?

Ideally you want to use the exact same installer files that you used originally. If not, you can search and find installers for postgresql 8.2.



Will I also have to uninstall HEM from my C: Drive and reinstall it on the external drive.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=101



Roughly how long will this take me? I probably have a medium sized DB.

I have never done this process, so I couldnt say. I would count on a couple hours.


I would first suggest you try some of these things to free up some space:


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


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.


- 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.


You should regularly purge mined hands in your database, after purge vacuum / full analyze the database via pgadmin.
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=107
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163
and you can delete all files in the postgresql subfolder data\pg_log.

If you plan to have more hands in your database, and fear you might run out of space, you could move the postgresql installation to a different partition/drive:
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=101

and check the performance tips from the link in my signature.

Chips8
11-06-2009, 05:56 PM
[QUOTE=fozzy71;101873]Ideally you want to use the exact same installer files that you used originally. If not, you can search and find installers for postgresql 8.2.

Thanks for the quick reply. Do you think I should upgrade to 8.4 beforehand though? Or would that complicate things too much?

fozzy71
11-06-2009, 09:32 PM
I dont think it would make it any more confusing, actually easier IMO, but it will take you a lot more time if you have to export all your hands from 8.2, uninstall that and install 8.3, then import the archived and exported hands.

If you want to update postgresql, first backup everything to be sure - http://www.holdemmanager.net/forum/showthread.php?t=20754


For reinstalling SQL to a new/empty DB, please follow these steps:

1) Uninstall PostgreSQL from the Windows Control Panel.
2) manually delete or rename the Program Files\Postgresql folders
3) run the command - start > programs > accessories > command prompt > right-click > run as administrator

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
6) If you have moved/installed your DB to a non-default location, please make sure to change the 'Data Directory' path during the installation. *

*You want to create a new folder on your External named \Postgresql\8.4\data and select that when prompted during installation.



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

Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73 or else you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select "Run as admin" from the popup menu. Windows 7 you MUST set all the executables to always run as admin.

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

Chips8
11-07-2009, 10:12 PM
[QUOTE=fozzy71;101909]I dont think it would make it any more confusing, actually easier IMO, but it will take you a lot more time if you have to export all your hands from 8.2, uninstall that and install 8.3, then import the archived and exported hands.

Sorry, I'm confused again. After exporting hands + deleting 8.2 from the C: Drive, do you mean:

A) install 8.3 on C: Drive, then export hands again. then delete 8.3 from C: Drive, then install 8.3 on the external drive, or

B) Directly install 8.3 on the external drive?

Why did you mention 8.4 too?

Anyway, I'm listing the major steps I'm going to do. If you see any problems, please correct:


1) Will export my hands first

2) Uninstall 8.2 from my C: Drive

3) It seems that HEM takes up relatively little space with the PostSql database taking the most space, so I’ll leave HEM on my C: Drive.

4) Here's where I'm confused: You seem to suggest that I should just then install 8.4 on my external drive (bypassing 8.2 and 8.3)?

5) Will then import my hands into (8.2? 8.3? 8.4?) on the external drive

6) Will Hem (on my C: Drive) have problems reading data from my Sql (now on my external drive)?

thanks-

fozzy71
11-07-2009, 10:41 PM
[QUOTE=fozzy71;101909]I dont think it would make it any more confusing, actually easier IMO, but it will take you a lot more time if you have to export all your hands from 8.2, uninstall that and install 8.3, then import the archived and exported hands.

Sorry, I'm confused again. After exporting hands + deleting 8.2 from the C: Drive, do you mean:

A) install 8.3 on C: Drive, then export hands again. then delete 8.3 from C: Drive, then install 8.3 on the external drive, or

B) Directly install 8.3 on the external drive?

Why did you mention 8.4 too?

Sorry for the confusion, it was a typo.

The only bad thing about putting the DB on an external hard drive can be slow import speeds due to the USB/Firewire connections.



Anyway, I'm listing the major steps I'm going to do. If you see any problems, please correct:


1) Will export my hands first

There may be other things to export like player notes, tournament summaries, etc. Read this sticky - http://www.holdemmanager.net/forum/showthread.php?t=20754


2) Uninstall 8.2 from my C: Drive

Make sure you follow my directions and delete the postgres user from the command prompt.



3) It seems that HEM takes up relatively little space with the PostSql database taking the most space, so I’ll leave HEM on my C: Drive.

4) Here's where I'm confused: You seem to suggest that I should just then install 8.4 on my external drive (bypassing 8.2 and 8.3)?

Yep, Install 8.4 if you are going to import your hands.


5) Will then import my hands into (8.2? 8.3? 8.4?) on the external drive

6) Will Hem (on my C: Drive) have problems reading data from my Sql (now on my external drive)?

thanks-

No. When installing that postgresql version I linked to, you can first choose the inatallation path: C:\Program Files..., and on the next screen choose the data directory and pick a folder on a different drive.

Here are the instructions again for reinstalling postgresql and a new empty DB in 8.4 - http://forums.holdemmanager.com/showthread.php?t=20755