ESX Virtualization

VMware ESXi, vSphere, VMware Backup, Hyper-V... how-to, videos....

Menu
  • Shop
    • Datacenter
      • vSphere Essentials
      • vSphere Essentials PLUS
      • vSphere Standard
      • vSphere with Operations Management
      • vCenter Server Standard
      • vSphere Remote Office Branch Office
    • Desktop
      • VMware Workstation Pro
      • VMware Fusion Pro
      • VMware Fusion
      • Player Pro
    • Datacenter and Cloud
      • VMware SRM
      • vCenter Server Editions
    • Desktop
      • VMware Mirage
      • VMware Socialcast
      • Horizon Flex
      • VMware Horizon
    • Close
  • Study Guides
      • VCP6.7-DCV
          • VCP6.7-DCV 2019
        • Close
      • VCP6.5-DCV
          • VCP65-DCV-cert
        • Close
      • VCP6-DTM
          • VCP6-DTM
        • Close
      • VMware Mirage
          • mirageVMware Mirage
        • Close
    • Close
  • VMware
    • Configuration Maximums
    • vSphere
      • vSphere 6.7
      • vSphere 6.5
      • vSphere 6.0
      • vSphere 5.5
      • vSphere 5.1
      • Close
    • VMworld
      • VMworld 2019
      • VMworld 2018
      • VMworld 2017
      • VMworld 2016
      • VMworld 2015
      • VMworld 2014
      • VMworld 2013
      • VMworld 2012
      • VMworld 2011
      • Close
    • Close
  • Microsoft
    • Windows Server 2012
    • Windows Server 2016
    • Windows Server 2019
    • Close
  • Categories
    • Tips – VMware, Microsoft and General IT tips and definitions, What is this?, How this works?
    • Server Virtualization – VMware ESXi, ESXi Free Hypervizor, VMware vSphere Server Virtualization, VMware Cloud and Datacenter Virtualization
    • Backup – Virtualization Backup Solutions, VMware vSphere Backup and ESXi backup solutions.
    • Desktop Virtualization – Desktop Virtualization, VMware Workstation, VMware Fusion, VMware Horizon View, tips and tutorials
    • How To – ESXi Tutorials, IT and virtualization tutorials, VMware ESXi 4.x, ESXi 5.x and VMware vSphere. VMware Workstation and other IT tutorials.
    • Free Stuff – Free virtualization utilities, ESXi Free, Monitoring and free backup utilities for ESXi and Hyper-V. Free IT tools.
    • Videos – VMware Virtualization Videos, VMware ESXi Videos, ESXi 4.x, ESXi 5.x tips and videos.
    • Home Lab
    • Reviews – Virtualization Software and reviews, Disaster and backup recovery software reviews. Virtual infrastructure monitoring software review.
    • Close
  • Partners
    • Altaro
    • NAKIVO
    • StarWind
    • Veeam
    • Vembu
    • Zerto
    • Close
  • This Web
    • News
    • ESXi Lab
    • About
    • Advertise
    • Archives
    • Disclaimer
    • IT Books
    • Close
  • Free Tools
  • Books

How-to Connect to vCenter 6 vPostgress Database with PgAdmin

By Vladan SEGET | Last Updated: May 19, 2015

Shares

vCenter Server 6.0 is using by default the internal vPostgress Database. If you chose this option during the installation over an SQL server installation you basically lose the possibility to manage this DB, unless you install some vPostgress management tool. One of those tools is PgAdmin and in this post we will take a look on How-to Connect to vCenter 6 vPostgress Database with PgAdmin.

First thing to do is to go to the PgAdmin website and download the version you want. They have Linux, Windows or Mac OSX versions available for download. In this guide we'll use the Windows version as I'm managing the lab vCenter from Windows box.

I used the default installation setup.

How-to use PgAdmin for vCenter 6 and vPostgres Db

But then I run into an error on the system where I was installing the PgAdmin tool. The system was actually the vCenter server itself, which is Windows server 2012 R2 (x64). It seems that OOB the x64 systems throws and error on this, and I saw a thread where the user just took the 1.18 version instead.

That's what I done too in order to continue…

How-to use PgAdmin for vCenter 6 and vPostgres Db

Now we have a PgAdmin installed, but how to connect?

We have no error with 1.18 release of PgAdmin. Let's move on…

Step 1: Edit a configuration file caled vcdb.properties located in this directory

C:ProgramDataVMwarevCenterServercfgvmware-vpxvcdb.properties

It should look like this. Copy the password to the clipboard…

vPostgres DB properties PgAdmin

Step 2:  Connect to the Database with PgAdmin

Note that you'll have to first change another config file in order to accept TCP/IP requests from your management machine. (Source: PgAdmin.org Documentation) To do this just edit

pg_hba.conf file located at this directory:

C:ProgramDataVMwarevCenterServerdatavpostgrespg_hba.conf

You can add a line there in this format

host       all       all       your_ip/24       md5

Connect to vCenter 6 vPostgres Database with PgAdmin

Note that you'll need to restart the postgres Windows service to validate this config file….

Then go back to the PgAdmin UI and enter the user name (vc) and password you previously copied from the vcdb.properties file…. like this

PgAdmin Connection to vCenter 6 Database vPostgres

And then hit the OK button to connect to the vCenter DB. You can expand the individual catalogs, schemas and tables or views the same way you would do it through SQL server management studio….

How to connect to vCenter DB vPostgres via PgAdmin

This is it. Now I'm not a fan doing some manual edits, but I usually like to have a GUI utility to be able to browse the DB tables, functions and stored procedures just in case. If there is a problem I usually tempt to restore from recent backup (if available) first. You might want to check another post I've done where you'll see How to backup (and restore) vCenter database on Windows with a VMware script.

