Configure PostgreSQL Server - starting PT3 problems

[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

[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]

[Tixu]

Same problen, fix didn't work. I just installed PostgreSQL and remember my password

[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.

[88dogwolf22]

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?

[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)