PDA

View Full Version : PostgreSQL to big, can I move it?



Espo
04-30-2010, 05:39 AM
My PostgreSQL map have growth to big(4gb) and taking all my free space at C: . Can I move the PostgreSQL map to another partion (like G: or F: ) without crashing/messing up the HoldemManager database?

_Loki_
04-30-2010, 07:56 AM
AS A PRECAUTION: Even if you have the original HH's you will want to preserve your HM player notes which are in postgreSQL so do this first: -
FAQ - Hold'em Manager Poker Tracking Software :: Backup & Restore Database (http://faq.holdemmanager.com/questions/72/Backup+%26+Restore+Database)

Then do this: -
FAQ - Hold'em Manager Poker Tracking Software :: Move Database to Another Hard Drive or Partition (http://faq.holdemmanager.com/questions/368/Move+Database+to+Another+Hard+Drive+or+Partition)

###################
ALSO AND/OR...

To save space/improve efficiency you can do various things: -
FAQ - Hold'em Manager Poker Tracking Software :: Advanced PostgreSQL Tuning (http://faq.holdemmanager.com/questions/89/Advanced+PostgreSQL+Tuning)

"How to make PostgreSQL stop making those big log files (I had 8 GB of logfiles before I realized you're allowed to delete the content of the data/pg_log directory)"

Want to stop Postgre from creating those large log files, here's how - Holdem Manager Forums (http://www.holdemmanager.net/forum/showthread.php?t=8423)

FAQ - Hold'em Manager Poker Tracking Software :: Holdem Manager Performance & Speed Tweaks (http://faq.holdemmanager.com/questions/373/Holdem+Manager+Performance+%26+Speed+Tweaks)