Mac 3.06/PostgreSQL Issues

[billbillthebill]

Hi,

My hard drive crapped out, the data was miraculously recovered, and now I'm starting over. I re-installed PokerTracker. Now when I start it up, I get the "Configure PostgreSQL Database" window filled in with defaults. I click "Create" and I get a "PostgreSQL Database Error" window with the message:

Unable to create PostgreSQL database: PT3_2010_08_13_010600
Reason: Unable to login to database (template1). Reason: could not connect to server: No such file or directory
Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

[billbillthebill]

(continued)

After a little research, I noticed that the PokerTracker installer did *not* install PostgreSQL, so I downloaded that from EnterpriseDB, installed it and let it finish up. I did not run the Application Stack Builder. I restarted PokerTracker, and the exact same thing happened. Same windows, same messages.

Might I have unintentionally re-copied something from my "old" hard drive that is mucking up the works here? From what I've read in the forums, I haven't seen this issue resolved. Please help. Thanks.

[WhiteRider]

That sounds like PostgreSQL isn't running.

Do you have "PostgreSQL 8.4" in your Applications folder?
If you do PostgreSQL 8.4 > Start Server does it work?

If you still have all of the old hand histories from your old machine then it will almost certainly be easiest to drag PostgreSQL 8.4 to the trash and re-install it, then re-import your hands to a new database. Or if you have a backup of your database(s) that would be even easier.

It is possible that you have some old information somewhere that will prevent PostgreSQL working even after you drag it to the trash and re-install, so if that doesn't work please schedule a remote assistance session where someone can logon to your computer with you and directly troubleshoot/resolve the issue. Our technicians are available from 10AM-5PM EDT and then again from 11PM-2AM EDT so please tell us what times you're available over the next few days, and what timezone you are in so that we can schedule a session.

[billbillthebill]

Thanks for responding.

When I run "Start Server," I get the error message:
pg_ctl: could not open PID file "/Library/PostgreSQL/8.4/data/postmaster.pid": Permission denied

I strongly suspect I have all the old databases. I know I have processed hand histories and some HUD logs in the ~/Documents/PokerTracker folder of the recovered data. So where would the old databases be, and how would I re-import them? Would I do it from within PostgreSQL or PokerTracker, and in either case, what are the steps?

[WhiteRider]

Databases aren't individual files - they are stored in a set of files managed by PostgreSQL.
The databases may still be there, but we need to get the postgres service running to be able to access them.

Try Start > Programs > PostgreSQL > Stop Service, then running a search on your computer for postmaster.pid and then deleting that file, then restarting the service and see if that helps.
If so, start PT3 and in Database > Database Management click New and Browse to Existing Database.

Otherwise, if you have all of your hand history files then the easiest solution will probably be to reinstall PostgreSQL and then do a Manual Import of your HH files.

[billbillthebill]

Thanks again.

Just to remind you, I'm using Mac OS, not Windows.

Anyway, launching "Stop Server" was a no go. As suggested, I uninstalled PostgreSQL, trashed the data file, then re-installed. Upon launching "Start Server," I received the following message:
pg_ctl: another server might be running; trying to start server anyway 2010-08-13 17:29:21 GMT
FATAL: lock file postmaster.pid already exists 2010-08-13 17:29:21 GMT
HINT: Is another postmaster (PID 39928) running in data directory "/Library/PostgreSQL/8.4/data"?
pg_ctl: could not start server Examine the log output.

This is from the system.log at the time:

Aug 13 12:29:15 Bills-MacBook-Pro com.edb.launchd.postgresql-8.4[32260]: postmaster cannot access the server configuration file "/Library/PostgreSQL/8.4/data/postgresql.conf": Permission denied
Aug 13 12:29:15 Bills-MacBook-Pro com.apple.launchd[1] (com.edb.launchd.postgresql-8.4[32260]): Exited with exit code: 2
Aug 13 12:29:15 Bills-MacBook-Pro com.apple.launchd[1] (com.edb.launchd.postgresql-8.4): Throttling respawn: Will start in 10 seconds

Does this help indicate what might be wrong?

[WhiteRider]

The postmaster.pid file is a lock file which used to indicate that postgres is running so it won't start again. If you can find and delete it then postgres may start.
It sounds like you might have a permissions issue, though. Have a look at /Library/PostgreSQL/8.4/data in Finder (note /Library, not user/library) and do right-click > Get Info and see what the permissions are set to at the bottom of the info window. It should be Read&Write for the postgres user and No Access for everyone.

[HondaKid]

I am having the same issues, and further cannot find a postmaster.pid file on my Mac.

[billbillthebill]

WhiteRider,

I seem to have resolved the database access issue. It may have been as simple a thing as not realizing that when I set a password on PostgreSQL, that password was the one I should use in PokerTracker. I changed the pre-populated password in the initial database setup in PokerTracker to the one I set up in PostgreSQL, and it worked!

Now I have another problem. Whenever I import hand histories (either manually or auto), PokerTracker crashes. If I manually select just a few files, it sometimes finishes with no problem. More than a couple dozen or so, however, and the application conks out on me. What could be causing this?

Thanks, as always.

[WhiteRider]

I am having the same issues, and further cannot find a postmaster.pid file on my Mac.

That sounds like PostgreSQL isn't running.

Do you have "PostgreSQL 8.4" in your Applications folder?
If you do PostgreSQL 8.4 > Start Server does it work?

If you still have all of the old hand histories from your old machine then it will almost certainly be easiest to drag PostgreSQL 8.4 to the trash and re-install it, then re-import your hands to a new database. Or if you have a backup of your database(s) that would be even easier.

It is possible that you have some old information somewhere that will prevent PostgreSQL working even after you drag it to the trash and re-install, so if that doesn't work please schedule a remote assistance session where someone can logon to your computer with you and directly troubleshoot/resolve the issue. Our technicians are available from 10AM-5PM EDT and then again from 11PM-2AM EDT so please tell us what times you're available over the next few days, and what timezone you are in so that we can schedule a session.

WhiteRider,

I seem to have resolved the database access issue. It may have been as simple a thing as not realizing that when I set a password on PostgreSQL, that password was the one I should use in PokerTracker. I changed the pre-populated password in the initial database setup in PokerTracker to the one I set up in PostgreSQL, and it worked!

Now I have another problem. Whenever I import hand histories (either manually or auto), PokerTracker crashes. If I manually select just a few files, it sometimes finishes with no problem. More than a couple dozen or so, however, and the application conks out on me. What could be causing this?

Thanks, as always.

OK, great.

Auto Import is not designed to handle a lot of hand history files, but obviously PT3 should not crash like that.
Firstly, please enable logging and report your problem - your log files should help us find and fix this crash.

When you've done that please do a Manual Import of all of the hand history files from your sites' HH folders. See the Mac Files and Foldersfor where these are if you don't know.
When you have imported them, move all the files to the Processed folder - see the Tutorial: Preventing Duplicates (this is written using Windows, but the same applies to Mac).

Auto Import should now work fine.