virtualbox.org

I have been trying a few different things without success but i have to admit I am not exactly sure what I am doing.

I want to install PostgreSQL on my Ubuntu Guest and access the DB from my Windows 7 installation.
If I get all this working I will repeat the process with a live system.

So far I have installed PostgreSQL and confirmed it is working. Now I am lost as to how to get Win7 to communicate. I think I need a Static IP Has anyone already done this or similar?

I do need for the guest to have a static IP....

If there is a router in the network set the guest network to bridged and the best way is to set the IP adddress as static so it will not change.
If there is no router then for testing purpose you can use host-only network in the guest and add a 2nd adapter set to NAT if the guest needs to get to the Internet.

See Chapter 6. Virtual networking in your VirtualBox users guide.

As for setting up the guest that actually falls outside the scope of this forum. Depending on what the guest is you can ask the forum there for tutoring.
For Ubuntu that would be http://ubuntuforums.org/