Error Connecting to Default Database?

[RonnDough]

Hi,

This happens to be almost daily

I have to create a new database several times per week

When I open PT4 I get the message "error connecting to default database" and can't even access it anymore. The size of the database is listed as N/A , Did I lose all my data?

This is a recent problem ...maybe a few months ago...Can I go back to a previous version or something ?

Please Help Me

Thank You

[Flag_Hippo]

Locate and delete the postmaster.pid file if it is present (not "postmaster.opts" which may be there too). You can find that file in C:\Program Files\PostgreSQL\9.3\data\ although you may have a different PostgreSQL version (e.g. 8.4, 9.0) or have it installed in C:\Program Files (x86). Once it's deleted, reboot and try starting PokerTracker 4 again. Also if you're using any security software (such as antivirus, firewall), please make sure to follow the instructions given in the Security Software Configuration Guide. If the trouble continues then please reproduce this issue and send us your PokerTracker4.log file along with your six or seven most recent PostgreSQL log files (which will be stored in your "C:/Program Files/PostgreSQL/x.x/data/pg_log" folder) to a Support Ticket so we can investigate further:

Tutorial: Reporting A Problem

Guide: PostgreSQL log files

[RonnDough]

Just wanted to say Thank You for the quick reply and the solution to this error.

It seems like deleting that file fixed it , so far , so good =)

[kaffee]

Hello, i have the same problem but when i delete the postmaster.pid file and reboot it appears again in the same folder

[WhiteRider]

That file should be there while PostgreSQL is running, so that isn't a problem in itself. The issue is if it is still there when PostgreSQL is not running, because then it won't start up again.

[leviathan74]

For the record, I also face the same problem; it goes away if I simply close and restart the program. It's annoying nonetheless.

[Flag_Hippo]

If you're using any security software (such as antivirus, firewall), please make sure to follow the instructions given in the Security Software Configuration Guide. If the trouble continues then please reproduce this issue and send us your PokerTracker4.log file along with your six or seven most recent PostgreSQL log files (which will be stored in your "C:/Program Files/PostgreSQL/x.x/data/pg_log" folder) to a Support Ticket so we can investigate further:

Tutorial: Reporting A Problem

Guide: PostgreSQL log files

[leviathan74]

Well, I don't think it's my security software because I have had the same firewall settings for years and this problem is relatively recent.

Can i delete the postmaster.pid file as well?

[Flag_Hippo]

Well, I don't think it's my security software because I have had the same firewall settings for years and this problem is relatively recent.

I still wouldn't rule it out and if you haven't set exceptions please do so.

Can i delete the postmaster.pid file as well?

Yes as long as PostgreSQL isn't running. postmaster.pid is a lock file created while PostgreSQL is running so if an older one is left behind for some reason then you can delete it manually to let PostgreSQL start again.

[leviathan74]

I stand corrected. I did in fact have postgres.exe blocked in my firewall. Hopefully that solves it.