Un-install PostgreSQL 8.4

[Llanlad]

Hi guys

Im running out of HD space and want to remove PostgreSQL but not sure what is the safest way to do it.

I do not plan to play any poker over the next few months and when i do i will re-install on to a bigger HD.

Thanks in advance.

[udbrky]

Hi guys

Im running out of HD space and want to remove PostgreSQL but not sure what is the safest way to do it.

I do not plan to play any poker over the next few months and when i do i will re-install on to a bigger HD.

Thanks in advance.

Please note that reinstalling PostgreSQL will mean losing all your old data. If you have access to HM2 and your database was not corrupt then please follow these instructions for backing up your database as a precaution in case you cannot reconnect after reinstalling PostgreSQL - http://hm2faq.holdemmanager.com/ques...onfigs+work%3F

If you cannot access the database in HM2 then you can backup your database using this method: http://hm2faq.holdemmanager.com/ques...nced+Method%29 but if your database was corrupt then the best solution is to reimport all your hands from C:/HM2archive folder or if your pokersite supports it you can request all your hands and summaries and reimport them as restoring a corrupt database will just restore all the problems you had.

Once you have backed up your previous database(s) then follow the instructions below to uninstall and reinstall PostgreSQL using the same database.

1) Uninstall PostgreSQL from the Windows Control Panel.

2) Run the command - start > programs > accessories > command prompt > right-click > run as administrator and type the following and then press enter:

net user postgres /delete

3) You should get a successfully completed response if done correctly. If you get a permission type error you likely didnt run it as administrator as explained above.

4) Reboot your PC

5) Install the same version of PostgreSQL (HM2 ships with 8.4) - http://www.enterprisedb.com/products...wnload#windows - as your previous database using these instructions - http://hm2faq.holdemmanager.com/ques...rving+database
http://www.holdemmanager.com/downloads/postgres84

[Llanlad]

Thank you for the reply Chris, apologies for the delay in responding.

Out of curiosity .. how much GB does PostgreSQL 8.4 use for a standard player that has quite a few databases but not really that many hands in total .. maybe 500k - 750k hands overall.

I also use Note Caddy if that changes anything.

[udbrky]

make sure to check the folder, or use something like tree size free. Don't go by what it shows in Control Panel - Programs. It always shows 93GB there.

You can use NTFS compression on the DB folder in roaming and the postgres\data\base folder to make it smaller - http://support.microsoft.com/kb/251186

You can put your postgres data folder and the HM2 database parent folder on a different drive but if you move it from a SSD to a HDD you will suffer a decrease in performance - http://hm2faq.holdemmanager.com/ques...e+or+Partition

In HM1 there are a lot of tables that deal with a specific hand played by a specific player. In HM2 we don't have these tables, instead, for player related hand data, we use a flat file approach. Each player has his own folder and each file represents a single day. Each line within the file is a tokenized version of a single hand with incredible amounts of detail. Your overall HM2 spaced used (DB + Files) is about 2/3 of HM1 and we store probably 2-3 times as much info plus it can be accessed many, many times faster and allows us to do some things that wouldn't be possible otherwise. If you don't want the space in your Roaming folder due to limited C: file space, we do give you the option of storing this data anywhere when creating the database.

General rule is 1 million hands = 10 GB.

In reality it's: 1 million hands
HM1: 6.8 GB
HM2: 4.3 GB
PT4: 13.6 GB
HM3:* 6.0*GB

So with a 10 million hand database you need a SSD of at least 60 GB (Windows) + 100 GB = 160 GB. We use 1 million = 10 GB (instead of 6.8) because when you want to perform a vacuum/analyse or backup/restore a database it will require a LOT of disk space to perform such a task.

We recommend you maintain more than 20% free space on your system drive. Please see this FAQ to clear up some more free space - http://hm2faq.holdemmanager.com/ques...+of+Disk+Space

Please see these guide to optimize your SSD:

http://www.tomshardware.com/reviews/...weak,2911.html

http://itexpertvoice.com/home/super-...at-them-right/