Home > Blogs > VMware vFabric Blog

New VMware vFabric Postgres 9.2 Release: Install a Postgres Machine in 5 Minutes

Last week we announced VMware vFabric Postgres 9.2 is now available. This new release standardizes its core with the open source PostgreSQL and further simplifies the installation, operation and management of PostgreSQL for virtualized and cloud environments.

Installing the new version of vFabric Postgres using the appliance available on VMware website is straightforward and simple.

You do not need more than a couple of minutes to have a Postgres server available for your applications. It will be deployed pre-configured to simplify operations on virtualized environments such as the VMware vSphere server. The download will come with several install steps completed automatically, including:

  • postgresql.conf settings automatically tuned to the VM memory
  • SSL configuration on server side immediately available
  • Initial machine and database server accounts set up with the same single password
  • User interface to control both the VM core and the database server

In order to set up this server and that many interfaces all at once, you do not need to spend that 5 minutes in front of your screen, and everything can be done in 3 simple steps.

Prepare the Virtual Machine

Start by first downloading the appliance available as an Open Source Virtual Appliance (OVA file) or RPM package.

I personally recommend the use of the OVA file as it is directly pluggable with one of available VMware virtualization platforms like vSphere, Fusion, Workstation or Player. Please refer to the product documentation for more details on the installation depending on the platform you use.

As a personal choice, importing the OVA file of vFabric Postgres to Fusion has not needed more than 30 seconds. It simply takes the time to click on File -> Import and load the OVA file.

You can find your vFabric Postgres in your list of virtual machines.

Initial setup

Launch the newly-created vFabric Postgres instance by double-clicking on its entry in the virtual machine list or power it on. What you will see next is a screen explaining the license agreement, be sure that you understood it, then scroll down and accept it to continue the setup process.

After setting some SSL certificates used by the virtual machine, it is time to set up the initial password for all the accounts available at the instance first boot. Those user accounts are “root” and “postgres” for the virtual machine itself and “postgres” for the database server.

NOTE: After the virtual machine is up, you can customize the password for the virtual machine with command “passwd” for each VM user, and for the database server by using ALTER COMMAND for database users.

Run Your Database

Now that the initial settings are done, the virtual machine will log into this screen at each boot.

The user interface of core server is available using a simple web browser by connecting to the port 5480 via https, so connect to it with the URL:


NOTE: In the example here, the IP was assigned by DHCP and became, so in this case the connection URL became

Next, you will need to use a VM account to log in. At startup, this account needs to be “root”.

The user interface of database server is also available with a web interface by connecting to the port 8443 of the virtual machine via https, so connect to it with the URL:


NOTE: Again, in the example here the IP assigned by DHCP was, so the connection URL became

From the login screen, use account “postgres” and login.

Finally, connect to your database inside the virtual machine with this command: /opt/vmware/vpostgres/current/bin/psql

Then you can begin and play with your ready-and-tuned server.

You can also connect to your server directly by using the same client applications or drivers as PostgreSQL without a problem. For example, use the following simple PSQL command to login:

psql -p $IP_ADDRESS -U postgres postgres

For the VM used in this post, IP_ADDRESS simply became

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.

