Hi guys, I am 100% new to these virtual machine computers, so I had to do quite a bit of learning until I reach the point where things are working.
Now I have two questions, which I hope the experts enlighten me by answering.
1-) Why is it necessary for us to create this virtual machine inside our computer to set up a MB server mirror on our computer? Couldn’t it be accomplished much simpler with an ordinary program/software, instead of having to resort to this complicated virtual machine concept? What are the advantages of having this virtual machine emulating an Ubuntu OS in our computers and running “parallel” to them? Note this is not a critique, it’s just a question, I know nothing about this.
2-) Once we set up our MB server mirror we can run queries on it using PostgreSql (really glad I know SQL well, from working with Oracle, SSMS and even SAS, otherwise I wouldn’t get past this step). The question is, why can’t I run psql pointing to the actual MB server instead of the one I just set up? What is the advantage of running a Sql query on the “local” server I set up instead of the actual remote MB server?