help with postgresql and PTO

[LaidBackAl]

So I am running the latest PT3 with postgresgl provided my PT. I was running postgresgl 8.2, and now I am running 8.3. PT3 works fine but I need to be able to run PTO with the new version of postgres. I can't get it to connect up and I know it is still looking for 8.2. I thought it would be as simple as going into postgresql settings and refilling out the information but when I do there is no "ODBC Entry to Use" option in the drop down box. I am lost now. Also when I first start PTO up or try to do certain things, I get this error message: 999-SQLSTATE_IM002

Help please.

[ptrack mike]

What version of PTO are you using? Have you converted your PTO database to PostgreSQL?

[LaidBackAl]

Version 1.13.00

I have been running postgresql the whole time. I am not trying to restablish my DB. Looking to start fresh, so just be able to create a new DB and connect to the PostGreSQL server which is version 8.3

[ptrack mike]

You'll have to convert your Access DB to PostgreSQL first, even if it's empty. Then you should be able to change the settings.

If not see this:
archives/PT2/viewtopic.php?t=24880

[LaidBackAl]

You'll have to convert your Access DB to PostgreSQL first, even if it's empty. Then you should be able to change the settings.

If not see this:
archives/PT2/viewtopic.php?t=24880

It's never been an access database. I have always been running PostgreSQL?!?!

[LaidBackAl]

Not sure if I am being clear enough. I don't have an "ODBC Entry To Use" in the drop down box. So for some reason PT3 see's the server fine, and can access it database. I have a PT2 Omaha database restored on the new version of PostgreSQL that I restored through PostgreSQL Admin. I am not even concerned if connecting to this specific database is not the way to go. I don't mind connecting up PTO to server, creating brand new DB, and then restoring my old DB that has my PTO data in it. The point it PTO is not able to connect to PostgreSQL server or do anything. I go into "PostgreSQL Settings" (and remember everything is on default) have Port: 5432, Server: localhost, User Name:postgres, Password: ********* (I am certain of pwd), ODBC Entry To Use: "There is nothing here...no drop down menu, just blank; Encoding:SQL_ASCII or UNICODE; and this is as far as I can get! If I try to hit "Okay" I get "Please enter a valid value in the 'ODBC Entry To Use" field. The only way to get out of it is to "Remove" the entry. I can not create a new database because I get "You have not yet configured your PostgreSQL database settings. Please use the Utilities/PostgreSQL Settings window to do this first."

So the problem lies in trying to connect to the PostgreSQL server. And to take it further, it is in the fact that I don't have ODBC Entry To Use to use. Does this help??

[ptrack mike]

That helps. I haven't seen this issue before, but it looks like a PT2 Hold'em user had the same issue with PT3/PostgreSQL 8.3:
viewtopic.php?f=29&t=3316&st=0&sk=t&sd=a&hilit=ODBC+Entry+to+Use

Try the things that Pat mentions in that thread and let me know if it works.

[LaidBackAl]

Ok...first off...you are pointing people to the wrong thread. The thread you referrence can confuse people and is incomplete. You should be pointing people to this thread: http://www.pokertracker.com/forums/archives/PT2/viewtopic.php?t=24880

Second, this won't work for people that are already running PT3 and installed on their computer. The reason is because in order to "add" Stack Builder to your system it needs the original "postgresql-8.3.msi" file to do this. This file is compressed inside PT3's installation package so if you installed PostgreSQL through the PT installation, all these steps are completely useless to you. Pat was also completely wrong in, "using the Start menu > Programs > PostgreSQL 8.3 > Application Stack Builder" it doesn't exist. At least not in Beta 9 or 8. So he is giving people instructions that are a dead end. The "ONLY" way this will work is if you installed PostgreSQL yourself and then you go through control panel/add remove programs. Then you have the option to do this but again, you have to have the original *.msi file that you installed with handy. The work around for all of this is for you guys to fix it so that Stack Builder is an option installed during installation inside your PT3 w/PostgreSQL package. And if you think you can just go add/remove programs and point to another postgresql-8.3.msi file to do this you are wrong. Can't be done. I would make sure Pat sees this!

If you are already up and running, and originally installed postgresql with the PT3 install pack and need to fix this, you're screwed. You have to start all over from scratch. The only fix I could come up with was backing up my DB's, wiping everything out, and starting from scratch. Here is what I did:

* Start/programs/PostgreSQL 8.3/pgAdmin III
* Select servers/Databases/"Database name" Database name for the databases you want to backup. In my case I had 3 different DB's that needed to be backed up so I had to do them one at a time
* Right click on the DB/select backup - in the backup database window that pops up create a file name you want to back it up to and the location where you want to put the backup. I used all defaults in here and selected "OK". I did this 3 times for each database.
* Closed pgAdmin and went through add/remove programs to uninstall PostgreSQL completely.
* I then went out and downloaded PostgreSQL 8.3.1 from the link Pat provided http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.3.1%2Fwin32%2Fpostgresql-8.3.1-1.zip
* In my case (I found out at a later step) I had a problem with PT3 beta 9 that was left on my pc connecting to the SQL server and it would open for a second with the splash screen for PT3 then crash. Kept doing it so I unistalled the version of PT3 beta 9 that originally came with PostgreSQL from my machine. So I would uninstall it here. Rebooted the machine for a fresh start after the two unistalls.
* Installed PostgreSQL 8.3.1.msi from the early download. Did all the defaults and made sure Stack Builder was being installed "during" installation. I also had a post in another thread about PostgreSQL 8.3.1 not being able to install on a different drive other than C: with the PT3 install, so I fixed this here. I put on the drive that I specifically built for this. I left everything as defaults during install.
* At the end of the install, Stack Builder popped up and I followed Pat's instructions:
On the window that opens, click the PostgreSQL Database Server 8.3 from the list and click the NEXT button.

On the next window, check the box next to "psqlODBC v08.03...." and click NEXT.

On the next window, select USA from the list of countries and select a mirror (I don't think it matters which) and click NEXT.

From this point, just keep clicking NEXT or FINISH leaving everything else set to the default values until the ODBC Drivers are installed.

* I then downloaded PT3 http://www.pokertracker.com/products/PT3/download.php "WITHOUT PostgreSQL" and installed it to the drive of my choice.
* I setup PT3 to point at the PostgreSQL server and created a new database.
* Start/programs/PostgreSQL 8.3/pgAdmin III again and just like the early steps to restore, the only difference is I right clicked on the DB that I created inside PT3 and selected "Restore". I pointed to the DB I backed up in earlier steps in the popup window, left all the defaults and selected OK. I think my data is back but I did get error messages during the restore that I will send to you guys because I don't know what they mean or if damage was done, but it "looks" like my data is there.

* The last part was a little tricky for me because there was an 'open' DB name left inside PTO that it kept looking for when you open PTO. So I went to "PostgreSQL" settings and added the new server information. Port:5432, User Name:postgres, Password:******, ODBC Entry to Use: PostgreSQL Unicode (AND YES THERE WAS A DROP DOWN BOX NOW), Encoding: Unicode. I went to say "OK" and I got an error message. This was due to it still looking for the "old" database.

* I then went to "File/Maintain Database Names" and created a new database and set as default. Exited and then had to "open" the database (since you always have to have one db open) and close the database that didn't exist anymore. Back into "Maintain Database Names" and now I could delete the database that didn't exist anymore that PTO was still looking for. Now PTO was fully functional again for me.

* The last step in my case is that I went back into page admin, followed the steps above to restore a database, and imported my Omaha information back into the DB I created in the PTO section.

From working with you guys all week, this just seemed to be the only way to fix everything. I am going to send the error logs during my restores and maybe you guys could take a look at them for me. Please make sure your team and Pat knows that the instructions he is given won't work unless Stack Builder was "originally" installed at time of PostgreSQL install. If not, and they installed through the PT3 package, it can't be done any other way then this way. Obviously not all these steps are for everyone, but if you already have preexisting DB's running, I don't know another way. This is probably a lot more information than you wanted...but just incase someone is ripping their hair out like I have, this should help them. I think you should give me a job at the end of all this ;)

Thanks!

[FMMH]

Ok...first off...you are pointing people to the wrong thread. The thread you referrence can confuse people and is incomplete. You should be pointing people to this thread: http://www.pokertracker.com/forums/archives/PT2/viewtopic.php?t=24880

Second, this won't work for people that are already running PT3 and installed on their computer. The reason is because in order to "add" Stack Builder to your system it needs the original "postgresql-8.3.msi" file to do this. This file is compressed inside PT3's installation package so if you installed PostgreSQL through the PT installation, all these steps are completely useless to you. Pat was also completely wrong in, "using the Start menu > Programs > PostgreSQL 8.3 > Application Stack Builder" it doesn't exist. At least not in Beta 9 or 8. So he is giving people instructions that are a dead end. The "ONLY" way this will work is if you installed PostgreSQL yourself and then you go through control panel/add remove programs. Then you have the option to do this but again, you have to have the original *.msi file that you installed with handy. The work around for all of this is for you guys to fix it so that Stack Builder is an option installed during installation inside your PT3 w/PostgreSQL package. And if you think you can just go add/remove programs and point to another postgresql-8.3.msi file to do this you are wrong. Can't be done. I would make sure Pat sees this!