15 thoughts on “New VMware vFabric Postgres 9.2 Release: Install a Postgres Machine in 5 Minutes

  1. Pingback: Dynamic Memory Management of vFabric Postgres | VMware vFabric Blog - VMware Blogs

  2. خرید vps

    This entry was posted in Postgres and tagged cloud.

  3. عکس هنرمندان

    pic & photo

  4. موزيک روز دنيا


  5. معرفي بازي

    perfect post

  6. content4u.in

    bm,vcbvm,cm hdsujsdygsyu iuoroiegtrieogter

  7. apnapaisaa.in

    fgfglfglfl; ,mbmbvbfgborpgo

  8. ekrishinaip.in

    dfigojfdigjfdgijo jigofgfdsgoifgif

  9. Horizon View Components

    VMware Certified Advanced Professional 6 (Desktop and Mobility Deployment) – The industry-recognized VCAP6-DTM Deploy certification validates that you know how to deploy and optimize VMware Horizon 6 (with View) environments. It proves that you have the understanding and abilities essential to leverage best practices to provide a scalable and dependable Business Mobility platform for your company. Some of the subjects involve: Configuring and managing Horizon View components, configuring cloud pod archituecture, configuring Group Policy settings related to Horizon View, Configuring and optimizing desktop images for Horizon View & Mirage, Configuring and managing App Volumes AppStacks, Configuring desktop pools, Configuring and deploying ThinApp packaged applications, Configuring VMWare Identity Manager, etc.Szumigalski.com was created by Sebastian to propagate his passion for PowerShell & VMWare. Sebastian is an IT skilled professional employed in Singapore for more that 15 years who’s continually searching for innovative expertise to develop his technical abilities & understanding. Since then, Sebastian has became a member of PowerShell User Group & VMWare VMug group, and has been getting involved in all of the events held in Singapore. This blog will disclose precisely how Sebastian manage to automate his every day work by making use of PowerShell. You can get study guides accessible for the VCAP6-DTM examination, which were personally compiled by Sebastian. Sebastian is qualified with VCAP6-DTM, and is very strong with virtualization & server maintenance from four years experience in automation. The interest in VMWare prepared admins and technicians are ever-increasing in the current technology industry. Start to learn more about PowerShell & VMWare with Szumigalski.com!

    1. خرید بلیط اتوبوس

      no way

  10. تیم لذت خرید

    درآمد عالی و فوق العاده داشته باشید بدون اینکه زمان زیادی بگذارید . تنها با چند کلیک مادام العمر از ما درخواست واریز وجه کنید ؛ ظرفیت محدود .
    هر چه سریعتر به سایت لذت خرید مراجعه کنید.

  11. تزریق-ژل

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

  12. پروتز-گونه

    پروتز گونه پروتز-گونه پروتز گونه پروتز-گونه پروتز گونه پروتز-گونه

  13. carlosa

    دیابت ( diabetics ) نزد پزشکان اغلب به نام مرض قند شناخته می‌شود . که در آن بیمار دارای قند خون بالا است. دلیل آن نیز تولید انسولین کم توسط بدن است یا اینکه بدن به درستی انسولین مورد نیاز را تامین نمی‌کند.
    بیمارانی که به این بیماری دچارند معمولاً ادرار مکرر را تجربه می‌کنند. و بیشتر وقت‌ها گرسنه و تشنه هستند.
    آیا میدانید دیابت چبست و علائم قند خون بالا چگونه است ؟
    دیابت یک بیماری دراز مدت است که باعث افزایش سطح قند خون می‌شود.
    دیابت نوع ۱ – بدن انسولین تولید نمی‌کند حدود ۱۰% بیماران از نوع یک می‌باشند.
    دیابت نوع ۲ – بدن برای کارهای خاص انسولین مناسب تولید نمی‌کند تقریبا ۹۰% از دیابتی های جهان از این نوع هستند.
    دیابت بارداری – این نوع در بین زنان در زمان بارداری شایع است.
    دیابت یا قند خون چیست
    شایع ترین علائم دیابت :
    ادرار مکرر
    تشنگی شدید
    افزایش یا کاهش وزن غیر معمول
    کبودی غیر قابل درمان
    اختلال عملکرد جنسی مردان
    بی حسی
    سوزش در دست و پا
    عطش پا
    عطش دست
    سردی بیش از حد پا
    اگر دیابت شما از نوع ۱ باشد، می‌توانید با ورزش کافی و مصرف انسولین یه زندگی عادی داشته باشید.

  14. قیمت فرش 1200 بهشتی تبریز

    thanks vmware


Leave a Reply

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