The psql command above should be "psql openacs4".
If you succeed with the psql command, you can type "\d" to get a list of all the objects in the database. If you get a bunch of acs* tables, this should confirm that your db is fine.
Other debugging thoughts:
What you do get when you type ifconfig?
And what type of virtual network adapter is the VM using (bridged or NAT)?
Can you ping the VM from your host OS?