Unable to log in to data base ( macbook air)

[kwokki3]

Hello everyone,

Today I tried to start poker tracker 4 on my macbook. When I started PT4 i got this message

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 clicked on ''configure defaults' and tried to connect but got this message ''Unable to connect to this database. Please check the configuration.''

I also did a SMC this morning is that maybe the problem ?

can somebody please help me I really dont know what to do!



Kind regards,

kwok

[Flag_Hippo]

Have you done something recently to PostgreSQL such as trying to reinstall it or maybe deleting the "postgres" user from your Mac login screen? Do you see PostgreSQL in your Applications folder? If it's there then Confirm where your PostgreSQL is:

/Library/PostgreSQL/x.y

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

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

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

Next reboot, press/hold the "Alt/Option" key while starting PokerTracker 4 and if you get the same error 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). Note in that guide how to properly set and reset the PostgreSQL folder permissions.

[kwokki3]

Thanks for the quick reply!

I’m not sure if I have deleted the PostgreSQL app but I can still find a map with the name PostgreSQL 9.3.
Then i opend the terminal and pasted this : sudo rm /Library/PostgreSQL/9.3/data/postmaster.pid

Then i got this in the Terminal

MacBook-Air-van-Kwok:~ kwok$ sudo rm /Library/PostgreSQL/9.3/data/postmaster.pid
Password:
rm: /Library/PostgreSQL/9.3/data/postmaster.pid: No such file or directory
MacBook-Air-van-Kwok:~ kwok$

What should i do then ?

Is there not more easy way something like reinstall/ remove PT4,PostgreSQL ? doesnt matter if i lose all my poker data.


kind regards,

Kwok

[Flag_Hippo]

If you send us your logs in a Support Ticket we can investigate for you but if you don't mind reinstalling things and starting with a new database you can follow this tutorial and then manually download and install PostgreSQL v9.3 available 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. Provided PostgreSQL installs successfully reboot your computer and then try PokerTracker 4 again. If you want to reimport any of your hands then you can import them using 'Play Poker -> Get Hands From Disk from your Processed folder:

\Users\{Mac Login}\Documents\PokerTracker\Processed

Guide: Processed Files

[kwokki3]

thanks for the instructions I will try it!
I also have another question, currently my PT4 is on my laptop(macbook air). But i want to switch to pc when i reinstall PT on my mac book can i still download it on my new pc ? Because you can only download pt4 2 times right ? I used my first download on my macbook that currently doesnt work.

kind regards,

kwok

[Flag_Hippo]

That is not a problem because the PokerTracker license always grants simultaneous use on two different computers even if they are not the same as the ones you started with.

[kwokki3]

Is it possible to download poker tracker on 3 laptops/pc? because im the only one using my account.

[Flag_Hippo]

You can use PokerTracker 4 on up to two machines that you own and operate at any one time but if you uninstall from one machine you can install on another. If you don't want to keep uninstalling/reinstalling then for something like that you'd need a second PokerTracker 4 license which would allow for up to four usable installations (two machines on the first license and two machines on the second license).

[kwokki3]

I tried to uninstall the postgreSQL but i cant find the first step :1) Execute (double click) /Library/PostgreSQL/8.4/uninstall-postgresql which will uninstall the PostgreSQL installation. I tried to look for this but could not find it on my macbook. Maybe i deleted it ?
I have tried all other steps then i pasted this (ls /Library/PostgreSQL/) in a terminal and it says that the programs are still on my mac. How do i know its postgreSQL is completely deleted from my macbook ?

[Flag_Hippo]

Did you try running the PostgreSQL installer at all? If you need further assistance please open a Support Ticket with a screenshot(s) of your Terminal window after running the following commands:

ps aux | grep -i post

sudo ls -la /Library/PostgreSQL

sudo ls -la /Library/PostgreSQL/*/data

grep postgres /etc/group

grep postgres /etc/password