I'm uselss and need help with postgreSQL

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

I'm uselss and need help with postgreSQL

Postby mellemel » Mon Feb 01, 2010 12:28 am

I've been running PT2 for a long time. i've just installed PT3. It's asked me for server, port, username and password for postgreSQL. Where do I find these things? Thanks.
mellemel
 
Posts: 7
Joined: Mon Sep 15, 2008 11:25 pm

Re: I'm uselss and need help with postgreSQL

Postby tarix » Mon Feb 01, 2010 12:34 am

Do you already have postgres installed?
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Re: I'm uselss and need help with postgreSQL

Postby mellemel » Mon Feb 01, 2010 10:56 pm

I assume so, beacuse the ppo-up I get when I open PT3 is for existing postgreSLQ rather than installing it new, and when I search my system for postgreSQL some files come up (which I don't understand).
mellemel
 
Posts: 7
Joined: Mon Sep 15, 2008 11:25 pm

Re: I'm uselss and need help with postgreSQL

Postby kraada » Tue Feb 02, 2010 9:26 am

Click Start --> Programs, do you see an entry for PostgreSQL 8.3 (or 8.4)? If so, click in there and click Start Service and then try putting in the defaults into PT3 (server = localhost, port = 5432, user = postgres, password = dbpass) and see if it connects for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: I'm uselss and need help with postgreSQL

Postby mellemel » Wed Feb 03, 2010 10:50 am

No, when I click Start --> Programs, there is no entry for PostgreSQL 8.3 (or 8.4). Does that mean I have to install it? Some files still show up on my computer if I search for PostgreSLQ, FWIW. I'm sorry I'm useless about this and I appreciate your help.
mellemel
 
Posts: 7
Joined: Mon Sep 15, 2008 11:25 pm

Re: I'm uselss and need help with postgreSQL

Postby kraada » Wed Feb 03, 2010 11:23 am

It sounds like you don't have PostgreSQL installed. Please download, unzip and run the installer from this package and that should install PostgreSQL for you.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: I'm uselss and need help with postgreSQL

Postby mellemel » Thu Feb 04, 2010 1:45 am

It's up and running - thanks for your patience. Just one last question - is there any way to get my data from PT2 into PT3? Thanks.
mellemel
 
Posts: 7
Joined: Mon Sep 15, 2008 11:25 pm

Re: I'm uselss and need help with postgreSQL

Postby kraada » Thu Feb 04, 2010 9:24 am

Yes, the easiest way is to export your hands from PT2 (Utilities --> Export Hand History ...) then reimport them into PT3. This will get all of your data unless you have manually entered tournament summaries.
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: I'm uselss and need help with postgreSQL

Postby mellemel » Thu Feb 04, 2010 10:59 am

Perfect - thanks again for your patience.
mellemel
 
Posts: 7
Joined: Mon Sep 15, 2008 11:25 pm

Re: I'm uselss and need help with postgreSQL

Postby kraada » Thu Feb 04, 2010 12:03 pm

No problem :)
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests