Trouble converting PT2 database to PostgreSQL

Forum with tips, support, etc, on using the PostgreSQL database with Poker Tracker. Please post any PostgreSQL questions here.

Trouble converting PT2 database to PostgreSQL

Postby Boodabor » Tue Jul 08, 2008 11:01 am

Ok so I'm trying to switch from PT2 to PT3, and I want to import all the hands from my PT2 database to a PT3 database. But apparantly I need to convert my PT2 database to PostgreSQL in order to do that. So, following other info. I received from this forum, I uninstalled PT3 and PostgreSQL 8.3 and installed PostgreSQL 8.2.6. Now when I click "start conversion" to convert my PT2 database to PostgreSQL, one of two error messages comes up; either

"Error connecting to the hand history database: 0- transaction already connected" or

"Error connecting to the default PostgreSQL database: 01 - SQSTATE = 08001 FATAL: password authentication failed for user "[insert username]" This could be because you have: 1. Entered the wrong user name/password/server name/port. 2. Not started the PostgreSQL database server 3. Not installed the PostgreSQL ODBC driver. Please click the help link at the top right corner of the window for more details."

I know I have the correct user name/password. The server name is "localhost", the port is 5432, and the ODBC Entry to Use is "PostgreSQL Unicode". Could someone please tell me what I need to do to get my PT2 database converted to PostgreSQL? ty
Boodabor
 
Posts: 5
Joined: Mon Jul 07, 2008 4:30 pm

Re: Trouble converting PT2 database to PostgreSQL

Postby ptrack pat » Tue Jul 08, 2008 11:05 am

Restart the computer.
Go to the Start > Programs > PostgreSQL 8.2 > Configuration Files > Edit pg_hba.conf

At the bottom of the file, change both places where it says "MD5" to say "trust" and then save the file and try it again.
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Trouble converting PT2 database to PostgreSQL

Postby Boodabor » Tue Jul 08, 2008 11:53 am

I tried this, but the 2nd error message that I mentioned still pops up. I tried a few more times and the 1st error message isn't showing up anymore. Also, it seems to be taking a couple seconds longer now for the error message to appear.
Boodabor
 
Posts: 5
Joined: Mon Jul 07, 2008 4:30 pm

Re: Trouble converting PT2 database to PostgreSQL

Postby ptrack pat » Tue Jul 08, 2008 12:56 pm

You are still getting the error that the user name/password is wrong?? You shouldn't be if you edited the pg_hba.conf file. Are you running Vista on this computer?
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm

Re: Trouble converting PT2 database to PostgreSQL

Postby Boodabor » Tue Jul 08, 2008 1:20 pm

I guess now the error message says "Fatal: role "[insert username]" does not exist", instead of the other Fatal, but nothing else has changed. I am using the same username and password that i used when installing PostgreSQL 8.2.6. And no, I have windows XP on this computer.
Boodabor
 
Posts: 5
Joined: Mon Jul 07, 2008 4:30 pm

Re: Trouble converting PT2 database to PostgreSQL

Postby ptrack pat » Tue Jul 08, 2008 1:29 pm

On the PostgreSQL Settings window, the user name should be "postgres", what did you enter there??
ptrack pat
 
Posts: 4841
Joined: Sun Dec 09, 2007 12:38 pm


Return to PostgreSQL Forum

Who is online

Users browsing this forum: No registered users and 0 guests