Page 1 of 1

MAC PT3 postgressSQL issues

PostPosted: Sat Nov 05, 2011 6:53 am
by Tschangoo
I am trying to reinstall PT3 on my MAC(OSX 10.6.8). When i try to configure my postgress (screenshot configureWINDOW) sql database and click the create button i get the error message

"Unable to create PostgreSQL database: PT3 DB
Reason: Unable to login to database (template1). Reason: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? "
(look screenshot ErrorWindow)

My OS installation is new and I also tried to reinstall Pokertracker ( all downloadable versions) but it always ends with the same error message.

What can I do to fix this ??

best regards

Tschangoo

Re: MAC PT3 postgressSQL issues

PostPosted: Sat Nov 05, 2011 7:17 am
by WhiteRider
Is PostgreSQL installed? (Do you see it in Applications?)
If so, can you start it manually via Applications > PostgreSQL > Start Server? Which version do you have? (PostgreSQL x.y)

Re: MAC PT3 postgressSQL issues

PostPosted: Sat Nov 05, 2011 8:07 am
by Tschangoo
Thx for your answer. Installed postgress SQL manual and now it works :-)

Re: MAC PT3 postgressSQL issues

PostPosted: Sat Nov 05, 2011 1:30 pm
by WhiteRider
Great - thanks for letting us know.

Re: MAC PT3 postgressSQL issues

PostPosted: Sun Nov 13, 2011 7:31 pm
by beedub
I have a similar problem but I cannot even get postgres installed with the same errors.

Re: MAC PT3 postgressSQL issues

PostPosted: Mon Nov 14, 2011 3:53 am
by WhiteRider
Have you previously had PostgreSQL installed on this computer? Was it working before?
Are you trying to install manually? Which version?
Which version of Mac OS do you have?

Re: MAC PT3 postgressSQL issues

PostPosted: Tue Nov 15, 2011 7:21 am
by xaxalev
I have a similar problem
but when I try to start manually :

Last login: Tue Nov 15 13:14:19 on ttys000
Dmytrys-MacBook-Pro:~ xaxalev$ /Library/PostgreSQL/9.0//scripts/runpsql.sh; exitServer [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
Password for user postgres:
psql: FATAL: password authentication failed for user "postgres"

Press <return> to continue...

Some problem with password ?

MAc OS Lion 10.7.2

Before PT3 works on Snow leopard perfectly

Re: MAC PT3 postgressSQL issues

PostPosted: Tue Nov 15, 2011 9:19 am
by kraada
The easiest way to fix this problem is to follow the following steps:

(1) Open Terminal (Applications --> Utilities --> Terminal)
(2) Type: "sudo nano /Library/PostgreSQL/8.4/data/pg_hba.conf" (without the quotes) - it will prompt for your password, type it in and hit enter (no *s will be displayed - this is a security precaution). When the password is entered successfully the terminal will change and show you an in-terminal text editor editing the file we want.
(3) Scroll down to the bottom and change all instances of "md5" to "trust" (again, no quotes).
(4) Save the file by pressing ctrl-o (that's the letter o).
(5) Exit by prssing ctrl-x.
(6) Restart PostgreSQL (via Applications -> PostgreSQL 8.4 -> Restart Server).

highfalutin