Postgres compression error

[pkru]

When compressing database I get the following error:

7 - SQLSTATE = 23505
ERROR: duplicate key violates unique constraint
"pg_statistic_relid_att_index"
Error while executing query

How do I fix this so i can complete compression?

[prajna]

You asked this here and its also been answered.

~ Thomas
[Pokertracker support]

[ptrack pat]

Is this with PT2 or PT3 you get this error?

[pkru]

i apologize, posted to PT3 forum by accident. So what do u need me to do to get this fixed for PT2?

[ptrack pat]

I've never seen this error before, I don't know how to correct it. When did you last do a backup before you started getting this?

Do the hands import without error?

[pkru]

hands still import, using bodog hand grabber, backup lol yeah right (doh). should i just export the hands to a file and then reimport to a fresh database?

[ptrack pat]

should i just export the hands to a file and then reimport to a fresh database?

Yes, I would try this.

This table name giving the, pg_statistic_relid_att_index, is not a PT database table so it must be a system table. Therefore it appears something in your db is corrupted. So I would suggest starting a fresh db, convert that to PostgreSQL and then import just a few hands into the new PostgreSQL db and then try to do the vacuum/analyze and see if it works. If you don't get this same error again then continue to import the rest of the hands.

[pkru]

yeah that worked thanks.