PostgreSQL conversion instructions

[kablooey]

Is there a step-by-step guide for converting my original PTS database into Postgresql?

Ideally, these instructions would be for someone who already has postgresql working (it works for my PT3) but basically knows nothing about postgresql otherwise.

[ptrack mike]

Since you already have PostgreSQL installed, just try to converting to a PostgreSQL database in PTS using Utilities > Convert Database... window. The only issue you might run in to is when you click the Settings... button the ODBC Entry to Use dropdown may not have any values in it. If that happens, please see the 4th post of this thread for a solution:
viewtopic.php?f=29&t=5669

[kablooey]

Since you already have PostgreSQL installed, just try to converting to a PostgreSQL database in PTS using Utilities > Convert Database... window. The only issue you might run in to is when you click the Settings... button the ODBC Entry to Use dropdown may not have any values in it. If that happens, please see the 4th post of this thread for a solution:
http://www.pokertracker.com/forums/view ... =29&t=5669

Some questions about this:

• If there is a problem with this conversion, what happens to the back up file?
• How can I be sure that I enter the right settings here (port, server, user name, pw, odbc entry, encoding)? I have no idea what most of these mean or do.
• The link you gave me said to download an old version of postgresql. How does downgrading postgresql help?

Hopefully these questions give you an idea of what I meant when I said I knew nothing about postgresql!

I guess there isn't a step-by-step instruction guide à la Converting to PostgreSQL for Dummies?

[ptrack mike]

I guess there isn't a step-by-step instruction guide à la Converting to PostgreSQL for Dummies?

Not really.

If there is a problem with this conversion, what happens to the back up file?

Your original Access database isn't modified and is always still there for you go back to.

How can I be sure that I enter the right settings here (port, server, user name, pw, odbc entry, encoding)? I have no idea what most of these mean or do.

You don't need to know anything abou these. Once they are set and working you won't need to go back to them. Click the Help link on the window you pictured for help with the settings. If you don't know the PostgreSQL password then its probably dbpass

The link you gave me said to download an old version of postgresql. How does downgrading postgresql help?

This is the solution to the problem of the ODBC Entry to Use dropdown being blank.

[kablooey]

How can I be sure that I enter the right settings here (port, server, user name, pw, odbc entry, encoding)? I have no idea what most of these mean or do.

You don't need to know anything abou these. Once they are set and working you won't need to go back to them. Click the Help link on the window you pictured for help with the settings. If you don't know the PostgreSQL password then its probably dbpass

Ok, but what do I set them to now?

Which encoding do I use? When I installed the old version of postgresql, its default was the SQL_ASCII, not UNICODE.

[kablooey]

The older version of PostgreSQL has been installed.

Now there are 2 options for the "ODBC Entry To Use" drop down menu: (1) PostgreSQL ANSI and (2) PostgreSQL UNICODE. Which one should I select?

[ptrack mike]

Click the Help link on the Settings window. It shows you what settings to use.

[kablooey]

Click the Help link on the Settings window. It shows you what settings to use.

I followed those settings and I got this error message.



What should I do from here? How do I check that what I've entered is correct? If it's wrong, how do I find the right information to enter? Keep in mind that there are multiple names and multiple passwords for both versions of postgresql that are now installed on my computer; I also have basically no idea what any of these drop down menus and textboxes mean.

[ptrack mike]

The user name is you need to enter is postgres not postgre. I think that is the problem.

[kablooey]

The user name is you need to enter is postgres not postgre. I think that is the problem.

*dopeslap


After the conversion finishes, will PTS automatically do everything with the new PostgreSQL DB? Also, can I get rid of my 2nd (older) version of PostgreSQL?