Category » PostgreSQL Maintenance

There were 8 articles found in this category:

1. Holdem Manager 2 Performance & Speed Modifications
   Tips and solutions to performance and speed related issues. Even if there are no issues at the moment, these suggestions will keep the databases running efficiently. Note: Most of these procedures are for advanced users only. Operating System Hardware PostgreSQL 3rd Party Software Operating ...
2. Advanced PostgreSQL Tuning
   Overview: Is there anything that can speed up PostgreSQL? Note: Advanced PC Users only!!! Solution: The following post is from 2+2 about how to speed up PostgreSQL: Note: (Use at your own risk!!!) Find your postgresql.conf file and open in notepad. Mine was in C:\Program Files\P ...
3. Reinstall PostgreSQL 8.4 while preserving database
   The following FAQ guides you through the PostgreSQL install process when you have already installed PostgreSQL 8.4 and are trying to preserve your old Database. Note: You must install the same version of PostgreSQL the old database was stored in i.e Version 8.4. Note: If you are installing ...
4. Move Database to Another Hard Drive or Partition
   Overview: How can a PostgreSQL database (Hand Database) be moved to a new Hard Drive or Drive Partition? Solution: If PostgreSQL is installed on the C drive where Windows is installed, but you want to move the Data folder i.e Database to a different partition or external hard drive to reclaim ...
5. Reinstalling on a new PC - Backup your settings ONLY
   It is recommended to use the new Backup and Restore Wizard which makes it easy to backup up all your hand history, settings, filters, hud config etc If your doing a reinstallation of HM2 and dont want to lose all your settings but dont want to backup your whole database please follow these instr ...
6. Vacuum Analyze Database
   Manual Vacuum Solution: Note: This process can take a long time on large databases. Try to do this when the computer is not in use for a long period of time. 1. Go to Start > All Programs > PostgreSQL 8.x > PG Admin III or navigate to the .exe file by going to C:\Program Files\Pos ...
7. Reinstall PostgreSQL 8.3 while preserving database
   The following FAQ guides you through the PostgreSQL install process when you have already installed PostgreSQL and are trying to preserve your old Database. Take Note of Step 11, that's the key to making this work. Note: You must install the same version of PostgreSQL the old database was s ...
8. Postgres Optimization
   Overview: Is there an easy way to optimize the postgreSQL database? Yes, there are two tools that have been added to help with this: Optimization - Vacuum/Reindex/Analyze Tuning - Scans PC Hardware and updates PostgreSQL config file To get to these options, click Options/Database Management in ...