Rush/Zoom/Strobe - Mac/VM/Ahhhhhhhh!

[Herr_Someone]

The relevant bit looks lke this :

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
host all all 192.168.1.0/24 md5

Sorry for the poor formatting.

[kraada]

Are you sure that the VM uses that same 192.168.1.x subnet? Often VMs create their own dedicated subnets for contacting the host and then you'd want to set up a line for that as well.

[Herr_Someone]

Ah now that's not something I know. How can I find that out? By ipconfig in my guest? If its different would I then need to set up a new connection as I did from host to guest?

[kraada]

ipconfig within the guest is normally sufficient to figure it out. Just add another line to pg_hba.conf to account for that subnet, restart the server, and then you'll likely be able to connect.

[Herr_Someone]

So after going into ipconig and finding the IP address, my pg_hbs.conf file now looks like this:

# TYPE DATABASE USER CIDR-ADDRESS METHOD

# "local" is for Unix domain socket connections only
local all all md5
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
host all all 192.168.1.0/24 md5
host all all 10.0.2.15/24 md5

I'm still getting cant connect to database errors. If it helps, I did just experience my guest not connecting to the 192.168.1.xx server. I had to restart a couple of times and it then connected.

[kraada]

Try making it:
host all all 10.0.2.0/24 md5

just to be on the safe side, restart everything and try one more time.

[Herr_Someone]

So I've tried that, still got the cant connect to database error, and reverted back to how the file was previously; and now I'm getting the error attached on my original PT4 installation. This shouldn't have happened surely? Have I now lost my original database?

[kraada]

At a Terminal run ps aux | grep -i postgres and paste your output here.

[Herr_Someone]

Here you go:

postgres 363 0.0 0.0 2497484 1264 ?? S 8:13pm 0:00.02 /usr/sbin/cfprefsd agent
postgres 362 0.0 0.0 2524780 1720 ?? S 8:13pm 0:00.02 /usr/sbin/distnoted agent
postgres 353 0.0 0.0 2508236 972 ?? Ss 8:13pm 0:00.02 /sbin/launchd
tomrankin 1072 0.0 0.0 2432768 632 s000 R+ 10:22pm 0:00.00 grep -i postgres
postgres 463 0.0 0.2 2512804 8612 ?? SN 8:14pm 0:00.67 /System/Library/Frameworks/CoreServices.framework/Frameworks/Metadata.framework/Versions/A/Support/mdworker -s mdworker -c MDSImporterWorker -m com.apple.mdworker.shared

[kraada]

PostgreSQL is definitely not running. Look in Console - do you see errors relating to PostgreSQL? If so, what do they say?