Cannot delete or connect to my second database

[el_hombre]

I use two databases, one for normal (self played) imported hands and another for observed hands. But after the update to 3.07 i cannot connect to the observed hands db anymore. Even a housekeeping stops imediatly with an error message (something like: cannot connect to database). Even a restart of the pc did not help.
The normal db works without problems.

As i tried to delete the observed hands database, i got an error too, i think thats because i selected it as default database for observed hands, could this be the reason? Should i deselect the database in the "database for observed hands" field, in the pokerroom setup? And no! The database is not active!

[kraada]

That's odd - Click Start --> Programs --> PostgreSQL --> psql to 'postgres' and type dbpass at the prompt and hit enter. Type \l at the prompt that appears, how many PT3 databases do you see?

[el_hombre]

I see 6 databases:
HoldemManager
PT3_DB_mining
PT3_DB_selfplayed
postgres
template0
template1

the first is from the testversion of another poker stats tool i did not choosed to use.
the second is the mining DB i cannot connect to or delete.
the third is my normal DB which works fine.
no idea, what the others are for.

[WhiteRider]

PT3 will prevent you deleting a database when it is (or has been) active - if you really want to just delete it try doing it straight after you start PT3. Otherwise you could delete it using PGAdmin (Start > Programs > Postgres > PGAdmin). Expand 'postgres database server' to see your databases and right click your observed database and choose Delete/Drop. Be careful - deleting databases is irreversible!

If you want to try and recover it instead you could try:
1. Run housekeeping with the ReIndex option.
2. Backup and Restore the database - I'm not sure if this will help, but it could. Tutorial - Backup and Restore
3. Presumably Database > Housekeeping > Export won't work either? However, if your datamined hand histories are saved separately then you could create a new database and import them to that.

[el_hombre]

Ok thanks, a housekeeping of the mining database, with just the reindex option on, seems to work. At least PT is doing something and is not breaking up directly after the start of the housekeeping.

ok it just finished (after 6 minutes), i will now try to purge it.

[WhiteRider]

OK, let us know what happens.

[el_hombre]

Ok it is finished now, took just 2 hours. And it was a bit complicated, i just wanted to empty the db not delete it, so i had to use the purge option and then had to select all the sessions manualy (i used the advanced options in the purge menu, that was a bit easier) and after that i had to purge all players without hands too (it seems that the purging did not removed the players just their hands).
I hope the database is realy empty now, no fragments or pieces of the old hand historys that are unseen but can negativly affect my performance.
I just wondering why the afterwards vacuuming, analyzing, cache updating and clustering of this actual empty database takes 10 minutes. I expected a few seconds.

But i can activate the database now, and it is empty.

[WhiteRider]

Once the data has been removed from the database the Vacuum will have quite a bit of work to do, which will probably explain the time.
For future reference it is MUCH quicker to Delete and recreate a database than to Purge it, but it sounds like you've got everything sorted now anyway?

[el_hombre]

Yes thank you. I did not deleted it because i thought i would be easier.

[WhiteRider]

OK, cool. It doesn't matter now, of course, but Purging is quite a long process (as you will have seen) - Delete / New is nearly instant.