Cannot connect to database all of a sudden

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Cannot connect to database all of a sudden

Postby Winterpeen » Tue Jun 09, 2015 3:37 pm

Trying to start poker tracker (trial).
I get some kind of strange notification I can't reach my database
I didn't change anything at all lately and could run the tracker yesterday!

I'm running on a Mac 10.10.3

Edit: My database is on an external HD
Attachments
Schermafbeelding 2015-06-09 om 21.36.24.png
Winterpeen
 
Posts: 22
Joined: Wed Apr 01, 2015 3:24 pm

Re: Cannot connect to database all of a sudden

Postby kraada » Tue Jun 09, 2015 4:24 pm

Try restarting your computer first and that might fix it. If not, can you confirm PostgreSQL is still in Applications?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cannot connect to database all of a sudden

Postby Winterpeen » Tue Jun 09, 2015 4:38 pm

I restarted my Mac, didn't actually expect it to work as I NEVER turn it off. Always on sleeping mode.

I can confirm PostgreSQL9.4 is in my applications, haven't changed a single thing from tomorrow till now.
Winterpeen
 
Posts: 22
Joined: Wed Apr 01, 2015 3:24 pm

Re: Cannot connect to database all of a sudden

Postby kraada » Tue Jun 09, 2015 4:46 pm

Go into Applications -> Utilities -> Terminal and type the following, hit enter, and paste the results here:
ps -ax | grep -i postgres
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cannot connect to database all of a sudden

Postby Winterpeen » Tue Jun 09, 2015 5:05 pm

It says something which does not make any sense hahahah
Attachments
Schermafbeelding 2015-06-09 om 23.04.49.png
Schermafbeelding 2015-06-09 om 23.04.49.png (5.14 KiB) Viewed 892 times
Winterpeen
 
Posts: 22
Joined: Wed Apr 01, 2015 3:24 pm

Re: Cannot connect to database all of a sudden

Postby kraada » Wed Jun 10, 2015 7:15 am

It would say a lot more if PostgreSQL were running. Open Console - do you see any errors there relating to PostgreSQL? If so, what do they say?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cannot connect to database all of a sudden

Postby Winterpeen » Wed Jun 10, 2015 8:08 am

This certainly looks like some kind of problem/error
Attachments
Schermafbeelding 2015-06-10 om 14.07.44.png
Winterpeen
 
Posts: 22
Joined: Wed Apr 01, 2015 3:24 pm

Re: Cannot connect to database all of a sudden

Postby kraada » Wed Jun 10, 2015 12:13 pm

Attach the most recent few files in /Library/PostgreSQL/9.0/data/pg_log to a support ticket and we should be able to figure out what's the next step for you.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Cannot connect to database all of a sudden

Postby Winterpeen » Wed Jun 10, 2015 12:58 pm

It seems like I can't open this file. It's locked for some reason as I do not have authority..

EDIT:
Fixed it, hope I will get a response soon as m time is ticking..

EDIT2:
I don't think the ticket has been sent , I don't see any confirmation when I submit it, just a plain white screen...
Winterpeen
 
Posts: 22
Joined: Wed Apr 01, 2015 3:24 pm

Re: Cannot connect to database all of a sudden

Postby kraada » Wed Jun 10, 2015 2:25 pm

Try zipping the files up first - there's a 5M limit on uploads.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PT4 for macOS

Who is online

Users browsing this forum: No registered users and 19 guests

cron