Export never completes. How can I export tournament results?

[Russelldust]

I'm having some PostgreSQL-related problems that I've reported to technical support.
In the meantime I really want to backup/export all the tournament data I've manually keyed in using the Enter Holdem Results dialogue.

I've tried exporting by date (Database Mgmt / Export / Advanced / Tournament Hands / Export Hands) which seems to generate all the hand history files, but then fails ("invalid PostgreSQL connection object") without writing any tournament results files. Exporting my tourney data is the whole object of the exercise! :(

Database Mgmt / Backup falls at the first hurdle (I get PostgreSQL errors as soon as it starts trying to back up my database - so I'm just left with a 14KB zip file containing a few cfg files).

If I have to reinstall PostgreSQL and/or restore my database from my last backup then so be it - but I desperately want to back up my tourney results data first. The data is still intact (it's right there in the Enter Holdem Results dialogue) so I just need a way of exporting it... Please advise!

[kraada]

Try clicking Database --> Housekeeping and running a Reindex on your database - that may help get things working for you.

[Russelldust]

Reindexing fails (this is actually why I contacted tech support to begin with!)

Backup fails, export fails, reindexing / updating cache fails...
Yet PT3 otherwise seems to operate normally. I can see all my stats/reports, access tournament results, etc.

I've been advised to reinstall PostgreSQL. But I want to back up my tourney data first. Any other suggestions?

[kraada]

Please restart PokerTracker 3 with the Logging Enabled link on your start menu. Attempt reindexing one more time and let it fail, then attach your log files to a support ticket as explained in this tutorial - the detailed error message will give us considerably more information on how to proceed from here.

[Russelldust]

Thanks for the replies. Actually I've already provided logs to tech support - they just told me my PostgreSQL installation seemed to be broken, so I should reinstall it.

This still leaves me with the problem of not being able to backup my tourney results from my existing database. :(

That's why I came on here to see if there was some way I could export the data.

I'm curious as to why, fundamentally, certain PostgreSQL queries work fine (e.g. I can access my tourney results via the Enter Holdem Results dialogue) yet I can't export my tourney results using a different part of PT3's user interface. I mean, the data is still right there in my database isn't it!

[kraada]

Can you give me your ticket number? I'd like to look at that error message personally.

[Russelldust]

Have PM'd you. Cheers