Unable to connect to the database

[Leveh]

http://images.kipin.net/images_files/1205834508.jpg
(Wouldn't let me post the image, gave some error about determining dimensions, have to live with a direct link)

Started happening after I installed BitDefender, don't know how to fix it, the firewall isn't even enabled.

[ptrack pat]

Did you try uninstalling that program completely??

[Leveh]

I would like to keep it, it's an anti-virus program.

[ptrack pat]

There are plenty of anti-virus programs out there that don't cause conflicts with PostgreSQL. If it's the program causing the conflict then I don't know how to get around the problem.

Go to the c:\program files\postgersql\8.2\data folder. Is there a file called postmaster.pid there? If so, delete it and restart the program and see if it is able to connect then.

[Leveh]

no postmaster.pid file, but there is a postmaster.opts file.

Plenty of people use BitDefender and pokertracker in unison, it may even have nothing to do with the pokertracker problem, it was just the last thing I installed before I started getting the error. Going out and buying new AV software and paying for a new subscription, while I have money spent on an active BitDefender subscription and software is hardly a solution.

Would trying to use PT3 work?

[ptrack pat]

This problem has [b57j]NOTHING [/b57j]at all to do with Poker Tracker. It's[b57j] POSTGRESQL [/b57j]that you cannot connect to. If you can't connect to PostgreSQL then no program that uses this PostgreSQL database, be it PT2, PT3, HM whatever, is going to work.

This PostgreSQL FAQ tells about this kind of problem with the service failing to start because of firewall/anti-virus programs...
http://www.postgresql.org/docs/faqs.FAQ ... s.html#3.1

[quote57j]By far most common reasons for this are antivirus and firewalls. If you have any firewall software installed on your machine, try either disabling it or uninstalling it. If you have any antivirus software installed, you must disable it for the directories that are to be used by PostgreSQL. If that still does not help, it may be required to completely uninstall the software from the machine.

Specific issues have been reported with the nod32 antivirus product. If you are using this product, add "postmaster.exe" to the list of excluded processes (available under advanced options). This has been reported to fix the problem.

Specific issues have also been reported with McAfee and Panda anti-virus software and NetLimiter network monitoring software. While some people do have PostgreSQL working with these software packages, there is no specific or even recommend solutions that have not worked in some cases, so the issues would appear to be installation specific, sometimes even requiring uninstallation.[/quote57j]

Go to the Start > Settings > Control Panel > Admin Tools > Services window.
Find PostgreSQL Database Server in the list. Try to start it. Does it start or give an error? If it gives an error, what is it?

When did you last backup this database?

If you can't start the service, at least try the steps detailed in the above quote or uninstall that AV software and see if you can connect again. Then you can reinstall it.

[Leveh]

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

[ptrack pat]

[quote3bi]When did you last backup this database?

If you can't start the service, at least try the steps detailed in the above quote or uninstall that AV software and see if you can connect again. Then you can reinstall it.[/quote3bi]

What about the rest of what I wrote in the last post??

[Leveh]

Don't know when I last backed up my db.

I did the steps, didn't work. Uninstalled BitDefender and I'm still getting the same error.

[ptrack pat]

Since you haven't bothered to make any recent backups the only thing I suggest right now is this....

Reinstall this BitDefender AV software.

ZIP the contents of the entire c:\program files\postgresql\8.2\data folder so that you have a backup of this folder. Keep this ZIP file in a safe folder out of the PostgreSQL folder.

Use the Start > Settings > Control Panel > Add or Remove Programs window to uninstall PostgreSQL. This WILL NOT delete your data folder though.

Now, reinstall PostgreSQL 8.2.6 ( here is a link if you need it - http://wwwmaster.postgresql.org/downloa ... .2.6-2.zip )

When you get to the window that says "Initialize Database Cluster" at the top left corner - UNCHECK this box and click the Next button. This will force it to try to reuse your old data folder. Once the install is finished, RESTART the computer and then try to see if you can connect again.