Updated version of PostreSQL

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Updated version of PostreSQL

Postby Mike_ » Sun Jan 17, 2010 3:24 pm

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?
Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Re: Updated version of PostreSQL

Postby kraada » Sun Jan 17, 2010 6:29 pm

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Updated version of PostreSQL

Postby Mike_ » Sun Jan 17, 2010 7:42 pm

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.
Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Re: Updated version of PostreSQL

Postby kraada » Sun Jan 17, 2010 8:12 pm

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.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Updated version of PostreSQL

Postby Mike_ » Mon Jan 18, 2010 3:20 am

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

Is that the one ?
Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Re: Updated version of PostreSQL

Postby WhiteRider » Mon Jan 18, 2010 10:48 am

Yes, that should do it.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Updated version of PostreSQL

Postby Mike_ » Mon Jan 18, 2010 1:38 pm

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

Sorry , do you mean like this? Now what ?
Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Re: Updated version of PostreSQL

Postby WhiteRider » Mon Jan 18, 2010 3:51 pm

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.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: Updated version of PostreSQL

Postby Mike_ » Mon Jan 18, 2010 4:28 pm

Mike_
 
Posts: 193
Joined: Tue Nov 04, 2008 1:58 pm

Re: Updated version of PostreSQL

Postby WhiteRider » Mon Jan 18, 2010 5:02 pm

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.
WhiteRider
Moderator
 
Posts: 53961
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 8 guests

cron
highfalutin