Pokertracker 3 & PostgreSQL on MAC

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

Pokertracker 3 & PostgreSQL on MAC

Postby brutti » Thu Aug 09, 2012 2:50 am

Hello,

I've only been using PT3 on Windows, but recently got a Macbook Pro. However I do have a problem with PostgreSQL I think.

I installed PT3 along with PostgreSQL version 9.08. It worked fine without any reboots so I didn't do that. A few hours after playing and just setup the hud again I came over this problem after I did a reboot.

http://img232.imageshack.us/img232/9121 ... 09kl08.png

IfI just reinstall PostgreSQL and use the same Data folder Pokertracker 3 work fine and the settings also remains the same, in the long run though I don't want to be reinstalling PostgreSQL for every time I reboot my Mac.

It seems like PostgreSQL isn't running from the startup?!

I'm also looking forward to PT4 for Mac.


Thanks
brutti
 
Posts: 9
Joined: Fri Jun 12, 2009 5:20 pm

Re: Pokertracker 3 & PostgreSQL on MAC

Postby kraada » Thu Aug 09, 2012 8:09 am

Open Applications -> Utilities -> Terminal and at the terminal paste in this:

sudo su postgres -c '/Library/PostgreSQL/9.0/bin/pg_ctl -D /Library/PostgreSQL/9.0/data/ restart'

and hit enter. Enter your Mac password (it won't show *s but it is working) and hit enter.

Then try again.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Pokertracker 3 & PostgreSQL on MAC

Postby brutti » Thu Aug 09, 2012 12:29 pm

kraada wrote:Open Applications -> Utilities -> Terminal and at the terminal paste in this:

sudo su postgres -c '/Library/PostgreSQL/9.0/bin/pg_ctl -D /Library/PostgreSQL/9.0/data/ restart'

and hit enter. Enter your Mac password (it won't show *s but it is working) and hit enter.

Then try again.


Thanks, it's working fine.

If I do a reboot I have to copy paste the string again. Any way to make this permanent so I dont have to Copy Paste it into the termnial for every reboot?

Ty.
brutti
 
Posts: 9
Joined: Fri Jun 12, 2009 5:20 pm

Re: Pokertracker 3 & PostgreSQL on MAC

Postby kraada » Thu Aug 09, 2012 1:45 pm

This tutorial explains how to set it up permanently.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Pokertracker 3 & PostgreSQL on MAC

Postby heimps9 » Tue Sep 04, 2012 8:24 pm

Hi,

I am having the exact same issue. I tried going to Terminal and typing:

sudo su postgres -c '/Library/PostgreSQL/9.0/bin/pg_ctl -D /Library/PostgreSQL/9.0/data/ restart'

but then it says this:

"su: unknown login: postgres"

Any suggestions on how I should respond?

Thanks
heimps9
 
Posts: 21
Joined: Tue Sep 04, 2012 8:18 pm

Re: Pokertracker 3 & PostgreSQL on MAC

Postby kraada » Wed Sep 05, 2012 7:56 am

That implies that PostgreSQL is not installed - try re-running the installer located here.
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Pokertracker 3 & PostgreSQL on MAC

Postby dylanstark » Sat Nov 24, 2012 6:29 am

kraada wrote:Open Applications -> Utilities -> Terminal and at the terminal paste in this:

sudo su postgres -c '/Library/PostgreSQL/9.0/bin/pg_ctl -D /Library/PostgreSQL/9.0/data/ restart'

and hit enter. Enter your Mac password (it won't show *s but it is working) and hit enter.

Then try again.


I've been having troubles with this too, I did what you suggested and terminal returned:

pg_ctl: PID file "/Library/PostgreSQL/9.0/data/postmaster.pid" does not exist
Is server running?
starting server anyway
pg_ctl: could not read file "/Library/PostgreSQL/9.0/data/postmaster.opts"
dylan-starks-macbook-pro-2:~ dylanrocks12$


and still no luck, any suggestions?
dylanstark
 
Posts: 4
Joined: Sat Nov 24, 2012 6:22 am

Re: Pokertracker 3 & PostgreSQL on MAC

Postby kraada » Sat Nov 24, 2012 9:55 am

Run this at the terminal and tell me the output:

su -c 'ls /Library/PostgreSQL/9.0/data/'
kraada
Moderator
 
Posts: 54431
Joined: Wed Mar 05, 2008 2:32 am
Location: NY

Re: Pokertracker 3 & PostgreSQL on MAC

Postby dylanstark » Sat Nov 24, 2012 5:38 pm

this is what came back:

su: illegal option -- c
usage: su [-] [-flm] [login [args]]
dylanstark
 
Posts: 4
Joined: Sat Nov 24, 2012 6:22 am

Re: Pokertracker 3 & PostgreSQL on MAC

Postby tarix » Sun Nov 25, 2012 3:14 am

The command for Mac is:

sudo ls /Library/PostgreSQL/9.0/data/
tarix
Developer
 
Posts: 3760
Joined: Tue May 20, 2008 2:49 pm

Next

Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 7 guests

cron