Home > Blogs > VMware vFabric Blog

How to Use the New GUI Features in vFabric Postgres 9.2

People have said code is poetry and information is beautiful, but let’s talk about graphical user interfaces (GUI) and ease of use.

The PostgreSQL community has a multitude of choices when it comes to GUIs versus CLI. For vFabric Postgres, we’ve added some cool, new GUI tools.

In part one of this two-part series on vFabric Postgres user interfaces, we look at the built-in GUI capabilities within the VM of the latest release—vFabric Postgres 9.2. Based on VMware Studio, vFabric Postgres 9.2 uses an instinctive user interface to fully control the behavior of the database virtual machine and allows you to perform basic tasks that are normally associated with an OS. In part 2, we will cover the key features of the database server’s new GUI and explain how to get overview-level information and see both processes and locks.

Connecting to the VM-based GUI

Once the virtual machine is booted and active, the interface is accessible at port 5480 via https. So, if the IP address of the virtual machine is, like in this post’s example, you can type the URL in your web browser to connect.

When trying to connect, your web browser might complain that this site could represent a risk to the security integrity of your machine. However, it is your own machine, and you do not really need to worry about this issue because you know what app it is. Just add the VM as a security exception and bypass the alert.

Once logged in, there are 3 main options within the UI’s top-level navigation—system, network, and update.

The vFabric Postgres System UI

System is divided in 2 tabs—the first tab contains a minimal but essential set of system information.

The system information printed on this page is something you would obtain similarly with uname -a type commands. This page also contains a couple of buttons that allow you to stop or reboot the virtual machine. The second tab allows you to control the time zone. This has a direct impact on the vPostgres database server—it is the system time zone.

The vFabric Postgres Network UI

The second menu of the user interface is related to the network settings of the virtual machine.

By default, the virtual machine will try to assign an IP using a DHCP. However, you can also set up a static IP or proxy server depending on the needs of your environment.

The vFabric Postgres Update UI

The third menu of the UI is dedicated to server updates. It is divided into two separate tabs—status and settings.

The first tab, status, allows you to check the current version of the appliance. You can also check for available updates directly from the VMware servers. If updates are available, you can also install them right from the user interface.

The second tab, settings, allows you to decide how updates are managed inside the virtual machine and choices include no automatic updates, automatic checks, and automatic check and installs

You can either automatize the updates with VMware servers, or use several manual options like a CD-ROM or remote repository. This becomes particularly useful when you want to build a cluster of vFabric Postgres nodes.

About the Author: Michael Paquier is a member of PostgreSQL technical staff at VMware. He is involved for many years with community development of PostgreSQL and Postgres-XC, and has worked on multi-master database technologies. He has also interest in parallel query processing and concurrent SQL processing.

25 thoughts on “How to Use the New GUI Features in vFabric Postgres 9.2

  1. Pingback: Exploring the New Database Server GUI Features in vFabric Postgres 9.2 | VMware vFabric Blog - VMware Blogs

  2. Pingback: How to Perform Security Updates on vFabric Postgres | VMware vFabric Blog - VMware Blogs

  3. cheap windows server

    Hey There. I found your blog the usage of msn. That is an extremely neatly written article. I will be sure to bookmark it and come back to read more of your helpful information. Thanks for the post. I’ll certainly return.

  4. خرید سرور مجازی ایران

    Buy VPS and Dedicated Servers

  5. دانلود اسکریپت


  6. موزیک جدید

    موزیک جدید

  7. غرفه سازی

    غرفه سازی

  8. جراحی پلک

    جراحی-پلک جراحی-پلک جراحی-پلک جراحی-پلکجراحی-پلکجراحی-پلک!!!

  9. کاشت-مو

    کاشت-مو کاشت-مو کاشت-مو !!!! کاشت-مو

  10. تور دبی

    gooood information good

  11. jhon

    Good info i will do it

  12. jhon

    Nice thoughts

  13. بهترین زمان خرید بلیط هواپیما

    بلیط هواپیما [Airline tickets] می خواهید؟  بلیط هواپیما از سایت معتبر تیک بان را تجربه کنید که به صورت اینترنتی می توانید خرید کنید و هم از گارانتی بلیط هواپیما ارزان تیک بان بهره مند شوید. تیکبان یکی از بهترین سایت های خرید بلیط هواپیما می باشد و همیشه مشتری مداری را به عنوان شاخص فعالیت خود در نظر گرفته است و هر روز می کوشد که رضایت خاطر مشتریان را جلب کند.

  14. https://keramatzade.com/



  15. فروشگاه خرید بذر

    سلام بچه ها حتما به سایت پایین سر بزنین

  16. پوشک بزرگسال

    thanks your page

  17. buyplaystation

    thanks for this stuff.

  18. لیست قیمت ساندویچ پانل


  19. خرید موکت پالاز طرح الماس

    thanks vmware

  20. datemania.net

    In fact, such posts are most useful to the reader for this very reason, I am your old fan, thanks for your work!

  21. غرفه سازی

    In fact, such posts are most useful to the reader for this very reason, I am your old fan, thanks for your work!

  22. غرفه سازی


  23. استراتژی

    good job

  24. فیروزه بازار

    nice post

  25. ترجمه تخصصی مقاله

    مقاله نویسی یکی از بهترین راهکارهای ارائه مطالب جدید در سطح بین المملی ست. یکی از مهم ترین اصول برای نوشتن یک مقاله خوب خواندن تعداد زیادی مقاله ی معتبر است که اکثر آنها به زبان انگلیسی هستند. اگرچه ممکن است به نظر برسد که ترجمه مقاله ها کاری آسان و راحت است اما به دلیل نوع نوشتار تخصصی آن ها و استفاده از اصطلاحات تخصصی ترجمه اشتباه باعث عوض شدن مفهوم جملات میشود. به همین علت تیم ترجمه انلاین با کادری حرفه از با سابقه ترین مترجمین کشور با ارائه ترجمه تخصصی مقاله های مورد نیاز شما آماده است تا مسیر مقاله نویسی را برای شما هموار کرده و در راه به شما یاری برساند.


Leave a Reply

Your email address will not be published. Required fields are marked *