Unable to login to the database

[Sgol68]

Hi,

I'm opening this ticket because today I was trying to open PT4 but there was un error message which said "Unable to login to database (postgres). 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"?"
Then I tried to click on configure default and when the Database windows opened, the two different database were gray and I was not able to choose one ..

You can find attached the screenshot of the different windows ... Do you know what is the problem ?

Thank you for your help,
Stéphane.

[Flag_Hippo]

A support technician will be replying to you in your existing ticket.

[dirtysquirrel]

i am getting this exact same error

[Flag_Hippo]

1.  Confirm where your PostgreSQL is, probably here: 

/Library/PostgreSQL/x.y

"x.y" will be two numbers such as "8.4", "9.0", etc.

2.  Open a terminal, probably in "Utilities".  In the terminal window copy/paste this:

sudo rm /Library/PostgreSQL/x.y/data/postmaster.pid

Substitute the "x.y" in that command with the numbers you noted in #1.

You want to delete "postmaster.pid" so answer "y" if the command finds it.

3.  Next reboot, press/hold the "Alt/Option" key while starting PokerTracker 4 and click through any messages.  Only start PokerTracker 4 once even if nothing appears.  

If PokerTracker 4 still doesn't start attach these files to a Support Ticket:

--> /Users/{Mac Login}/Library/Application Support/PokerTracker 4/Logs/PokerTracker4.log

--> Your newest 3 or 4 PostgreSQL log files (look for "Mac" in the guide):

Guide: PostgreSQL log files

[Joel Griffith]

I accidentally deleted the PostgreSQL user on my Mac.....is this fixable?

[Flag_Hippo]

The only fix for that is to remove what's left of PostgreSQL and reinstall it by following this tutorial and then manually downloading and install PostgreSQL 9.6 available from here.