Category » PostgreSQL Problems

There were 10 articles found in this category:

1. Can't Connect / Failed to Start PostgreSQL
   Overview: Quick Solution Basic PostgreSQL Troubleshooting Testing PostgreSQL Connection PostgreSQL Still Doesn't Work (Read the FAQ Below First) Delete Postmaster.pid file Please delete the C:\Program Files\postgresql\8.x\data\postmaster.pid file, if you see it. The file may not be there but ...
2. Password Issues (PostgreSQL)
   Overview: If you are having PostgreSQL password issues, see below: Solution: ("postgrespass" or "dbpass" are the common Passwords people forget) Note: If you are migrating to Holdem Manager from a competitors product, your postgres password is more than likely "dbpass." If you came h ...
3. Holdem Manager Performance & Speed Tweaks
   Overview: The following are tips and solutions to performance and speed related issues. Even if you don't have these issue's many of the these suggestions can keep your database running efficiently. NB: Some of these procedures are for advanced users only, don't try any procedures that you&rsqu ...
4. Fix Indexes
   Overview: I'm getting an error relating to one of the indexes. Solution: If you get an error similar to the one in the screenshot below, then your index has become damaged. You first need to identify what index is damaged. It will be in quotes, so we can see from the above error that t ...
5. Using Kaspersky Internet Security 2010?
   Overview: There's a known issue that prevents PostgreSQL from communicating with Holdem Manager when Kaspersky Internet Security 2010 is installed. Solution: - You can completely uninstall Kaspersky and go with a free Anti-Virus solution. (AVG & Avast are recomended.) - Or you can ...
6. Large Log Files
   Overview: Log Files are taking up GB of space on my Hard Drive. Can I prevent this? Solution: Yes, PostgreSQL log files can become very large. Follow the steps below to eliminate your log files altogether: Note: This is for Advanced PC Users only!!! 1. First you will want t ...
7. Windows Update
   Overview: Occasionally Windows Update will cause your PostgreSQL connection to fail. Note: This is very rare. If Windows recently did an update on your computer you might need to roll back the most recent Windows Update to get PostgreSQL working again. 99% of the time PostgreSQL problems are ...
8. FAT / NTFS Drive Issues
   Overview: At the initialize database cluster page during the PostgreSQL installation I'm getting an error message. It tells me the database must be on NTFS formatted volumes not FAT volumes. Note: This is happening because your hard drive is formatting in FAT and not NTFS. Note: This is f ...
9. Software Security Problems (Firewall)
   Overview: Holdem Manager requires PostgreSQL to be installed and running for Database queries. If you have any of the following software products installed on your machine, please read the directions on how to solve a software security conflic with PostgreSQL and Holdem Manager. If this still d ...
10. Windows Firewall / Defender Problems
    Overview: Step by Step Guide for solving PostgreSQL problems related to Windows Firewall and Windows Defender. Test Firewall and Defender First: Note: Double Check that all Software Security programs are completely removed from your PC before proceeding. Turn off Windows Firewall - ...