PostgreSQL Not Running

[brandi1984]

Hi,

I have to reformat my computer and am only able to boot in safe mode at the moment. I need to back up my PT2 databases, however I am not able to get PokerTracker2 running. When I open PT2, I get the following error:

Unable to connect to the database.

101 - SQLSTATE = 08001
could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on '"localhost" and accepting
TCP/IP connections on port 5432?


I get this error every time that I reboot, and am normally able to fix it by following the steps provided in other posts - going to Start->Control Panel->Administrative Tools->Services, and restarting PostgreSQL. But, since I can only boot in Safe Mode now, there are no processes listed in Services. Is there any other way to get PostgreSQL up and running? Thanks,

Brandi1984

[ptrack pat]

If you can't start PostgreSQL the only way you are going to be able to backup the database now is by backing up all of the data files. You need to backup the files in the c:\program files\postgresql\8.x\data folder where 8.x is the version number of PostgreSQL you are using, like 8.2 or 8.3.

Now, once you get your computer reformatted you will need to:

1. Create a new folder on your C drive called PostgreSQL_Data.
2. Copy all the files you backed up from the ../data folder to the the newly created c:\PostgreSQL_Data folder.
3. 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.

4. Restart the computer.
5. Open PT, go to the Utilities > PostgreSQL Settings window and enter the PostgreSQL information.
6. Go to the File > Maintain Database Names window, click the Add button, in the last field choose "Select existing PostgreSQL database" from the list. Hopefully this will open a window to allow you to select your PostgreSQL database. Select it, check the "Dflt" box on the previous window, click OK to save all changes THEN CLOSE AND REOPEN PT.

[brandi1984]

The ..\data folder is around 9 gigs; is the only option for backing up such a large file an external hard drive? If not, what's the best way to back this up? Thanks,

Brandi1984 (close to computer illiterate)

[brandi1984]

Pat,

I was able to repair my WindowsXP, and am now running out of safe mode. However, I am still experiencing error 08001. I tried to fix it using the Services->Start PostgreSQL Database, but I now receive the following error:

The PostgreSQL Database Server 8.2 on Local Computer started and then stopped. Some services stop automatically if they hav eno work to do, for example, the Performance Logs and Alerts service.

Any help much appreciated, thanks,

Brandi1984

[ptrack pat]

Go to the ../data folder. Is there a file called postmaster.pid there? If so, delete it and try to restart the service.

[brandi1984]

I only see postmaster.opts. Should I delete that?

[ptrack pat]

No, that's not the file. I have seen that removing the postmaster.pid file and restarting the service works in most cases but it you don't have such a file the problem must be something else. I would say you will have to try to backup the data files, either to an external disk or if you are able to use WinZIP/WinRAR to compress the folder you should be able to store it on a DVD if you have a functioning DVD burner.

[brandi1984]

Pat,

I'm not in need of doing a backup any longer. Just trying to get PT2 running now. Will reinstalling PostgreSQL help?

[ptrack pat]

Where you able to save anything or are you just going to start over? If PostgreSQL isn't starting then you should uninstall PostgreSQL, delete the entire remnants of the c:\program files\postgresql\8.2 folder and then reinstall PostgreSQL.

[brandi1984]

Pat,

Where can I download an 8.2.x version of PostgreSQL? The links in the PostgreSQL setup FAQ aren't working. Thanks.