Postgresql on MAC OSX and PT4 on VMware

[th1L0]

Hi,

I own a MacBook Pro with OSX installed and want to play Zoom with a HUD. I understood that I should install Pokerstars and Pokertracker 4 in VMware (Win7) and postgresql on my OSX system (which would also allow me to play everything else than Zoom in OSX). So far, so good (installation done).

BUT: How do I access the postgresql DB from VMware? Sorry, but I am a noob in all these DB and networking configuration things.

Is there a step-by-step tutorial somewhere? Or anything else that could help me?

Thanks lot in advance, Thilo

[kraada]

The way to do this is to configure PostgreSQL to allow other machines on the VMWare's virtual subnet to be able to connect. See here for details on how to configure PostgreSQL to allow other machines to connect, and you can find your VMWare machine's IP address by clicking Start, typing cmd, clicking on it and typing ipconfig /all and hitting enter. It will be listed as the IPv4 Address.

[th1L0]

Already found the propposed tutorial.

BUT: Where are these files located: pg_hba.conf & postgresql.conf? I cannot find them on my MAC, neither Postgresql's Library nor in the Program folder.

Would it be possible to post a step-by-step solution that clearly shows what needs to be done on the MAC side and on the WIN side?

[kraada]

By default on OS X once PostgreSQL is installed they're in /Library/PostgreSQL/x.y/data/ where x.y is your version (at this point we recommend 9.0).

[th1L0]

Ok, I found the files.

But if follow the instructions from IP Address from the Local Network (https://www.pokertracker.com/guides/PT4/tutorials/postgresql-server-hosted-on-a-local-network#ip-address-for-the-local-network), I receive this:

OSX: ifconfig

lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> mtu 16384
options=3<RXCSUM,TXCSUM>
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x1
inet 127.0.0.1 netmask 0xff000000
inet6 ::1 prefixlen 128
gif0: flags=8010<POINTOPOINT,MULTICAST> mtu 1280
stf0: flags=0<> mtu 1280
en0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
options=2b<RXCSUM,TXCSUM,VLAN_HWTAGGING,TSO4>
ether 58:b0:35:f2:38:d3
media: autoselect (none)
status: inactive
en1: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
ether 58:b0:35:73:1c:3c
inet6 fe80::5ab0:35ff:fe73:1c3c%en1 prefixlen 64 scopeid 0x5
inet 192.168.2.52 netmask 0xffffff00 broadcast 192.168.2.255
inet6 2003:62:460d:c101:5ab0:35ff:fe73:1c3c prefixlen 64 autoconf
inet6 2003:62:460d:c101:353c:dd48:6c0a:6251 prefixlen 64 autoconf temporary
media: autoselect
status: active
p2p0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> mtu 2304
ether 0a:b0:35:73:1c:3c
media: autoselect
status: inactive
fw0: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 4078
lladdr d8:30:62:ff:fe:ec:44:e8
media: autoselect <full-duplex>
status: inactive
vmnet1: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
ether 00:50:56:c0:00:01
inet 192.168.212.1 netmask 0xffffff00 broadcast 192.168.212.255
vmnet8: flags=8863<UP,BROADCAST,SMART,RUNNING,SIMPLEX,MULTICAST> mtu 1500
ether 00:50:56:c0:00:08
inet 192.168.185.1 netmask 0xffffff00 broadcast 192.168.185.255

There are three lines with 192.168.x.x in it - in these, the third digit is "2", "212" and "185" - none of them is a "0" or a "1" desired in the article.

So, what do I have to do now?

(Sorry for asking possibly stupid questions)

[th1L0]

Oh, and another question: How do I add the database to PT4 (on VMware)? What do I have to enter in the database management dialogue?

[th1L0]

And the last one: Maybe you could move my thread to the right forum? (as I posted it in Pokertracker 3 - but am actually looking for a solution for PT4)

[kraada]

I think vmnet1 is the VMWare one - that's 192.168.212.1 so use 192.168.212.0/24. Once you've gotten the networking set up you can either create the database in PT4 in VMWare or connect to the one you already have from OS X - you can search for existing databases with the blue Browse Databases link in the Database -> Database Management -> New window.

[th1L0]

I used 212 and added

host all all 192.168.212.0/24 md5

to pg_hba.conf (OSX) as an additional line at the bottom of the document. I also added

listen_addresses = '*'

as the last line to postgresql.conf as last line.

But I still can't find my OSX databases (even just created test-databases) in the windows PT4 by searching for them via the blue link in the DB management dialogue.

So what am I doing wrong? (I have postgresql installed on my vmware windows system - in case that matters)

[th1L0]

I just checked: Turning on VMware adds vmnet1 & vmnet2 to the output of ifconfig.