If you are already up and running, and originally installed postgresql with the PT3 install pack and need to fix this, you're screwed. You have to start all over from scratch. The only fix I could come up with was backing up my DB's, wiping everything out, and starting from scratch. Here is what I did:

* Start/programs/PostgreSQL 8.3/pgAdmin III
* Select servers/Databases/"Database name" Database name for the databases you want to backup. In my case I had 3 different DB's that needed to be backed up so I had to do them one at a time
* Right click on the DB/select backup - in the backup database window that pops up create a file name you want to back it up to and the location where you want to put the backup. I used all defaults in here and selected "OK". I did this 3 times for each database.
* Closed pgAdmin and went through add/remove programs to uninstall PostgreSQL completely.
* I then went out and downloaded PostgreSQL 8.3.1 from the link Pat provided http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fbinary%2Fv8.3.1%2Fwin32%2Fpostgresql-8.3.1-1.zip
* In my case (I found out at a later step) I had a problem with PT3 beta 9 that was left on my pc connecting to the SQL server and it would open for a second with the splash screen for PT3 then crash. Kept doing it so I unistalled the version of PT3 beta 9 that originally came with PostgreSQL from my machine. So I would uninstall it here. Rebooted the machine for a fresh start after the two unistalls.
* Installed PostgreSQL 8.3.1.msi from the early download. Did all the defaults and made sure Stack Builder was being installed "during" installation. I also had a post in another thread about PostgreSQL 8.3.1 not being able to install on a different drive other than C: with the PT3 install, so I fixed this here. I put on the drive that I specifically built for this. I left everything as defaults during install.
* At the end of the install, Stack Builder popped up and I followed Pat's instructions:
On the window that opens, click the PostgreSQL Database Server 8.3 from the list and click the NEXT button.

On the next window, check the box next to "psqlODBC v08.03...." and click NEXT.

On the next window, select USA from the list of countries and select a mirror (I don't think it matters which) and click NEXT.

From this point, just keep clicking NEXT or FINISH leaving everything else set to the default values until the ODBC Drivers are installed.

* I then downloaded PT3 http://www.pokertracker.com/products/PT3/download.php "WITHOUT PostgreSQL" and installed it to the drive of my choice.
* I setup PT3 to point at the PostgreSQL server and created a new database.
* Start/programs/PostgreSQL 8.3/pgAdmin III again and just like the early steps to restore, the only difference is I right clicked on the DB that I created inside PT3 and selected "Restore". I pointed to the DB I backed up in earlier steps in the popup window, left all the defaults and selected OK. I think my data is back but I did get error messages during the restore that I will send to you guys because I don't know what they mean or if damage was done, but it "looks" like my data is there.

* The last part was a little tricky for me because there was an 'open' DB name left inside PTO that it kept looking for when you open PTO. So I went to "PostgreSQL" settings and added the new server information. Port:5432, User Name:postgres, Password:******, ODBC Entry to Use: PostgreSQL Unicode (AND YES THERE WAS A DROP DOWN BOX NOW), Encoding: Unicode. I went to say "OK" and I got an error message. This was due to it still looking for the "old" database.

* I then went to "File/Maintain Database Names" and created a new database and set as default. Exited and then had to "open" the database (since you always have to have one db open) and close the database that didn't exist anymore. Back into "Maintain Database Names" and now I could delete the database that didn't exist anymore that PTO was still looking for. Now PTO was fully functional again for me.

* The last step in my case is that I went back into page admin, followed the steps above to restore a database, and imported my Omaha information back into the DB I created in the PTO section.

From working with you guys all week, this just seemed to be the only way to fix everything. I am going to send the error logs during my restores and maybe you guys could take a look at them for me. Please make sure your team and Pat knows that the instructions he is given won't work unless Stack Builder was "originally" installed at time of PostgreSQL install. If not, and they installed through the PT3 package, it can't be done any other way then this way. Obviously not all these steps are for everyone, but if you already have preexisting DB's running, I don't know another way. This is probably a lot more information than you wanted...but just incase someone is ripping their hair out like I have, this should help them. I think you should give me a job at the end of all this ;)

Thanks!

For an idiot like me, is there any easier way to do this? *holds breath and prays*

[ptrack mike]

What email was used to purchase PT? I have no record of this one used for the forum.