Error doing Vacuum/Full Analyze - PostGres

Hold'em or Poker Tracker Hold'em related posts go here

Error doing Vacuum/Full Analyze - PostGres

Postby pj94z » Fri Jun 06, 2008 3:12 pm

Getting the following error when I do a vacuum/full analyze.

What can I do to resolve this? I want to vacuum so then I can do a full backup of my DB.

I'm assuming I will have problems with backup, if this vacuum process is having errors ?

[ img ]
pj94z
 
Posts: 26
Joined: Thu Mar 20, 2008 11:29 pm

Re: Error doing Vacuum/Full Analyze - PostGres

Postby ptrack pat » Fri Jun 06, 2008 3:57 pm

You can try reindexing as detailed here
http://www.pokertracker3.com/forums/arc ... ex+pgadmin
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Error doing Vacuum/Full Analyze - PostGres

Postby pj94z » Fri Jun 06, 2008 7:47 pm

I followed the instructions to re-index all tables.

I'm still getting the same error as above when trying to V/A.

Do I have any other options to fix or should I just export HH files since my last backup (4 months ago).

PJ
pj94z
 
Posts: 26
Joined: Thu Mar 20, 2008 11:29 pm

Re: Error doing Vacuum/Full Analyze - PostGres

Postby ptrack pat » Fri Jun 06, 2008 8:18 pm

If the reindex didn't fix the problem then that is what you'll have to do.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PokerTracker Holdem

Who is online

Users browsing this forum: No registered users and 0 guests