Page 1 of 2

Updated version of PostreSQL

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: Mon Jan 18, 2010 10:48 am
by WhiteRider
Yes, that should do it.

Re: Updated version of PostreSQL

PostPosted: Mon Jan 18, 2010 1:38 pm
by Mike_
http://img707.imageshack.us/img707/889/postgres1.png

Sorry , do you mean like this? Now what ?

Re: Updated version of PostreSQL

PostPosted: 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

PostPosted: Mon Jan 18, 2010 4:28 pm
by Mike_

Re: Updated version of PostreSQL

PostPosted: 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.

highfalutin