All i need is fresh database and PT3 working

[mohitmadaan]

Its been a while that i have used this thing on my mac and now i am confused because i had two different databases and for some reason, after i updated the PT3 today, it created a 3rd Database.

Anyways, i would like to make this work some how with a fresh database and wouldn't mind loosing my old hand history since i only have few hundred hands on this mac book. I am providing screen shots of some windows that i see and would appreciate any help.

Screen Shot of Home Windows


Screen Shot of Database management tab Note: The fresh data base was created today after the update automatically.


Screen Shot when i am trying to delete the first database



If you need any more information, please let me know. I would like this to work with a clean database with no hand history and would love to delete any stored hand history from my computer so i can have a fresh start.

your Help is very much appreciated and Good luck on the tables

[WhiteRider]

I wonder if the issue was that the first database was created in a previous version of PostgreSQL, since you now have 9.0.4 and PT3 installs 8.4 by default. If that is the case you will need to use the password dbpass to access the old database, rather than whatever password you set up when you installed 9.0.

If you set the new database to Active and Default (so that it is active every time you start PT3) then you will only see data from any hands you import from now on, whether you delete the old database and/or hand history files or not.

I also notice that your two new databases were created with a filename suggesting that the database was created in June (PT3_2011_06_24_...) - is the date set correctly on your computer? That shouldn't affect your databases, so isn't necessarily relevant.

[mohitmadaan]

I also notice that your two new databases were created with a filename suggesting that the database was created in June (PT3_2011_06_24_...) - is the date set correctly on your computer? That shouldn't affect your databases, so isn't necessarily relevant.

Thats because, in June is when i originally installed this and it created the 1st database and the date is set correctly on my computer. The 3rd database, which says fresh is one created yesterday.

[mohitmadaan]

Any update?

[WhiteRider]

Have you tried creating another new database?
If you want to start from scratch that will be the easiest way. Set it to Default and Active so that it will be used now and when you restart.
Does that work OK?

Once you have re-imported your hands (using Manual Import) and have things working you will be able to remove the old databases.

[mohitmadaan]

Have you tried creating another new database?
If you want to start from scratch that will be the easiest way. Set it to Default and Active so that it will be used now and when you restart.
Does that work OK?

Once you have re-imported your hands (using Manual Import) and have things working you will be able to remove the old databases.

This is what happens when i try to create a new database..... Should i not select the name of database?

[kraada]

Follow this tutorial and then it should work properly for you.

[mohitmadaan]

Follow this tutorial and then it should work properly for you.

This tutorial is for windows and i am looking for help on Mac

[kraada]

Open Applications --> Utilities --> Terminal.

Type:

sudo nano /Library/PostgreSQL/8.4/data/pg_hba.conf

Hit enter, type your Mac password and hit enter again (there won't be a prompt for *s, that's normal just type and hit enter).

That will bring up the file you need - scroll to the bottom, change "md5" to "trust", type ctrl-o (that's the letter) to save the file, then ctrl-x to exit.

Then restart the PostgreSQL server from the folder in Applications and you should be able to connect.

[mohitmadaan]

:
That will bring up the file you need - scroll to the bottom, change "md5" to "trust"

I am not able to find this "md5" to change it to "trust".. .is there anything i am doing wrong?