Database Error:

[jmillerdls]

Will starting a new database fix this? Is opening PT suppose to be the thing that triggers PostgreSQL to start? I'll just start a new database if that will fix it (I need PT to play).

[ptrack pat]

The problem isn't with Poker Tracker, it's with PostgreSQL. You can start a new ACCESS database but not PostgreSQL until you get this problem fixed.

Here is what you will need to do to fix the problem since you never backup the database.

1. Create a new folder on your C drive called PostgreSQL_Data.
2. Go to the c:\program files\postgresql\8.2 folder. Right-click on the "data" folder and select "Copy" from the popup menu.
3. Go to the newly created c:\PostgreSQL_Data folder and right-click and select "Paste" from the popup menu.
4. Now, go to the Start menu and select Settings > Control Panel > Add or Remove Programs and then remove PostgreSQL 8.2 from the list.
5. From the Start menu again select Run. On the window that opens type "COMMAND" and hit OK. This will open a DOS window. Type the following next to the prompt...

net user postgres /delete

and hit ENTER to run it. Then type EXIT to close the DOS window.

6. Now, download and reinstall PostgreSQL as directed here:
http://www.pokertracker.com/products/PT ... nstallSQL2

WITH THE EXCEPTION THAT on the second window where it asks you where you want to install PostgreSQL click on the "Data Directory" button and navigate to the c:\PostgreSQL_Data\data folder and select that. This will force it to try to reuse your old data.

CONTINUE until you get to the window that has the "Initialize Database Cluster" box at the top left corner. UNCHECK THIS BOX and click the Next button and then just continue installing from there.

7. Once the install is done, RESTART YOUR COMPUTER and then try to open PT again.

[jmillerdls]

alright...that's a lot of steps, I'll try it a bit later. Thanks.

[jmillerdls]

Just one last question...do I install it "IN" the data folder, or in the folder with the data folder so that it uses my old data folder?

[ptrack pat]

You install PostgreSQL in the default folder, c:\program files, the only thing you are doing is changing the location of the ../data folder so that it reuses your old data files, everything else should be left at the default values.

[jmillerdls]

Damnit, did everything exactly as described, restarted and got the exact same error. Went to services to start it up:

Could not start the PostgreSQL Database Server 8.2 service on Local Computer.

Error 1053: The service did not respond to the start or control request in a timely fashion.



Can I just wipe everything related to PostgreSQL off my computer, re-install it and start a new database? Will that fix these issues? If so, I'd love the correct steps needed to do that the best way. I really just want to play, and I need PT to do that.

[jmillerdls]

Ok...I guess I'm just going to uninstall everything and start a new database. I have no clue what started all this, or whether this will fix it, but hopefully so.

[jmillerdls]

It seems to have worked...hopefully it doesn't break again.

[ptrack pat]

Are you using PostgreSQL or just a new Access database? If you want me to try to recover your PostgreSQL database ZIP the contents of the c:\PostgreSQL_Data folder and let me know of the size of the ZIP file.