PT4 beta *Virtual Machine* posts

[kraada]

You'll get much better performance in general if you run PostgreSQL in your Mac directly and just connect from the VM.

[G3K0]

You'll get much better performance in general if you run PostgreSQL in your Mac directly and just connect from the VM.

Indeed, I've gone down this route - what I mean is:

after installing the .17 release onto the Win 7 VM, I was greeted with the 'DB Tuning Tool' message on first run-time.
this closed out, I presume as the postgresql install is on the host environment; however, the report return performance in PT4 was affected.

It would appear that going to PT4 / db management / restore to previous PostgreSQL settings (prior to db tuning) does what it says on the tin.

Might I then presume that the db tuner has 2 functions a) amends the PostgreSQL settings (memory allocation etc all beyond my reckoning) and b) amends the PT4 settings to best utilize these new PostgreSQL settings?

If that assumption is correct it would appear that the DB Tuner, in a hosted environment, nerfed my PT4 but left the SQL db alone as it wouldn't have been designed to communicate with the host OS install. ??

Cheers for the almightily fast response Kraads.
H

[kraada]

I don't think the tuner changes anything other than the setting in postgres.conf but I'll check to be certain for you.

Edit: The tuner only stops PostgreSQL, applies the changes, and restarts it. If you have PostgreSQL located remotely (e.g. in a host OS) nothing is changed.

[Dereku]

You'll get much better performance in general if you run PostgreSQL in your Mac directly and just connect from the VM.

How would one go about this using osx Lion as the host and XP as the guest via virtual box?

[G3K0]

You'll get much better performance in general if you run PostgreSQL in your Mac directly and just connect from the VM.

How would one go about this using osx Lion as the host and XP as the guest via virtual box?

all links for this are in post #2 of this thread =]

you essentially edit your host Postgres DB settings to allow access to an IP number, assign your PC a fixed IP number and then tell PT4 in VirtualBox to connect via that IP connection. That's the short version.

[Dereku]

I'm running 10.7.4 on a 2008 aluminum macbook, 2.0 c2d 8gb ram, 256 SSD.

attempting to run PT4 inside of XP via VirtualBox.

I've had PT3 working successfully on the host machine for a while now, so the PostgreSQL should be installed correctly?

I believe I have everything setup according to the instructions. Here are some screen shots:











Not sure what I'm doing wrong. Any help is very much appreciated!

[_dave_]

edit: nevermind. was about pg_hba.conf but looks OK now I check again

edit2: list your IP addresses for both the host mac and the VM. the config dialog shows 192.168.0.196, the error is trying to connect to 192.168.0.1 (this is likely a router?)

[Dereku]

edit: nevermind. was about pg_hba.conf but looks OK now I check again

edit2: list your IP addresses for both the host mac and the VM. the config dialog shows 192.168.0.196, the error is trying to connect to 192.168.0.1 (this is likely a router?)

I tried both addresses' resulting in both errors

[G3K0]

I'm not too sure if this makes a difference?
I checked my postgresql.conf file and my listen_addresses = '*' all line is under the connections section

Code: Select all

#------------------------------------------------------------------------------
# CONNECTIONS AND AUTHENTICATION
#------------------------------------------------------------------------------

# - Connection Settings -

listen_addresses = '*'      # what IP address(es) to listen on;

it looks like that's just commented notes, which as _dave may have been referring to, looks fine.

Can you post your ipconfig results from within Windows along with your ifconifg result from Mac terminal?
Might be something small/typo...

[kraada]

Can you post your ipconfig results from within Windows along with your ifconifg result from Mac terminal?
Might be something small/typo...

That was going to be my next question as well