MAC PT3 postgressSQL issues

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

MAC PT3 postgressSQL issues

Postby Tschangoo » Sat Nov 05, 2011 6:53 am

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
Tschangoo
 
Posts: 2
Joined: Mon Nov 29, 2010 4:44 am

Re: MAC PT3 postgressSQL issues

Postby WhiteRider » Sat Nov 05, 2011 7:17 am

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)
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: MAC PT3 postgressSQL issues

Postby Tschangoo » Sat Nov 05, 2011 8:07 am

Thx for your answer. Installed postgress SQL manual and now it works :-)
Tschangoo
 
Posts: 2
Joined: Mon Nov 29, 2010 4:44 am

Re: MAC PT3 postgressSQL issues

Postby WhiteRider » Sat Nov 05, 2011 1:30 pm

Great - thanks for letting us know.
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: MAC PT3 postgressSQL issues

Postby beedub » Sun Nov 13, 2011 7:31 pm

I have a similar problem but I cannot even get postgres installed with the same errors.
beedub
 
Posts: 1
Joined: Sun Nov 13, 2011 7:12 pm

Re: MAC PT3 postgressSQL issues

Postby WhiteRider » Mon Nov 14, 2011 3:53 am

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?
WhiteRider
Moderator
 
Posts: 54017
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: MAC PT3 postgressSQL issues

Postby xaxalev » Tue Nov 15, 2011 7:21 am

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
xaxalev
 
Posts: 1
Joined: Tue Nov 09, 2010 2:36 pm

Re: MAC PT3 postgressSQL issues

Postby kraada » Tue Nov 15, 2011 9:19 am

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).
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 26 guests

cron
highfalutin