Page 1 of 1

Configure PostgreSQL Server - starting PT3 problems

PostPosted: Fri May 09, 2008 6:49 am
by AzurePoet
Hello lads,

This is probably a real newbie question, but I went through the forum archive and couldn't find an answer to my question, which is..


I unzipped and installed pt3, now upon first opening it, I have to configure for the postgreSQL server. I have been using pt2 for a long time and I have POSTgreSQL 8.2 setup and SQLite ODBC driver setup (if that even matters)

I can't get past this screen, i dont know what the server or port or database user/pw is. I tried the default postgres/dbpass but that didn't work.

Then I tried clickin the 'need postgreSQL installed? click here!' but that brought up an error "Please use the main MSI file to install PostgreSQL" then a 'fatal error' "Installation ended prematurely because of an error"

any help greatly appreciated, thanks in advance

-Sunny

Re: Configure PostgreSQL Server - starting PT3 problems

PostPosted: Fri May 09, 2008 6:34 pm
by prajna
Try removing password requirements of your server for local queries and see if that helps. Goto start -> postgresql -> configuration files -> pg_hba.conf. Scroll to the bottom of the document and in both places you see the word md5, replace it with trust. Save and exit. This will allow you to access the database w/any password locally and it not fail.

~ Thomas
[Pokertracker support]

Re: Configure PostgreSQL Server - starting PT3 problems

PostPosted: Thu May 15, 2008 9:02 pm
by Tixu
Same problen, fix didn't work. I just installed PostgreSQL and remember my password

Re: Configure PostgreSQL Server - starting PT3 problems

PostPosted: Thu May 15, 2008 9:08 pm
by Tixu
Ok I went to change my postresql password from administrator -> services , and now it works.
Had to stop the service first to change the password.

Re: Configure PostgreSQL Server - starting PT3 problems

PostPosted: Sat May 17, 2008 4:02 am
by 88dogwolf22
Tixu wrote:Ok I went to change my postresql password from administrator -> services , and now it works.
Had to stop the service first to change the password.


Where I can find this administrator and how one stop the service and where is this service located and how I stop it?

Re: Configure PostgreSQL Server - starting PT3 problems

PostPosted: Sun May 18, 2008 9:40 am
by Tixu
I have my windows in different language, but I try to help. Control panel -> Administrator -> Services , Find PostgreSQL from the list. Click it. The first page in the bottom you can stop and start it. Stop it first. Then
go to the second page which is login or something. Change the password there, There is also in the bottom some stop button, if it doesn't take you new password try to stop that page too. After you have managed to change the password go back to the first page and start the service which you stopped. (and if you stopped something on the second page start that too)