Postgres error

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

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Postgres error

Postby Winterpeen » Thu Dec 03, 2015 2:07 pm

Same problem as in https://pt4.pokertracker.com/forums/vie ... p?p=246451

Difference:
I do have postgres and some logs.

Last things said in the big file:

2015-12-01 16:54:24 CET CONTEXT: COPY cash_hand_summary, line 1
2015-12-01 16:54:24 CET STATEMENT: COPY cash_hand_summary FROM STDIN;
2015-12-02 11:45:07 CET LOG: received smart shutdown request

the ONLY things said in the small file:

2015-12-02 11:45:07 CET LOG: autovacuum launcher shutting down
2015-12-02 11:45:09 CET LOG: shutting down
2015-12-02 11:45:09 CET LOG: database system is shut down
Winterpeen
 
Posts: 22
Joined: Wed Apr 01, 2015 3:24 pm

Re: Postgres error

Postby kraada » Thu Dec 03, 2015 5:36 pm

What output do you get when you run this command in Terminal:
ps ax | grep -i postgres

?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Postgres error

Postby Winterpeen » Fri Dec 04, 2015 6:52 am

It looks exactly like this:

2360 s000 S+ 0:00.00 grep -i postgres
Winterpeen
 
Posts: 22
Joined: Wed Apr 01, 2015 3:24 pm

Re: Postgres error

Postby kraada » Fri Dec 04, 2015 8:17 am

Ok, so PostgreSQL is not running. Open Console - do you see errors for PostgreSQL listed?
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Postgres error

Postby Winterpeen » Fri Dec 04, 2015 8:57 am

04-12-15 13:56:07,811 com.apple.xpc.launchd[1]: (com.edb.launchd.postgresql-9.3) Service only ran for 0 seconds. Pushing respawn out by 10 seconds.
04-12-15 13:56:17,958 com.apple.xpc.launchd[1]: (com.edb.launchd.postgresql-9.3[3189]) Service exited with abnormal code: 1


Seems something abnormal is going on over here!
Winterpeen
 
Posts: 22
Joined: Wed Apr 01, 2015 3:24 pm

Re: Postgres error

Postby kraada » Fri Dec 04, 2015 2:52 pm

The easiest thing to do to try to fix it is just to uninstall and reinstall PostgreSQL as explained in this guide - just don't delete your data folder and your data will not be harmed.
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 18 guests

cron
highfalutin