Cache rebuild error

[hvayr]

Hello

When trying to do a cache rebuild, I get this error message: http://imgur.com/RixTWcF

I have Postgres 8.4.2


Can somebody help? Thanks!

[4StarGen]

update postgres

[Flag_Hippo]

How many custom stats do you have? It may be that there are too many selected to be cached and you'll need to uncheck "Cache" from some of them in the Configure -> Statistics -> Columns area.

[hvayr]

How many custom stats do you have? It may be that there are too many selected to be cached and you'll need to uncheck "Cache" from some of them in the Configure -> Statistics -> Columns area.

You mean here? http://imgur.com/i3P0aa7 This is all I have.

I unchecked cache from all of them but didn't help.

[Flag_Hippo]

Thanks. Since your PostgreSQL version (v8.4.2) is very old you could try updating to v8.4.22 but even this version is no longer supported by PostgreSQL. Our current recommended version is PostgreSQL v9.3, especially if you are on a 64bit machine, and we have a guide for upgrading PostgreSQL here.

[hvayr]

Thanks for your help so far!

So I decided to update to 9.4. I made a backup of my default database with processed hands (should I have made a backup of every db?), uninstalled 8.4 as was guided, and installed 9.4. I restored the database, but for some reason it seemed empty. There was no hands, and the size read N/A. So I decided to try again, and unistalled 9.4. Reinstalled 8.4 to make a new backup. But the same problem occurred again with restoring the db. Well, I did a bit of searching and found this thread https://www.pokertracker.com/forums/viewtopic.php?f=58&t=57926, and decided to try those instructions. So I uninstalled 9 and installed 8.4 again.

Well this time problems started right away. When I try to connect to the db with PT4, it says "Error connecting to the default database". At first it said "Is the server running on host "???" and accepting TCP/IP connections to port 5432?". I've tried to install postgres to different folders, including the one where it was originally installed. I've tried firewall on and off. I have my old data folder with all the databases still in it's original folder, but I just can't seem to connect to those anymore.

[hvayr]

Forget my previous problem, I got it to work somehow. I'll now try to do the Postgres upgrade again.

[kraada]

Good luck!