New Database

[etant39]

How do I set up a new database for PTv2? My database seems to be too big and it takes too long to import hands. I would like to start a new database from Jan 1 of this year. How would I do this.

Thanks

[ptrack pat]

Open the File > Maintain Databases Names window and click the help link at the top right corner of the window where it describes how to start a new database.

[etant39]

This page showing the steps to install PostgreSQL is no longer available. Could you show me where this page is located now? Thanks



To install PostgreSQL on your computer, please follow the steps detailed here...

[ptrack pat]

http://www.pokertracker3.com/products/P ... InstallSQL

[etant39]

During the installation of PostgreSQL, when I get to the part where it is asking me to create a password I keep getting this error message:

Invalid username specified: Login Failure: unknown user name or bad password

I have tried multiple passwords, but it wont take any. Please help

Thanks

[ptrack pat]

There are 2 windows where you have to enter passwords, does this happen the first time you are prompted or the second?

If it's the first time, what value is in the "username" field? Is it "postgres"? If so, change it to "postgres2" and then enter the password.

[etant39]

I did what you said and it worked but now I am getting the following error messages on the next screen when I create the second password:

The port number entered is already in use. Please specify a different port.

I tried changing the superuser name to postgres2 but it did the same thing.


Thanks for all the help.

[ptrack pat]

You must have another version of PostgreSQL installed on this computer as I don't know what other programs would be using the default port of 5432.

Go to the Start > Settings > Control Panel > Administrative Tools > Services window.

Look for anything in this list starting with "PostgreSQL Database...." Do you find any? If so, what is the full name and does it say that it's "Started"?

[etant39]

Yes, I do. The full name is PostgreSQL Database Server 8.3 and it is started.

[ptrack pat]

OK, maybe you installed PT3 and it loaded PostgreSQL for you.

Go to the Utilities > PostgreSQL Settings window in PT.

In the dropdown list on the "ODBC Entry to Use" field, are there entries there? If not, do this step...
archives/PT2/viewtopic.php?t=24880

Then after you do that, go back to the PostgreSQL Settings window, enter the information...

port = 5432
server = localhost
name = postgres
password = [password you used][bobu] ***[/bobu]
ODBC Entry = PostgreSQL Unicode
Encoding = UNICODE

[bobu]***[/bobu] - if you don't remember the password, go to the Start menu and select Programs > PostgreSQL 8.3 > Configuration Files > Edit pg_hba.conf

Go to the bottom of the file. Change both places where it says "MD5" to say "trust" and then save the changes. Then it won't matter what you use for a password.

Once that's all setup, then do steps 2-5 in the "After PostgreSQL is installed" section of the FAQ...
http://www.pokertracker3.com/products/P ... InstallSQL