database broken?

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

database broken?

Postby schwarzer » Sat Aug 09, 2008 4:21 pm

Vakuum Full/Analyze doesnt work anymore

http://www.splittyone.biz/fehler.jpg

any suggestions?

thx
schwarzer
 
Posts: 2
Joined: Sat Aug 09, 2008 4:17 pm

Re: database broken?

Postby ptrack pat » Sat Aug 09, 2008 6:50 pm

The only times I've seen this error is when people use some sort of clean-up utility program that deletes stuff off their hard drives including files that are 0kb. Doing that deletes these PostgreSQL files that may be 0kb but they are needed by the program.

Have you done this?
When did you last backup your database?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: database broken?

Postby schwarzer » Sun Aug 10, 2008 8:35 am

yes i made a O&O Full Defrag
never made a backup but still works execpt vacumize

someone gave me the advice do maintenace this database with pgadminIII
should i try it?
schwarzer
 
Posts: 2
Joined: Sat Aug 09, 2008 4:17 pm

Re: database broken?

Postby ptrack pat » Sun Aug 10, 2008 10:15 am

You could but that's probably going to fail as well.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 13 guests

cron
highfalutin