Updated version of PostreSQL

[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?

[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.

[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.

[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.

[Mike_]

I have Start > Programs > PostreSQL8.4 > SQL Shell (psql)

Is that the one ?

[WhiteRider]

Yes, that should do it.

[Mike_]

http://img707.imageshack.us/img707/889/postgres1.png

Sorry , do you mean like this? Now what ?

[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.

[Mike_]

These are the prompts I get...

http://img709.imageshack.us/img709/2456/postgres2.png

[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.