SQL problems

A special forum dedicated to our PT4 for Mac OS X users

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

SQL problems

Postby Kms8 » Mon Jun 28, 2021 1:44 am

I got a new MacBook, and after I unistalled pokerstars and pokertracker on the old MacBook, I started having problems with applications on the new one. I can go to pokerstars again (me have helped in the support service), and when I try to go to pokertracker, I get the error "Unable to connect to this database. Please check the configuration".
Kms8
 
Posts: 3
Joined: Mon Sep 22, 2014 12:47 pm

Re: SQL problems

Postby Flag_Hippo » Mon Jun 28, 2021 5:43 am

When you installed PokerTracker 4 on the new Mac did it ask if it could install PostgreSQL for you? If so did the message at the end indicate if the install completed successfully or not? Do you see PostgreSQL in your Applications folder? If it's not there or downloading and installing automatically via PokerTracker 4 you can download PostgreSQL v10 from here. Using a Mac administrator account or administrative privileges install that PostgreSQL and for the password boxes use "dbpass" (no quotes) which is what PokerTracker 4 uses by default. Once PostgreSQL installs successfully restart your computer and then try PokerTracker 4 again.
Flag_Hippo
Moderator
 
Posts: 17048
Joined: Tue Jan 31, 2012 7:50 am

Re: SQL problems

Postby Kms8 » Mon Jun 28, 2021 8:24 am

Everything is working. Thank you very much!
Kms8
 
Posts: 3
Joined: Mon Sep 22, 2014 12:47 pm

Re: SQL problems

Postby Flag_Hippo » Mon Jun 28, 2021 11:34 am

Pleased to hear you've resolved the issue :)
Flag_Hippo
Moderator
 
Posts: 17048
Joined: Tue Jan 31, 2012 7:50 am

Re: SQL problems

Postby Kms8 » Thu Nov 04, 2021 6:04 pm

Kms8 wrote:I got a new MacBook, and after I unistalled pokerstars and pokertracker on the old MacBook, I started having problems with applications on the new one. I can go to pokerstars again (me have helped in the support service), and when I try to go to pokertracker, I get the error "Unable to connect to this database. Please check the configuration".


After installing the system Monterey returns the same error "Unable to connect to this database. Please check the configuration". Old methods don't help. Can you please tell me what can be done?
Kms8
 
Posts: 3
Joined: Mon Sep 22, 2014 12:47 pm

Re: SQL problems

Postby fabadam » Fri Nov 05, 2021 4:08 am

Kms8 wrote:
Kms8 wrote:I got a new MacBook, and after I unistalled pokerstars and pokertracker on the old MacBook, I started having problems with applications on the new one. I can go to pokerstars again (me have helped in the support service), and when I try to go to pokertracker, I get the error "Unable to connect to this database. Please check the configuration".


After installing the system Monterey returns the same error "Unable to connect to this database. Please check the configuration". Old methods don't help. Can you please tell me what can be done?


I had the same problem (see other post). All the downloaded PostgreSQL install images kept giving me problems.
I have now solved it by installing PostgreSQL from another source: from Homebrew (https://brew.sh). This is a software repository for Linux-type software on the Mac.
Note that that means you start with NO database in Pokertracker!

It also has PostgreSQL. So I did this:
- install Homebrew - go to the above site and follow instructions
- brew install [email protected]
- brew service start postgres
- Download and Install Pgdadmin 4
- Open it and connect to your DB server (address localhost, port 5432)
- Create a role postgres with password you like. Give that role all privileges.
- Now start PokerTracker 4 and create a new database

The above has worked for me, but is not ideal since you lose your old database.
Somehow there is something wrong with PostgreSQL's service in Monterey. I do not know how to solve that.
fabadam
 
Posts: 3
Joined: Sat Jan 16, 2016 12:21 pm

Re: SQL problems

Postby Flag_Hippo » Fri Nov 05, 2021 5:33 am

Kms8 wrote:After installing the system Monterey returns the same error "Unable to connect to this database. Please check the configuration". Old methods don't help. Can you please tell me what can be done?

Please open a Support Ticket where one of our technicians can assist you further.
Flag_Hippo
Moderator
 
Posts: 17048
Joined: Tue Jan 31, 2012 7:50 am

Re: SQL problems

Postby jonb2020 » Tue Feb 18, 2025 11:30 am

hi I'm getting this error and i have trawled through the forum and tried everything and still cannot get it to work, please help!!!

Unable to login to database (postgres). Reason: connection to server at "localhost" (::1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused (0x0000274D/10061) Is the server running on that host and accepting TCP/IP connections?
jonb2020
 
Posts: 1
Joined: Mon Dec 30, 2024 7:02 am

Re: SQL problems

Postby Flag_Hippo » Tue Feb 18, 2025 1:53 pm

Is this a new or existing install of PokerTracker 4? Do you see PostgreSQL in your Applications folder?
Flag_Hippo
Moderator
 
Posts: 17048
Joined: Tue Jan 31, 2012 7:50 am

Re: SQL problems

Postby nick popageorgeo » Wed May 21, 2025 12:02 pm

i also am trying to get pt4 to work on a new mac
seeing: unable to log into database (postgres). reason: connection to server on socket "/tmp/.s.PGSQL.5432" failed. no such file or directory is the server running locally and accepting connections on that socket? please help!
nick popageorgeo
 
Posts: 3
Joined: Mon Apr 06, 2020 3:32 pm

Next

Return to PT4 for macOS

Who is online

Users browsing this forum: No registered users and 4 guests