Page 1 of 2
Updated version of PostreSQL
Posted:
Sun Jan 17, 2010 3:24 pm
by Mike_
Hi
I've updated my version of PostgreSQL and everything seems to have worked fine with one exception.
I accidentally created a new database and I guess the HUD is picking up data from that new database so my previous history with villains isnt being picked up.
I assume my HHs are in the default "PokerTracker3 Database"
How do I amend my settings so the database is accessed?
Re: Updated version of PostreSQL
Posted:
Sun Jan 17, 2010 6:29 pm
by kraada
Configure --> Configure HUD, and go to the Hud Options tab. Make sure every database you want the HUD to read from has a check mark next to it.
Re: Updated version of PostreSQL
Posted:
Sun Jan 17, 2010 7:42 pm
by Mike_
I have my HUD configured to Pokertracker3 database as it should be. However , I can't make Pokertracker3 my default or active database at Database > Database management. I'm getting a error message that my database is invalid.
I did a full back up before starting this and I have all my HH in my Processed folder.
Re: Updated version of PostreSQL
Posted:
Sun Jan 17, 2010 8:12 pm
by kraada
It sounds like there's only one database then.
Click Start --> Programs --> PostgreSQL --> psql to 'postgresl' (enter your password if prompted; the default is dbpass). At the prompt, type \l and hit enter and paste the results here.
Re: Updated version of PostreSQL
Posted:
Mon Jan 18, 2010 3:20 am
by Mike_
I have Start > Programs > PostreSQL8.4 > SQL Shell (psql)
Is that the one ?
Re: Updated version of PostreSQL
Posted:
Mon Jan 18, 2010 10:48 am
by WhiteRider
Yes, that should do it.
Re: Updated version of PostreSQL
Posted:
Mon Jan 18, 2010 1:38 pm
by Mike_
Re: Updated version of PostreSQL
Posted:
Mon Jan 18, 2010 3:51 pm
by WhiteRider
Yes, that's the window.
When it first opens just press enter at each prompt to accept the defaults.
When you get to the prompt that says:
postgres=#
..type \l and press enter.
Re: Updated version of PostreSQL
Posted:
Mon Jan 18, 2010 4:28 pm
by Mike_
Re: Updated version of PostreSQL
Posted:
Mon Jan 18, 2010 5:02 pm
by WhiteRider
Don't type anything on the first line - just press enter.
"psql to postgres" is not something you type - it is the Start menu option in postgres 8.3, but this is different in 8.4.