With that said, check also latest How-to, news and videos about vSphere 6 on a dedicated vSphere 6 page here.

 

Shares

| Filed Under: Server Virtualization Tagged With: Connect to vCenter 6 vPostgress Database with PgAdmin 5 Comments

About Vladan SEGET

This website is maintained by Vladan SEGET. Vladan is as an Independent consultant, professional blogger, vExpert x11, Veeam Vanguard x5, VCAP-DCA/DCD, VCP, ESX Virtualization site has started as a simple bookmarking site, but quickly found a large following of readers and subscribers.

Connect on: Facebook. Feel free to network via Twitter @vladan.

Comments

  1. Dejan says

    May 20, 2015 at 2:34 pm

    Hi Vladan

    I am using vCenter applianace almost from the first release. OK, there were some bugs (database has used all space) but after I opened case, they efficently release new patch to address this situations.

    If you stick to “normal” operations, with normal number of hosts, no FT etc, I do not see why would I use classical vCenter.

    I am asking, what is your experience with vCenter appliance and why do you hold on to classical vCenter if we exclude the fact, that it is OK to stay in touch with new technology.

    Regards, Dejan

    Reply
    • Vladan SEGET says

      May 20, 2015 at 4:05 pm

      While in some cases the client do not mind having a vCenter as VCSA, in majority cases they (still) prefer Windows. They are use to have GUI, and additionally they can also install other stuff (even If I don’t recommend that).

      As for myself, in my lab I have both.

      regards,
      Vladan

      Reply
  2. Rafael Ferreira Sousa says

    February 1, 2016 at 10:08 pm

    I am a great admirer of your work.

    But recently, seeking in his articles ask you a question? It is possible to migrate the vCenter database that is in Postgres to SQL Server?

    When former manager set up our vCenter he made the installation in embedded mode.

    Today acquired SQL Server 2012, after the bank always corrupt when the host had to be restarted.

    Reply
  3. stephen says

    March 20, 2016 at 11:04 pm

    I read this article because I have recently removed a Operations Manager with out un registering now its permanent stuck in my web client under related objects, and when I install a new one 2 show there even though the 1st one is a dead link. I was hoping I could find this dead link in the database to remove. All other tutorials only specify how to remove broken extensions but in this case there is no extension. How do you clean this out of the web client?

    Reply
  4. Wojciech Marusiak says

    April 5, 2016 at 6:11 pm

    Very useful article Vladan.

    Reply

Leave a Reply Cancel reply

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

Nakivo Backup and Replication
Zerto 7Vembu Backup and Replication
Click to Become a Sponsor

Featured

  • Free Backup for VMware and Hyper-V - NAKIVO Backup & Replication
  • FREE Forever—Back up VMware with Altaro VM Backup. Grab your Free copy now!
  • WinX DVD Ripper Platinum Giveaway - 1:1 Copy DVD to ISO,MP4

Most Recent

  • StarWind VSAN has a high level of customization
  • VMware vSphere 6.7 U3b Released
  • Veeam Backup for AWS Free Version Released
  • Cheapest way of going virtual with StarWind Virtual SAN (VSAN)
  • Physical Server Backup, Workstation or Laptop with Nakivo Backup and Replication
  • Download Free Load Balancer for VMware vSphere
  • Fight Ransomware with Veeam 10 Immutability Feature
  • StarWind VSAN Graceful Shutdown and PowerChute Configuration
  • Are You Aware of the Most Common Phishing Attacks?
  • Altaro Office 365 Backup New Features Added

Most Liked

  • VCP6.7-DCV Study Guide - VCP-DCV 2019 certification
  • VCP6.5-DCV Study Guide
  • vSphere 6.5
  • Veeam Backup and Replication 9.5 Update 4 Announced
  • VCP6.5-DCV Objective 4.3 - Perform vCenter Server migration to VCSA

Fast NVMe Storage


Virtualization Software From VMware

  • VMware vSphere 6.7 U3b "Essentials PLUS" - vMotion, vSphere Replication...Included
  • VMware vSphere 6.7 U3b "Essentials" - 3 hosts, vCenter
  • vSphere Hypervisor Per Incident Support Click Here.
  • VMware Workstation 15.5 Pro and Upgrades - Best Desktop Virtualization Software
  • VMware Fusion 11.5 - Run Windows on MAC, and Upgrades
  • VMware Fusion 11 Professional - Restricted VMs, Virtualized VT-X/EPT... and Upgrades
**************************************************************************
  • Upgrade to vSphere Editions
  • Upgrade to vSphere Enterprise Plus
  • Upgrade to vSphere with vSOM Enterprise Plus
  • Upgrade to vSphere with Operations Management Editions
  • Upgrade to vSphere with Operations Management Enterprise Plus

Free Software

Altaro VM Backup – Protect your VMware and Hyper-V VMs for Free with Altaro VM Backup. 2 VM for Free, forever. Grab your copy now!
Veeam ONE Community (FREE) Edition 9.5 U4B – Download Now. monitor up to 10 instances of VMware, Hyper-V, Veeam Backup & Replication and Windows and Linux workloads!
Veeam Backup And Replication Community (FREE) Edition 9.5 U4B – protects up to 10 instances (VMs or Computers, laptops for Free.

Free Trials

Veeam Backup and Replication 9.5 Trial DownloadVeeam Backup & Replication 9.5 U4B Full Version Download (30 Days Trial – Get Your Copy !

YouTube

Find us on Facebook

ESX Virtualization

Copyright © 2019 ·Dynamik-Gen · Genesis Framework · Hosted with HostColor.com

X
Veeam Backup 9.5 U4B Community Edition
Download NOW
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok