Page 1 of 1

Postgres error

PostPosted: Thu Dec 03, 2015 2:07 pm
by Winterpeen
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

Re: Postgres error

PostPosted: Thu Dec 03, 2015 5:36 pm
by kraada
What output do you get when you run this command in Terminal:
ps ax | grep -i postgres

?

Re: Postgres error

PostPosted: Fri Dec 04, 2015 6:52 am
by Winterpeen
It looks exactly like this:

2360 s000 S+ 0:00.00 grep -i postgres

Re: Postgres error

PostPosted: Fri Dec 04, 2015 8:17 am
by kraada
Ok, so PostgreSQL is not running. Open Console - do you see errors for PostgreSQL listed?

Re: Postgres error

PostPosted: Fri Dec 04, 2015 8:57 am
by Winterpeen
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!

Re: Postgres error

PostPosted: Fri Dec 04, 2015 2:52 pm
by kraada
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.